# Correction in the variable name for ES Hive Documentation in es.json parameter **URL:** \ **Category:** Elasticsearch\ **Created:** [March 13, 2014, 10:15pm UTC](https://discuss.elastic.co/t/correction-in-the-variable-name-for-es-hive-documentation-in-es-json-parameter/16367 "2014-03-13T22:15:28Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![deepakas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/deepakas/32/697_2.png) [@deepakas](https://discuss.elastic.co/u/deepakas)\ **Post date:** [March 13, 2014, 10:15pm UTC](https://discuss.elastic.co/t/correction-in-the-variable-name-for-es-hive-documentation-in-es-json-parameter/16367/1 "2014-03-13T22:15:28Z")
Hi, I was struggling to load json document to ES from Hive. Later realised that there was a mistake in documentation. CREATE EXTERNAL TABLE json (data STRING [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1)) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' TBLPROPERTIES('es.resource' = '...', 'es.json.input` = 'yes' [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2)); Correct parameter name is es.input.json instead of es.json.input and value is 'true' instead of 'yes' CREATE EXTERNAL TABLE json (data STRING [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1)) STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' TBLPROPERTIES('es.resource' = '...', 'es.input.json' = 'true' [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2)); -- 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/26aada4e-4a71-4cbe-8ab7-d6d8efeb8b19%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/26aada4e-4a71-4cbe-8ab7-d6d8efeb8b19%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![costin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/costin/32/44950_2.png) [@costin](https://discuss.elastic.co/u/costin)\ **Post date:** [March 14, 2014, 3:55pm UTC](https://discuss.elastic.co/t/correction-in-the-variable-name-for-es-hive-documentation-in-es-json-parameter/16367/2 "2014-03-14T15:55:27Z")
Thanks for reporting and sorry for the mistake. I've fixed this in master and corrected the existing docs. Cheers! On 3/14/2014 12:15 AM, Deepak Subhramanian wrote: > Hi, > I was struggling to load json document to ES from Hive. Later realised that there was a mistake in documentation. > > CREATE EXTERNAL TABLE json(data STRING [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1)) > STORED BY'org.elasticsearch.hadoop.hive.EsStorageHandler' > TBLPROPERTIES('es.resource' = '...', > 'es.json.input` ='yes' [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2)); > > Correct parameter name is es.input.json instead of es.json.input and value is 'true' instead of 'yes' > > CREATE EXTERNAL TABLE json(data STRING [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-1)) > STORED BY'org.elasticsearch.hadoop.hive.EsStorageHandler' > TBLPROPERTIES('es.resource' = '...', > 'es.input.json' ='true' [http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2](http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/current/hive.html#CO17-2)); > > -- > 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) [mailto:elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/26aada4e-4a71-4cbe-8ab7-d6d8efeb8b19%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/26aada4e-4a71-4cbe-8ab7-d6d8efeb8b19%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/26aada4e-4a71-4cbe-8ab7-d6d8efeb8b19%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/26aada4e-4a71-4cbe-8ab7-d6d8efeb8b19%40googlegroups.com?utm_medium=email&utm_source=footer). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- Costin -- 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/5323266F.2030905%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/5323266F.2030905%40gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![deepakas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/deepakas/32/697_2.png) [@deepakas](https://discuss.elastic.co/u/deepakas)\ **Post date:** [April 8, 2014, 11:00am UTC](https://discuss.elastic.co/t/correction-in-the-variable-name-for-es-hive-documentation-in-es-json-parameter/16367/3 "2014-04-08T11:00:58Z")
Thanks Costin 🙂 On Fri, Mar 14, 2014 at 3:55 PM, Costin Leau [costin.leau@gmail.com](mailto:costin.leau@gmail.com) wrote: > Thanks for reporting and sorry for the mistake. I've fixed this in master > and corrected the existing docs. > > Cheers! > > On 3/14/2014 12:15 AM, Deepak Subhramanian wrote: > > > Hi, > > I was struggling to load json document to ES from Hive. Later realised > > that there was a mistake in documentation. > > > > CREATE EXTERNAL TABLE json(data STRING \<[http://www.elasticsearch.org/](http://www.elasticsearch.org/) > > guide/en/elasticsearch/hadoop/current/hive.html#CO17-1\>) > > > > STORED BY'org.elasticsearch.hadoop.hive.EsStorageHandler' > > TBLPROPERTIES('es.resource' = '...', > > 'es.json.input` ='yes' \<[http://www.elasticsearch.org/](http://www.elasticsearch.org/) > > guide/en/elasticsearch/hadoop/current/hive.html#CO17-2\>); > > > > Correct parameter name is es.input.json instead of es.json.input and > > value is 'true' instead of 'yes' > > > > CREATE EXTERNAL TABLE json(data STRING \<[http://www.elasticsearch.org/](http://www.elasticsearch.org/) > > guide/en/elasticsearch/hadoop/current/hive.html#CO17-1\>) > > > > STORED BY'org.elasticsearch.hadoop.hive.EsStorageHandler' > > TBLPROPERTIES('es.resource' = '...', > > 'es.input.json' ='true' \<[http://www.elasticsearch.org/](http://www.elasticsearch.org/) > > guide/en/elasticsearch/hadoop/current/hive.html#CO17-2\>); > > > > -- > > 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) \ > [unsubscribe@googlegroups.com](mailto:unsubscribe@googlegroups.com)\>. > > > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/26aada4e-](https://groups.google.com/d/msgid/elasticsearch/26aada4e-) > > 4a71-4cbe-8ab7-d6d8efeb8b19%[40googlegroups.com](http://40googlegroups.com) > > \<[https://groups.google.com/d/msgid/elasticsearch/26aada4e-](https://groups.google.com/d/msgid/elasticsearch/26aada4e-) > > 4a71-4cbe-8ab7-d6d8efeb8b19%[40GGGROUPS CASINO – Real Slot Casino for 10,000+ Senior Players](http://40googlegroups.com?utm_medium=) > > email&utm\_source=footer\>. > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > Costin > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit [https://groups.google.com/d/](https://groups.google.com/d/) > topic/elasticsearch/-59NmirS6sY/unsubscribe. > To unsubscribe from this group and all its topics, 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/](https://groups.google.com/d/) > msgid/elasticsearch/5323266F.2030905%[40gmail.com](http://40gmail.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- Deepak Subhramanian -- 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/CA%2BUubihj-oaNToDHagA6gVi98yrivcinX8ygfhyKmxq9GG3L7w%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CA%2BUubihj-oaNToDHagA6gVi98yrivcinX8ygfhyKmxq9GG3L7w%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:37am UTC](https://discuss.elastic.co/t/correction-in-the-variable-name-for-es-hive-documentation-in-es-json-parameter/16367/4 "2017-07-06T01:37:35Z")