Hey Harshita!
I was not able to reproduce your issue with the below versions.
from the error I would guess you may have incompatible guava versions loaded...
I think you may also try Hadoop 3.1.2 for Hive 3.1.2
cheers,
Zoltan
On 7/6/20 7:53 PM, harshita vishwakarma wrote:
Hi All,
Facing below error while executing 'select' query in hive:
/Exception in thread "main" java.lang.IncompatibleClassChangeError: Class com.google.common.collect.ImmutableSortedMap does not implement the requested interface
java.util.NavigableMap/
/
/
/Hadoop Version->2.9.2/
/Hive Version->3.1.2/
/
/
/I have created a table:/
CREATE TABLE ClientData (id INT, name STRING, dept STRING, yoj INT);
and then Loaded data into it from local file system
LOAD DATA LOCAL INPATH 'F:/TestingData/ClientDataHive.txt' INTO table
ClientData;
Now when I perform select * from ClientData, it throws the below error.
image.png
/
/
/Can you please help out here./
/
/
/Thanks,/
/Harshita./