Hi team, Iam creating materialized view for a table ,for that getting below error.can any one help on this? create materialized view car1_mv as select * from cars; Error: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Automatic rewriting for materialized view cannot be enabled if the materialized view uses non-transactional tables (state=42000,code=40000) ... View more

hi ,i am currently using hdp 3.0 and ambari 2.7,i need to install the nifi service on my cluster ,just followed the hortonworks document they said following query ambari-server install-mpack --mpack=http://.../hdf-mpack-name.tar.gz --purge --verbose added my centos7 package in the mpack. what we need to setup after? ... View more