1,添加elasticsearch-hadoop-hive-2.1.2.jar到Hive。Hive添加第三方包,查看:http://blog.csdn.net/qianshangding0708/article/details/50381966
2,在hive中建立Elasticsearch外表:
@Test
public void testESTable() {
try {
HiveHelper
.excuteNonQuery("CREATE EXTERNAL TABLE es_user(id String ,name String ,age int ,create_date String) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' TBLPROPERTIES('es.resource' = 'es_hive/user_{create_date}','es.index.auto.create' = 'true','es.nodes' = '10.0.1.75:9200,10.0.1.76:9200,10.0.1.77:9200')");
} catch (Exception e) {
e.printStackTrace();
}
}
为了让SQL语句看的清晰点,再