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 <braj.saxena...@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 >