Hello there, I'm trying to experiment with materialized view because I think it might improve our daily etl. I can successfully create a materialized view but I needed to add partitions with the resulting view. For some reason it throws a NullPointerException when including a partition in materialized view.
An error occurred when executing the SQL command: CREATE MATERIALIZED VIEW partition_mv_1 PARTITIONED ON (deptno) AS SELECT name, deptno FROM emps WHERE deptno > 100 AND deptno < 200 Error while compiling statement: FAILED: NullPointerException null [SQL State=42000, DB Errorcode=40000] 1 statement failed. Execution time: 0.16s I'm using the following Apache Hive (version 3.1.0.3.1.0.0-78) and Hive JDBC (version 3.1.0.3.1.0.0-78). My tables are transactional and my hive settings follow the suggested configuration. Client Side hive.support.concurrency – true hive.enforce.bucketing – true (Not required as of Hive 2.0) hive.exec.dynamic.partition.mode – nonstrict hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager Server Side (Metastore) hive.compactor.initiator.on – true (See table below for more details) hive.compactor.worker.threads – a positive number on at least one instance of the Thrift metastore service I suspect I might be having hive settings issue with this but I already followed the suggested config. I'm kind of stuck here and couldn't find the answer elsewhere. Hope I receive feedback from you. Thank you!
