My ES version is 1.3.2
I setup an AWS EMR cluster (emr-4.2.0) with Hive 1.0.0 to provide an SQL-like interface to our data in ES. Since, our Analytics team prefers SQL like queries rather than ES.
I'm using the latest ES-Hadoop connector (elasticsearch-hadoop-2.2.0)
The setup was pretty easy and I'm able to connect to my ES (which is on a remote server) from Hive console.
However, queries that typically take few seconds in ES are taking 2 hours from Hive!
select count(*) from my_table where member_id = 1234;
I'm looking for suggestions to make this faster. Am I doing anything incorrectly?