Search code examples
javahadoopjdbchivederby

Where is the port number defined, which is used in JDBC hive connection string?

I have just started Hadoop and Hive programming, and I have written a Java code, which connects to a derby metastore, and gives proper output. The connection string I defined is:

jdbc:hive2://localhost:10000/default

The program works fine, and gives me the required output. But I would like to know where this port number 10000 is defined, and how to change this port number if required.

Solution

  • You can find all the hive related configuration details under Hive installation directory. File name is hive-site.xml like in my case file is present under this path /usr/hdp/current/hive-server2/conf

    There is a parameter defined with the name hive.server2.thrift.port in hive-site.xml file

    <property>
      <name>hive.server2.thrift.port</name>
      <value>10000</value>
 </property>