You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by brajmohan saxena <br...@gmail.com> on 2016/04/07 05:35:27 UTC
Hive SQL query
Hi,
Is there any SQL query or command to create server in Hive.
Also please let me know any API for creating server and retrieving server
info in JDBC.
Thanks
Braj
Re: Hive SQL query
Posted by Mich Talebzadeh <mi...@gmail.com>.
May I suggest that you go and read the docs about Hive.
One does not use SQL query to create server (I think you mean Hive
server2). It is already in the $HIVE_HOME/bin directory
$HIVE_HOME/bin/hiveserver2 &
You can use beeline to connect hive server2 via JDBC
$HIVE_HOME/bin/beeline -u jdbc:hive2://HOST:POPRT/default
org.apache.hive.jdbc.HiveDriver -n hduser -p xxxxxx
HTH
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 7 April 2016 at 04:35, brajmohan saxena <br...@gmail.com> wrote:
> Hi,
>
> Is there any SQL query or command to create server in Hive.
> Also please let me know any API for creating server and retrieving server
> info in JDBC.
>
> Thanks
> Braj
>
Re: Hive SQL query
Posted by Mich Talebzadeh <mi...@gmail.com>.
May I suggest that you go and read the docs about Hive.
One does not use SQL query to create server (I think you mean Hive
server2). It is already in the $HIVE_HOME/bin directory
$HIVE_HOME/bin/hiveserver2 &
You can use beeline to connect hive server2 via JDBC
$HIVE_HOME/bin/beeline -u jdbc:hive2://HOST:POPRT/default
org.apache.hive.jdbc.HiveDriver -n hduser -p xxxxxx
HTH
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 7 April 2016 at 04:35, brajmohan saxena <br...@gmail.com> wrote:
> Hi,
>
> Is there any SQL query or command to create server in Hive.
> Also please let me know any API for creating server and retrieving server
> info in JDBC.
>
> Thanks
> Braj
>