hive集成elasticsearch,
- 查看hive-env.sh中HIVE_AUX_JARS_PATH的路径配置,将elasticsearch-hadoop-2.4.0.jar拷贝到响应的路径下
- 重启hive
- 通过jdbc获取hive连接,然后按照elasticsearch-hadoop-api中介绍写sql,或者参照elasticsearch和hive集成
CREATE EXTERNAL TABLE hive_test (id string, createtime string, name string)
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.resource' = 'hive_test/hive_test',
'es.index.auto.create' = 'true',
'es.nodes' = '192.168.248.170,192.168.248.171,192.168.248.172');
INSERT OVERWRITE TABLE hive_test
SELECT h.id, h.createtime, h.name FROM hive_test_20160608015938;