...
Code Block | ||
---|---|---|
| ||
# Then on the command-line $ javac HiveJdbcClient.java # To run the program using remote hiveserver in non-kerberos mode, we need the following jars in the classpath # from hive/build/dist/lib # hive-jdbc*.jar # hive-service*.jar # libfb303-0.9.0.jar # libthrift-0.9.0.jar # log4j-1.2.16.jar # slf4j-api-1.6.1.jar # slf4j-log4j12-1.6.1.jar # commons-logging-1.0.4.jar # # # Following additional jars are needed for the kerberos secure mode -To run the program using kerberos secure mode, we need the following jars in the classpath # hive-exec*.jar # commons-configuration-1.6.jar # and from hadoop # - hadoop-core*.jar # # To run the program in embedded mode, we need the following additional jars in the classpath # from hive/build/dist/lib # hive-exec*.jar # hive-metastore*.jar # antlr-runtime-3.0.1.jar # derby.jar # jdo2-api-2.1.jar # jpox-core-1.2.2.jar # jpox-rdbms-1.2.2.jar # # and from hadoop/build # hadoop-core*.jar # as well as hive/build/dist/conf, any HIVE_AUX_JARS_PATH set, # and hadoop jars necessary to run MR jobs (eg lzo codec) $ java -cp $CLASSPATH HiveJdbcClient # |
Alternatively,
...
you
...
can
...
run
...
the
...
following
...
bash
...
script,
...
which
...
will
...
seed
...
the
...
data
...
file
...
and
...
build
...
your
...
classpath
...
before
...
invoking
...
the
...
client.
...
The
...
script
...
adds
...
all
...
the
...
additional
...
jars
...
needed
...
for
...
using
...
HiveServer2
...
in
...
embedded
...
mode
...
as
...
well.
Code Block | ||
---|---|---|
| ||
#!/bin/bash HADOOP_HOME=/your/path/to/hadoop HIVE_HOME=/your/path/to/hive echo -e '1\x01foo' > /tmp/a.txt echo -e '2\x01bar' >> /tmp/a.txt HADOOP_CORE={{$(ls $HADOOP_HOME/hadoop-core*.jar}}) CLASSPATH=.:$HIVE_HOME/conf:`hadoop classpath`$(hadoop classpath) for i in ${HIVE_HOME}/lib/*.jar ; do CLASSPATH=$CLASSPATH:$i done java -cp $CLASSPATH HiveJdbcClient |
JDBC Data Types
The following table lists the data types implemented for HiveServer2 JDBC.
...