Java HiveOperations.query Examples

Example #1

File: BasicHiveTest.java Project: huanqing/spring-hadoop

 @Test
 public void testQueryForInt() throws Exception {
   String tableName = "testHiveDriverTable";
   hiveTemplate.query("create table if not exists " + tableName + " (key int, value string)");
   System.out.println(hiveTemplate.query("show tables"));
   assertEquals(
       Integer.valueOf(0), hiveTemplate.queryForInt("select count(1) as cnt from " + tableName));
 }