[jira] [Created] (HIVE-22162) MVs are not using ACID tables.

["Krisztian Kasa (Jira)" <ji...@apache.org>]

Krisztian Kasa created HIVE-22162:
-------------------------------------

             Summary: 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
             Fix For: 4.0.0


{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}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)