> !connect jdbc:hive2://localhost:10000/default; -n hiveuser -p hivepassword ... > What's missing here? how do I fix it? Thank you very much
Mostly, this is missing the actual protocol specs - this is something which is never a problem for real clusters because ZK load-balancing automatically configures it. The HS2 is most likely running in HTTP mode, which needs additional parameters https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-ConnectionURLWhenHiveServer2IsRunninginHTTPMode My paths end up looking like jdbc:hive2://sandbox.hortonworks.com:10000/tpcds_flat_orc_2;transportMode=http;httpPath=cliservice? Cheers, Gopal
