Support Questions
Find answers, ask questions, and share your expertise

i get error in hive using ambari 2.3 while using the select statement as shown here : Error while compiling statement: FAILED: ParseException line 4:14 character '�' not supported here [ERROR_STATUS]

 
14 REPLIES 14

Guru

Srinivas, hive-server2 doesn't seems to be on slave0.

Could you check it has been loaded by hiveserver2 :

grep esri-geometry-api.jar /var/log/hive/hiveserver2.log

there should be a match in the loading classpath

For that, you shouldn't even have to set the hive.aux.jars.path as it's in the hiveserver2 classpath

Can you also post the result of

ls -l /usr/hdp/current/hive-server2/

ls -l /usr/hdp/current/hive-server2/auxlib

please find results as below:

[ambari-qa@slave0 /]$ ls -l /usr/hdp/current/hive-server2/

total 96056

drwxr-xr-x. 2 root root 63 Jul 28 10:37 auxlib

drwxr-xr-x. 3 root root 4096 Jun 2 11:07 bin lrwxrwxrwx. 1 root root 21 Jun 2 11:08 conf -> /etc/hive/2.3.4.7-4/0 drwxr-xr-x. 3 root root 89 Jun 2 11:06 doc drwxr-xr-x. 3 root root 17 Jun 2 11:07 etc -rw-r--r--. 1 root root 98344826 Feb 11 08:35 hive.tar.gz drwxr-xr-x. 5 root root 8192 Jun 2 11:07 lib drwxr-xr-x. 3 root root 26 Jun 2 11:07 log drwxr-xr-x. 2 root root 47 Jun 2 11:07 man drwxrwxrwt. 2 hive hive 6 Feb 11 08:35 metastore drwxr-xr-x. 3 root root 22 Jun 2 11:07 scripts

[ambari-qa@slave0 /]$ ls -l /usr/hdp/current/hive-server2/auxlib

total 996

-rw-r--r--. 1 root root 870215 Jul 28 10:37 esri-geometry-api.jar

-rw-r--r--. 1 root root 145505 Jul 28 10:37 spatial-sdk-hadoop.jar

Explorer

To add to what my colleague just posted hive-server is not in slave 0 but in slave 1. Terribly sorry for my negligence.

So I believe the grep dint work because it is not configured in slave 0?

[ambari-qa@slave0 ~]$ grep esri-geometry-api.jar /var/log/hive/hiveserver2.log 
grep: /var/log/hive/hiveserver2.log: No such file or directory

I couldnt locate /hive-server2.log in /usr/var/log/hive.

6174-capture.png

please find the results below:

[ambari-qa@slave0 /]$ ls -l /usr/hdp/current/hive-server2/ total 96056 drwxr-xr-x. 2 root root 63 Jul 28 10:37 auxlib drwxr-xr-x. 3 root root 4096 Jun 2 11:07 bin lrwxrwxrwx. 1 root root 21 Jun 2 11:08 conf -> /etc/hive/2.3.4.7-4/0 drwxr-xr-x. 3 root root 89 Jun 2 11:06 doc drwxr-xr-x. 3 root root 17 Jun 2 11:07 etc -rw-r--r--. 1 root root 98344826 Feb 11 08:35 hive.tar.gz drwxr-xr-x. 5 root root 8192 Jun 2 11:07 lib drwxr-xr-x. 3 root root 26 Jun 2 11:07 log drwxr-xr-x. 2 root root 47 Jun 2 11:07 man drwxrwxrwt. 2 hive hive 6 Feb 11 08:35 metastore drwxr-xr-x. 3 root root 22 Jun 2 11:07 scripts

[ambari-qa@slave0 /]$ ls -l /usr/hdp/current/hive-server2/auxlib total 996 -rw-r--r--. 1 root root 870215 Jul 28 10:37 esri-geometry-api.jar -rw-r--r--. 1 root root 145505 Jul 28 10:37 spatial-sdk-hadoop.jar

Guru

no problem, can you do the grep (and the ls as well) on slave1?