[ 
https://issues.apache.org/jira/browse/HIVE-22162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Krisztian Kasa reassigned HIVE-22162:
-------------------------------------


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

Reply via email to