Example of using jdbc to connect to impala

Source :? Github. comonefoursixCloudera-Impala-JDBC-Example see this article for lib dependencies required. Www.cloudera.comcontentcloudera-contentcloudera-docsImpalalatestInstalling-and-Using-Impalaciiu_impala_jdbc.html importjava. SQL. Conn

Source :? See this article for the lib that the https://github.com/onefoursix/Cloudera-Impala-JDBC-Example needs to depend on. Http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Impala/ciiu_impala_jdbc.html import java. SQL. Conn

Source :? Https://github.com/onefoursix/Cloudera-Impala-JDBC-Example

See this article for lib dependencies.

Http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Impala/ciiu_impala_jdbc.html

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;?public class ClouderaImpalaJdbcExample {?// here is an example query based on one of the Hue Beeswax sample tables private static final String SQL_STATEMENT = "SELECT a FROM test limit 10";?// set the impalad hostprivate static final String IMPALAD_HOST = "192.168.1.106";?// port 21050 is the default impalad JDBC port private static final String IMPALAD_JDBC_PORT = "21050";?private static final String CONNECTION_URL = "jdbc:hive2://" + IMPALAD_HOST + ':' + IMPALAD_JDBC_PORT + "/;auth=noSasl";?private static final String JDBC_DRIVER_NAME = "org.apache.hive.jdbc.HiveDriver";?public static void main(String[] args) {?System.out.println("\n=============================================");System.out.println("Cloudera Impala JDBC Example");System.out.println("Using Connection URL: " + CONNECTION_URL);System.out.println("Running Query: " + SQL_STATEMENT);?Connection con = null;?try {?Class.forName(JDBC_DRIVER_NAME);?con = DriverManager.getConnection(CONNECTION_URL);?Statement stmt = con.createStatement();?ResultSet rs = stmt.executeQuery(SQL_STATEMENT);?System.out.println("\n== Begin Query Results ======================");?// print the results to the consolewhile (rs.next()) {// the example query returns one String columnSystem.out.println(rs.getString(1));}?System.out.println("== End Query Results =======================\n\n");?} catch (SQLException e) {e.printStackTrace();} catch (Exception e) {e.printStackTrace();} finally {try {con.close();} catch (Exception e) {// swallow}}}}

Original article address: Use jdbc to connect to impala. Thank you for sharing it.