# Added elasticsearch and hadoop and while creating external table getting error

**URL:** <https://discuss.elastic.co/t/added-elasticsearch-and-hadoop-and-while-creating-external-table-getting-error/195938>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [August 20, 2019, 1:14pm UTC](https://discuss.elastic.co/t/added-elasticsearch-and-hadoop-and-while-creating-external-table-getting-error/195938 "2019-08-20T13:14:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![varunakuraju](https://avatars.discourse-cdn.com/v4/letter/v/c57346/32.png) [@varunakuraju](https://discuss.elastic.co/u/varunakuraju)\
**Post date:** [August 20, 2019, 1:14pm UTC](https://discuss.elastic.co/t/added-elasticsearch-and-hadoop-and-while-creating-external-table-getting-error/195938/1 "2019-08-20T13:14:25Z")

</div>

created table vgsale in hive

after added es-hadoop connector successful and trying to create external table  
Added [file:///home/saivarunakuraju/elasticsearch-hadoop-hive-7.3.0.jar] to class path

Added resources: [file:///home/saivarunakuraju/elasticsearch-hadoop-hive-7.3.0.jar]

hive\> CREATE EXTERNAL TABLE vgsales\_es(  
\> rank int,  
\> Name string,  
\> Platform string,  
\> year int,  
\> Genre string,  
\> Publisher string,  
\> nasales int,  
\> eusales int,  
\> jpsales int,  
\> othersales int,  
\> Globalsales int  
\> )  
\> stored by 'org.elasticsearch.hadoop.hive.ESStorageHandler'  
\> TBLPROPERTIES ('es.resource' = “vgsale/vgsals”,  
\> 'es.nodes'='localhost');  
MismatchedTokenException(24!=352)

at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)

at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)

at org.apache.hadoop.hive.ql.parse.HiveParser.keyValueProperty(HiveParser.java:28199)

at org.apache.hadoop.hive.ql.parse.HiveParser.tablePropertiesList(HiveParser.java:27995)

at org.apache.hadoop.hive.ql.parse.HiveParser.tableProperties(HiveParser.java:27867)

at org.apache.hadoop.hive.ql.parse.HiveParser.tablePropertiesPrefixed(HiveParser.java:27804)

at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:6338)

at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:3808)

at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:2382)

at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1333)

at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:208)

at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:77)

at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:70)

at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:468)

at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1317)

at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1457)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1237)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1227)

at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:233)

at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:184)

at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)

at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821)

at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759)

at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:686)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.hadoop.util.RunJar.run(RunJar.java:244)

at org.apache.hadoop.util.RunJar.main(RunJar.java:158)

FAILED: ParseException line 15:16 cannot recognize input near 'es' '.' 'resource' in table properties list

hive\>

---

<div class="post-metadata">

**Author:** ![james.baiera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james.baiera/32/10209_2.png) [@james.baiera](https://discuss.elastic.co/u/james.baiera)\
**Post date:** [August 23, 2019, 4:34pm UTC](https://discuss.elastic.co/t/added-elasticsearch-and-hadoop-and-while-creating-external-table-getting-error/195938/2 "2019-08-23T16:34:33Z")

</div>

> [@varunakuraju](#):
>
> TBLPROPERTIES ('es.resource' = “vgsale/vgsals”,

This should instead be

```auto
TBLPROPERTIES ('es.resource' = 'vgsale/vgsals',

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 20, 2019, 4:34pm UTC](https://discuss.elastic.co/t/added-elasticsearch-and-hadoop-and-while-creating-external-table-getting-error/195938/3 "2019-09-20T16:34:34Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.