Example of using jdbc to connect to impala

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.