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

[Krisztian Kasa (Jira)]

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)