Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Assertion Error on while selecting from hive view

Assertion Error on while selecting from hive view

New Contributor


I am using Hive 2.1.0 and Postgres is my Hive metastore.

SQL authorization is enabled in Hive



Using hive CLI I create a table and view like:

Create table test_table(name string);

Create view test_view as select * from test_table;


Now when I try to do : select * from  test_view I get the below exception:

Exception in thread "main" 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)'
        at org.apache.calcite.util.Util.newInternal(


My user is an admin and can select from the underlying test_table. Please suggest what could the issue be.


Thanks in advance.

Don't have an account?
Coming from Hortonworks? Activate your account here