question Re: error while usin select statement using hive in ambari: in Support Questions

error while usin select statement using hive in ambari:

vittal_hebbar — Thu, 28 Jul 2016 20:34:51 GMT

I have added jars esri-geometry-api.jar and spatial-sdk.jar in tmp/udfs/ in file view and refer it in hive view using the script as: ADD JAR /tmp/udfs/esri-geometry-api.jar ADD JAR /tmp/udfs/spatial-sdk.jar

select * from building;

but i get error as

Error while compiling statement: FAILED: ParseException line 4:0 cannot recognize input near 'ADD' 'JAR' 'esri' [ERROR_STATUS]

Re: error while usin select statement using hive in ambari:

cstanca — Fri, 29 Jul 2016 00:24:11 GMT

@k v vittal hebbar

I assume that lines as you actually wrote are like the below (in two lines with semicolon at the end):

ADD JAR /tmp/udfs/esri-geometry-api.jar;

ADD JAR /tmp/udfs/spatial-sdk.jar;

If that is true, then check whether your ambari view user is mapped to an OS user that has privileges on /tmp/udfs/ located files. Example:

You also have a better option to add these libraries to HDFS as such you can access them from any node with a Hive client.

add jar hdfs://whateverhost:8020/tmp/esri/esri-geometry-api.jar;

Try the hdfs approach.

If this addresses your response please vote and accept it as the best answer.

Re: error while usin select statement using hive in ambari:

vittal_hebbar — Fri, 29 Jul 2016 16:31:37 GMT

should i add above jars in hive view for ambari or hive server node

Re: error while usin select statement using hive in ambari:

cstanca — Wed, 21 Dec 2016 04:27:55 GMT

@k v vittal hebbar

Either one is fine.