While following the Hive test bench tutorial, I got stuck on step 9, running the command:
beeline -i testbench.settings -u jdbc:hive2://localhost:10500/tpcds_bin_partitioned_orc_30
It gives me the following error:
Connecting to jdbc:hive2://localhost:10500/tpcds_bin_partitioned_orc_30 17/11/07 15:54:30 [main]: WARN jdbc.HiveConnection: Failed to connect to localhost:10500 Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10500/tpcds_bin_partitioned_orc_30: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0) Beeline version 1.2.1000.2.6.2.0-205 by Apache Hive 0: jdbc:hive2://localhost:10500/tpcds_bin_par (closed)>
How do I resolve this and connect to Hive with beeline?
Also can you please check if the Hive Interactive (LLAP) is enabled.
Ambari UI --> Hive --> Configs --> Enable "Interactive Query"
When I ran it with the option p, it gives the output:
(No info could be read for "-p": geteuid()=1011 but you should be root.)
However, when I ran:
netstat -tnla | grep 10500
It shows no output.
10500 is the default port (unsecure) for interactive query (LLAP). If you don't use LLAP then your port should be 10000, but it is even better to use Zookeeper ServiceDiscovery
beeline -i testbench.settings jdbc:hive2://localhost:2181/tpcds_bin_partitioned_orc_30;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
You may have to check on ZK port 2181 to be open.