# Elastic search Hive integration issues
**URL:** https://discuss.elastic.co/t/elastic-search-hive-integration-issues/21897
**Category:** Elasticsearch
**Created:** [January 29, 2015, 10:59am UTC](https://discuss.elastic.co/t/elastic-search-hive-integration-issues/21897 "2015-01-29T10:59:44Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Ada](https://discuss.elastic.co/u/Ada)
#### Post date: [January 29, 2015, 10:59am UTC](https://discuss.elastic.co/t/elastic-search-hive-integration-issues/21897/1 "2015-01-29T10:59:44Z")
Hi Elasticsearch folks,
while creating external table in hive with multiple column, it is not
getting indexed and is not available for kibana. i tried using
elasticsearch-hadoop-2.0.2 with kibana-4.0.0-beta3 on cloudera cdh5. please
suggested any solution for the same.
My hive query is
CREATE EXTERNAL TABLE TEST\_ES (
emp\_name STRING,
emp\_code INT,
emp\_location STRING )
ROW FORMAT SERDE 'org.elasticsearch.hadoop.hive.EsSerDe'
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES (
'es.nodes'='localhost',
'es.resource'='es\_hd\_test'
);
Thanks,
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/5b6079e9-2e35-4964-a922-1e48e3c35f85%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/5b6079e9-2e35-4964-a922-1e48e3c35f85%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 12:35am UTC](https://discuss.elastic.co/t/elastic-search-hive-integration-issues/21897/2 "2017-07-06T00:35:59Z")