Fwd: Question on partitioning materialized views

2018-09-07 Thread Karthik Palaniappan
Hi All, Created a materialized view with partitions and tblproperties('transactional'='true') in Hive Version 4.0 running on Hadoop 3.1. View gets created properly and I can see one file in each partition. When we tried to query the view though no rows are getting returned. In describe formatted,

Re: Question on partitioning materialized views

2018-09-07 Thread Jesus Camacho Rodriguez
: "dev@hive.apache.org" Date: Friday, September 7, 2018 at 8:11 AM To: "dev@hive.apache.org" Subject: Question on partitioning materialized views Hi All, Created a materialized view with partitions and tblproperties('transactional'='true') in Hive Versi

Question on partitioning materialized views

2018-09-07 Thread Karthik Palaniappan
Hi All, Created a materialized view with partitions and tblproperties('transactional'='true') in Hive Version 4.0 running on Hadoop 3.1. View gets created properly and I can see one file in each partition. When we tried to query the view though no rows are getting returned. In describe formatted,