[ https://issues.apache.org/jira/browse/HIVE-22162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa updated HIVE-22162: ---------------------------------- Attachment: HIVE-22162.3.patch > MVs are not using ACID tables. > ------------------------------ > > Key: HIVE-22162 > URL: https://issues.apache.org/jira/browse/HIVE-22162 > Project: Hive > Issue Type: Bug > Components: Materialized views > Affects Versions: 3.1.2 > Reporter: Krisztian Kasa > Assignee: Krisztian Kasa > Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-22162.1.patch, HIVE-22162.2.patch, > HIVE-22162.3.patch > > > {code} > SET hive.support.concurrency=true; > SET hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; > SET metastore.strict.managed.tables=true; > SET hive.default.fileformat=textfile; > SET hive.default.fileformat.managed=orc; > SET metastore.create.as.acid=true; > CREATE TABLE cmv_basetable_n4 (a int, b varchar(256), c decimal(10,2)); > INSERT INTO cmv_basetable_n4 VALUES (1, 'alfred', 10.30),(2, 'bob', 3.14),(2, > 'bonnie', 172342.2),(3, 'calvin', 978.76),(3, 'charlie', 9.8); > CREATE MATERIALIZED VIEW cmv_mat_view_n4 disable rewrite > AS SELECT a, b, c FROM cmv_basetable_n4; > DESCRIBE FORMATTED cmv_mat_view_n4; > {code} > {code} > POSTHOOK: query: DESCRIBE FORMATTED cmv_mat_view_n4 > ... > Table Type: MATERIALIZED_VIEW > Table Parameters: > COLUMN_STATS_ACCURATE > {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\"}} > bucketing_version 2 > numFiles 1 > numRows 5 > rawDataSize 1025 > totalSize 509 > {code} > Missing table parameter > {code} > transaction = true > {code} > cc.: [~ashutoshc], [~gopalv], [~jcamachorodriguez] -- This message was sent by Atlassian Jira (v8.3.2#803003)