Back

Beeline

Commands:

!connect jdbc:hive2://<knoxserver>:port/;ssl=true;sslTrustStore=/home/hadoop/knox-gateways.jks;trustStorePassword=ch4ng3m3;transportMode=http;httpPath=gateway/default/hive
Example
!connect jdbc:hive2://knoxserver.systems.uk.bank:8443/;ssl=true;sslTrustStore=/home/hadoop/knox-gateways.jks;trustStorePassword=ch4ng3m3;transportMode=http;httpPath=gateway/default/hive
Connect to hive with non-default scratchdir
!connect jdbc:hive2://hiveserver.systems.uk.bank:10001/default;httpPath=cliservice;transportMode=http;principal=hive/_HOST@HDP01;hive.exec.scratchdir=/user/jpcloud/tmp