Page History

...

From this above page click the Gateway client binary archive link or just use the one here.

Unzip this file into your preferred location which will result in a knoxshell-0.14.0 directory and we will refer to that location as the {GATEWAY_HOME}.

...

• if you have access to the server you may use the command 

  • knoxcli.sh export-cert –type--type JKS

• copy the resulting gateway-client-identity.jks to your user home directory
• you may also ask your Knox administrator to provide you with the public cert for the gateway and create your own truststore within your user home directory

...

Enter the knoxline sql client at the command line:

I will use the defaults for the arguments in the script:

Default connection args: localhost, 8443, /Users/larry/gateway-client-trust.jks, changeit, gateway/sandbox/hive

Depending on your deployment, you may want to set the above arguments on the CLI below:

knoxshell-0.14.0 larry$ bin/knoxline.sh

...

Load the data from the samples.log file in /tmp (copy the sample.log file from ./samples/hive/sample.log to the /tmp directory on your hiveserver2 host):

knoxline> LOAD DATA LOCAL INPATH '/tmp/sample.log' OVERWRITE INTO TABLE logs

...