Hive表导入Elasticsearch

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语句看的清晰点，再贴一次SQL语句：

CREATE EXTERNAL TABLE es_user (
	id String,
	NAME String,
	age INT