Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22162

MVs are not using ACID tables by default

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.2
    • Fix Version/s: 4.0.0
    • Component/s: Materialized views
    • Labels:
      None

      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.: Ashutosh Chauhan, Gopal Vijayaraghavan, Jesus Camacho Rodriguez

        Attachments

        1. HIVE-22162.1.patch
          7 kB
          Krisztian Kasa
        2. HIVE-22162.2.patch
          8 kB
          Krisztian Kasa
        3. HIVE-22162.3.patch
          7 kB
          Krisztian Kasa
        4. HIVE-22162.4.patch
          7 kB
          Krisztian Kasa

          Activity

            People

            • Assignee:
              kkasa Krisztian Kasa
              Reporter:
              kkasa Krisztian Kasa
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: