hive command - Show tables or any command not working


Problem :

I am unable to run any queries from the hive> shell. For example, even something simple such as

hive> select * from date;

produces the same error after parsing is complete:

select * from date Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.hive.ql.parse.ASTNode.setUnknownTokenBoundaries()V at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:214) at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:389) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:303) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1067) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1129) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1004) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:994) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:247) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:199) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:410) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:783) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136)


Here are the logs:

15/09/02 08:55:12 [main]: INFO hive.metastore: Connected to metastore. 15/09/02 08:55:12 [main]: INFO session.SessionState: Created local directory: /home/ETRI/hive/tmpdir/ETRI/f128f3e2-998f-4463-aa1b-8649db186945_resources 15/09/02 08:55:12 [main]: INFO session.SessionState: Created HDFS directory: /tmp/hive/ETRI/f128f3e2-998f-4463-aa1b-8649db186945 15/09/02 08:55:12 [main]: INFO session.SessionState: Created local directory: /home/ETRI/hive/tmpdir/ETRI/f128f3e2-998f-4463-aa1b-8649db186945 15/09/02 08:55:13 [main]: INFO session.SessionState: Created HDFS directory: /tmp/hive/ETRI/f128f3e2-998f-4463-aa1b-8649db186945/_tmp_space.db 15/09/02 08:55:13 [main]: INFO session.SessionState: No Tez session required at this point. hive.execution.engine=mr. 15/09/02 08:55:13 [main]: INFO log.PerfLogger: 15/09/02 08:55:13 [main]: INFO log.PerfLogger: 15/09/02 08:55:13 [main]: INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager 15/09/02 08:55:13 [main]: INFO log.PerfLogger: 15/09/02 08:55:13 [main]: INFO log.PerfLogger: 15/09/02 08:55:13 [main]: INFO parse.ParseDriver: Parsing command: show tables 15/09/02 08:55:13 [main]: INFO parse.ParseDriver: Parse Completed 15/09/02 08:55:13 [main]: INFO log.PerfLogger:


I have managed the configurations as per the below link.

cloudera Mysql hive config


I am wondering how to handle this setUnknownTokenBoundaries()V method?

I didn't change any methods in ql.parse, as these are internal.

Many thanks.



Solution :

This is not the issue with Hive or mysql connector.

java.lang.NoSuchMethodError occurs when compiling against one version of a library but running against a different version. Try updating the Java version and set the environmental variables on Hadoop and try running Hive.


Mysql Tutorials

Mysql Howto..

how to pass table name into a function?

How does one craft an array from LEFT JOINs when joined tables have multiple matches and GROUP BY omits needed rows

how to get not duplicated results in mysql

How to use between operator for 2 date input parameters in mysql?

How to show duplicate records in MySQL and combine records with PHP?

MySQL: How to order by (-) dash

How much time does MySQL need to build an index

How to handle MySQL shutdown in Matlab?

MySQL - How to index this query?

How to fetch data from MySQL database into Excel

MySQL - How to concatenate columns that contain at least one alphabetic character

How can I dump a MySQL database from mysql c library

how to simplify this statement? php mysql

how to get result if 2nd field is empty in mysql [closed]

How to handle the different timezone in mysql?

Update: How to implement Foreign Key concept in MySQL when we do not have referential integrity features in MySQL?

How to store a list of data (like an array) in mysql cell? (but have it still be searchable)

how to create procedure in mysql for selecting record?

How to count the specific value from JSON

How to figure out if mysql index fits entirely in memory

Using node.js, how can I write to one MySQL DB and read from another?

how to set 'event_scheduler' in MS azure mysql

In MySQL, how do I get the value of each entry for each day?

how to OrderBy Ascending of mixed string/int column in MySQL?

how to connect mysql database to laravel in ubuntu

MySQL: How to convert seconds to mm:ss format?

How to get counts in Mysql Left Join?

Django - how to order a sequence of videos within a topic?

MYSQL how to covert table from relationship from onetoone to onetomany merging its columns in to rows

how to compare current time with datetime field in db continuously?