impala jdbc -example

最新推荐文章于 2022-03-10 11:33:20 发布

天然呆的技术博客

最新推荐文章于 2022-03-10 11:33:20 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： sql on hadoop

本文链接：https://blog.youkuaiyun.com/u013494310/article/details/38693171

sql on hadoop 专栏收录该内容

10 篇文章

订阅专栏

本文详细介绍了如何使用 Cloudera Impala JDBC 进行查询操作，包括设置连接 URL、执行 SQL 查询及打印结果。通过示例代码演示了如何与 Impala 数据库进行交互。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.cloudera.example;

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 sample tables 
	private static final String SQL_STATEMENT = "SELECT description FROM sample_07 limit 10";
	
	// set the impalad host
	private static final String IMPALAD_HOST = "IMPALAD_HOST"; 
	
	// 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 console
			while (rs.next()) {
				// the example query returns one String column
				System.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
			}
		}
	}
}