I'm running Elasticsearch 1.7.2 and Hortonworks HDP 2.3. I have an external table in Hive that points to an index in Elasticsearch. Within Hive, I can run counts and queries without any problems.
However, I'm not able to use MS Access to create a linked table via ODBC to the Hive/Elasticsearch table. This works perfectly fine for other Hive tables (HDFS external, ORC, etc). It only seems to be an issue with Elasticsearch based external tables. Is this a known issue? Is this there a work around?
We have analysts that use MS Access to run queries against multiple databases and we would love for them to use Elasticsearch as a source. There doesn't appear to be a means of connecting to ES via ODBC, so I'm trying to use Hive as a middle man. But, using MS Access directly against the existing data in a Hive ORC table is /slow/!
I'm open to ideas.