hadoop - elastic search table in hive -
i have hive table below
basicinfo: name string, address string, state string, dob date created es index : below create external table esbasic (name string, address string, state string, dob date) stored 'org.elasticsearch.hadoop.hive.esstoragehandler' tblproperties('es.resource' = 'test32/test32','es.nodes' = 'x.x.x.x:9200','es.input.json' = 'false'); insert overwrite table esbasic select * basicinfo select * esbasic
it returns proper results.
but in kibana , when visualize table, address field makes problem when has more 1 word. like, riverview avenue
in address field becomes 2 separate words. need mark address field not analyzed. how can while creating @ time of hive external table creation? or there other way modify this?
Comments
Post a Comment