Hi Atul,
What does your Hive script looks like? What version of hive and es-hadoop are
you using? Can you post them
along with the stacktrace on Gist or Pastebin [1]?
The exception message is pretty straight-forward - either 'es.resource' is
missing or the resource
type is incorrectly specified [2].
Cheers,
[1]
http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/2.1.Beta/troubleshooting.html
[2]
http://www.elasticsearch.org/guide/en/elasticsearch/hadoop/2.1.Beta/hive.html#hive-configuration
On 11/27/14 8:57 PM, Atul Paldhikar wrote:
HI David,
did you find any fix for this issue, I am also facing the same problem.
Thanks
- Atul
On Tuesday, July 8, 2014 8:37:09 AM UTC-7, David Zabner wrote:
Hi all,
I am trying to write data to elastic search from hive and whenever I try I
get this error:
org.elasticsearch.hadoop.EsHadoopIllegalArgumentException: No resource
['es.resource'] (index/query/location) specified
The script I am running looks like this:
USE pl_10;
ADD jar /home/hdfs/sql-tests/schema/elasticsearch-hadoop-2.0.0.jar;
CREATE EXTERNAL TABLE IF NOT EXISTS REGIONES (
R_REGIONKEY INT,
R_NAME STRING,
R_COMMENT STRING
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
STORED by'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.resource'='radio/artists',
'es.nodes'='elastic-1');
INSERT OVERWRITE TABLE REGIONES select R_REGIONKEY, R_NAME, R_COMMENT from
REGION;
Any help would be much appreciated
--
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
[email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/54cced44-4f87-4569-923f-30e406ddb79c%40googlegroups.com
<https://groups.google.com/d/msgid/elasticsearch/54cced44-4f87-4569-923f-30e406ddb79c%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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/5477ACC3.9050407%40gmail.com.
For more options, visit https://groups.google.com/d/optout.
