[HIVE-22162] MVs are not using ACID tables by default

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Materialized views
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 30/Aug/19 07:03
• Updated: 27/Feb/24 22:23
• Resolved: 03/Sep/19 17:29

Description

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;

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       

Missing table parameter

transaction = true

cc.: ashutoshc, gopalv, jcamachorodriguez