Operate Hive by JDBC

New java project

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
     <modelVersion>4.0.0</modelVersion>
     <groupId>com.an.antry</groupId>
     <artifactId>antry-hive</artifactId>
     <version>0.0.1</version>
     <dependencies>
          <dependency>
               <groupId>org.apache.hadoop</groupId>
               <artifactId>hadoop-client</artifactId>
               <version>2.4.1</version>
          </dependency>
          <dependency>
               <groupId>org.apache.hbase</groupId>
               <artifactId>hbase-client</artifactId>
               <version>0.98.3-hadoop2</version>
          </dependency>
          <dependency>
               <groupId>org.apache.hive</groupId>
               <artifactId>hive-jdbc</artifactId>
               <version>0.14.0</version>
          </dependency>
     </dependencies>
</project>

HiveJdbc.java

public class HiveJdbc {
    private static final Logger LOGGER = LoggerFactory.getLogger(HiveJdbc.class);
    private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver";
    private static String url = "jdbc:hive://10.103.218.27:10000/default";


    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection conn = null;
        Statement stmt = null;
        try {
            conn = getConn();
            stmt = conn.createStatement();
            String sql = "select * from blocksLocation limit 5;";
            ResultSet res = stmt.executeQuery(sql);
            LOGGER.info("Execute select query result: ");
            while (res.next()) {
                LOGGER.info("{} \t {} \t {}", res.getInt(1), res.getString(2), res.getString(3));
            }
        } finally {
            if (conn != null) {
                LOGGER.info("Close conn {}", conn.toString());
                conn.close();
            } else {
                LOGGER.warn("Null conn.");
            }
            if (stmt != null) {
                LOGGER.info("Close stmt {}", stmt.toString());
                stmt.close();
            } else {
                LOGGER.warn("Null stmt.");
            }
        }
    }


    private static Connection getConn() throws SQLException, ClassNotFoundException {
        Class.forName(driverName);
        Connection conn = DriverManager.getConnection(url, "", "");
        LOGGER.info("Connection {}", conn.toString());
        LOGGER.info("getCatalog {}", conn.getCatalog());
        return conn;
    }
}

FAQ:

1. Exception in thread "main" java.sql.SQLException: Query returned non-zero code: 40000, cause: FAILED: ParseException line 1:36 extraneous input ';' expecting EOF near '<EOF>'
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:194)
at com.an.antry.hive.HiveJdbc.main(HiveJdbc.java:24)

A: Remove ; from sql

String sql = "select * from blocksLocation limit 5";