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

Assertion Error on while selecting from hive view

Hi,

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

SQL authorization is enabled in Hive

<property>
  <name>hive.security.authorization.enabled</name>
  <value>true</value>
</property>

 

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(Util.java:789)

 

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

 

Thanks in advance.