I am a big believer in simple command line examples. Connecting the dots is so much easier when you do this.<\/p>\n
There will be much more on this, but this should get you started.<\/p>\n
CLASSPATH is shown below. The absolute locations will differ according to where you place your jar files.<\/p>\n
\r\n[root@util01 test]# env | grep CLASS | awk '{split($1,t,\":\");while (++i <= length(t)) {print t[i]}}'\r\nCLASSPATH=.\r\n\/usr\/share\/tomcat5\/common\/lib\/hive_contrib.jar\r\n\/usr\/share\/tomcat5\/common\/lib\/hive-jdbc-0.10.0-cdh4.2.0.jar\r\n\/usr\/share\/tomcat5\/common\/lib\/hive-metastore-0.10.0-cdh4.2.0.jar\r\n\/usr\/share\/tomcat5\/common\/lib\/hive-service-0.10.0-cdh4.2.0.jar\r\n\/usr\/share\/tomcat5\/common\/lib\/libthrift-0.9.0.jar\r\n\/usr\/share\/tomcat5\/common\/lib\/slf4j-api-1.6.4.jar\r\n\/usr\/share\/tomcat5\/common\/lib\/commons-logging-1.0.4.jar\r\n[root@util01 test]#\r\n<\/pre>\nJava code below...<\/p>\n
\r\nimport java.sql.*;\r\n\r\npublic class hive {\r\n public static void main (String args[]) {\r\n try {\r\n Class.forName(\"org.apache.hive.jdbc.HiveDriver\");\r\n Connection con = DriverManager.getConnection(\"jdbc:hive2:\/\/192.168.3.50:21050\/;auth=noSasl\");\r\n Statement stmt = con.createStatement();\r\n ResultSet res = stmt.executeQuery(\"select * from x\");\r\n while (res.next()) {\r\n System.out.println(res.getInt(1) + \"
\");\r\n }\r\n stmt.close();\r\n con.close();\r\n }\r\n catch (Exception e) {\r\n e.printStackTrace();\r\n System.out.println(e.getMessage());\r\n }\r\n }\r\n}\r\n<\/pre>\n...and output of the run...<\/p>\n
\r\n[root@util01 test]# java hive\r\nSLF4J: Failed to load class \"org.slf4j.impl.StaticLoggerBinder\".\r\nSLF4J: Defaulting to no-operation (NOP) logger implementation\r\nSLF4J: See http:\/\/www.slf4j.org\/codes.html#StaticLoggerBinder for further details.\r\n1
\r\n2
\r\n3
\r\n4
\r\n5
\r\n6
\r\n\r\n\r\n\r\n97
\r\n98
\r\n99
\r\n100
\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"I am a big believer in simple command line examples. Connecting the dots is so much easier when you do this. There will be much more on this, but this should get you started. CLASSPATH is shown below. The absolute…<\/p>\n