Apache Hive

Beeline CLI

Transport Mode = http

If transport mode is http then need to add the following to the connection string:

;transportMode=http;httpPath=cliservice;

No Kerberos or SSL

beeline -u 'jdbc:hive2://${BEELINE_HOST}:${BEELINE_PORT}/'

Kerberos Only

kinit

beeline -u 'jdbc:hive2://${BEELINE_HOST}:${BEELINE_PORT}/;principal=hive/[email protected]'

SSL Only

beeline -u 'jdbc:hive2://${BEELINE_HOST}:${BEELINE_PORT}/;ssl=true;sslTrustStore=${TRUSTSTORE}.jks;trustStorePassword=${TRUSTSTORE_PASSWORD}'

Kerberos and SSL

kinit

beeline -u 'jdbc:hive2://${BEELINE_HOST}:${BEELINE_PORT}/;principal=hive/[email protected];ssl=true;sslTrustStore=${TRUSTSTORE}.jks;trustStorePassword=${TRUSTSTORE_PASSWORD}'