Hive query from elasticsearch

Elastic Stack Elasticsearch
1

Hi,guys,I want to use hive sql to query real-time ES data.As the doc
says,first I must create a external table while I transfer sql to
rest-query? And then I use sql to query data from the external table?
Can I directly use sql to query ES? I am confused with that process.
Thank you!

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/bb13bc3d-7c55-4fc4-9392-eb2c85079669%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

You cannot use Hive SQL without Hive. In other words, with es-hadoop, you cannot just use arbitrary SQL on top of Elastic.
What you can however interact with Elasticsearch from within a Hive environment, meaning you can execute Hive SQL on top
of Hive
which underneath communicates with Elastic.
This is explained in the docs in the Hive chapter [1]

[1] Elasticsearch Platform — Find real-time answers at scale | Elastic

On 2/10/15 7:59 AM, XIAoCHeN ZOu wrote:

Hi,guys,I want to use hive sql to query real-time ES data.As the doc says,first I must create a external table while I
transfer sql to rest-query? And then I use sql to query data from the external table?
Can I directly use sql to query ES? I am confused with that process.
Thank you!

--
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/bb13bc3d-7c55-4fc4-9392-eb2c85079669%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/bb13bc3d-7c55-4fc4-9392-eb2c85079669%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit 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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/54D9D6D8.90007%40gmail.com.
For more options, visit https://groups.google.com/d/optout.