New Contributor
Posts: 1
Registered: ‎10-14-2017

Assertion Error on while selecting from hive view


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.