CREATE EXTERNAL table IF NOT EXISTS dmp.t_dmp_idfa_bundle_country_array_tbl_es(ifa STRING,bundles array<STRING>,countrys array<STRING>)STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'TBLPROPERTIES('es.resource' = 't_dmp_idfa_bundle_country_array_tbl_es/_doc','es.nodes' = 'locolhost','es.nodes.wan.only' = 'true');
4.在hive命令行中执行
insert into dmp.t_dmp_idfa_bundle_country_array_tbl_es
(ifa,bundles,countrys) select ifa,bundles,countrys from dmp.t_dmp_idfa_bundle_country_array_tbl
limit 10;