Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Error: running a query on Hive 2 mode LLAP

avatar
Contributor

Hi, I running a query on Hive 2 mode LLAP. I have created a database but when I do select * from table, it return this error:

$ bd_cmd="\SELECT * FROM my_Database.my_Table\"" 
$ eval "${cli_cmd} -e ${db_cmd}" 
Connecting to jdbc:hive2://my_Host:port_Zookeeper; ..... 
Connected to: Apache Hive (version 2.1.0.2.6.3.0-235) 
Driver: Hive JDBC (version 1.2.1000.2.6.3.0-235)
Transaction isolation: TARNSACTION_REPEATABLE_READ 
Error: Error running query: java.lang.AssertionError: Internal error: While invoking method 'public org.apache.calcite.sql2rel.RelFieldTrimmer$TrimResult org.apache.hadoop.hive.ql.optimizer.calcite.rules.HiveRelFieldTrimmer.trimFields(org.apache.calcite.rel.core.Project, org.apache.calcite.util.ImmutableBitSet, java.util.Set)' (stage=,code=0) 
Closing: 0: jdbc:hive2://my_host:portZookeeper;..... 

Someone can give me a solution about this error and how can resolve it ?

@Shivaji Dutta @Paul Boal @emaxwell @smanjee

1 REPLY 1

avatar
Expert Contributor

@Sirine

It could be related to the below issue:

https://issues.apache.org/jira/browse/HIVE-16828

Though, I am not sure it is a view of table at your end.

As a workaround, can you try recreating the table and then try the query again.