[ https://issues.apache.org/jira/browse/HIVE-12996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280533#comment-15280533 ]
Wei Zheng commented on HIVE-12996: ---------------------------------- Here's the test result. They're irrelevant. Test Name Duration Age org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_select_read_only_encrypted_tbl 1 min 18 sec 1 org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler 1 min 2 sec 1 org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler 1 min 2 sec 1 org.apache.hadoop.hive.metastore.hbase.TestHBaseSchemaTool.oneMondoTest 1.2 sec 2 org.apache.hadoop.hive.llap.daemon.impl.comparator.TestShortestJobFirstComparator.testWaitQueueComparatorWithinDagPriority 5.2 sec 2 org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver_external_table_ppd 31 sec 3 org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver_hbase_binary_storage_queries 1 min 54 sec 3 org.apache.hadoop.hive.llap.daemon.impl.TestTaskExecutorService.testPreemptionQueueComparator 5 sec 3 org.apache.hadoop.hive.llap.tez.TestConverters.testFragmentSpecToTaskSpec 38 ms 14 org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_insert_partition_dynamic 1 min 25 sec 14 org.apache.hive.service.cli.session.TestHiveSessionImpl.testLeakOperationHandle 34 sec 14 org.apache.hadoop.hive.llap.tezplugins.TestLlapTaskCommunicator.testFinishableStateUpdateFailure 5 sec 27 org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_insert_partition_static 1 min 31 sec 42 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_selectindate 12 sec 46 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_avrocountemptytbl 13 sec 46 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_order_null 35 sec 46 org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_join_with_different_encryption_keys 1 min 32 sec 46 org.apache.hive.minikdc.TestHiveAuthFactory.testStartTokenManagerForMemoryTokenStore 1.1 sec 46 org.apache.hive.minikdc.TestHiveAuthFactory.testStartTokenManagerForDBTokenStore 0.31 sec 46 org.apache.hive.minikdc.TestMiniHiveKdc.testLogin 1 min 41 sec 46 org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3 9.9 sec 46 org.apache.hadoop.hive.cli.TestMinimrCliDriver.org.apache.hadoop.hive.cli.TestMinimrCliDriver 58 sec 46 > Temp tables shouldn't be locked > ------------------------------- > > Key: HIVE-12996 > URL: https://issues.apache.org/jira/browse/HIVE-12996 > Project: Hive > Issue Type: Bug > Components: Transactions > Affects Versions: 2.0.0 > Reporter: Wei Zheng > Assignee: Wei Zheng > Attachments: HIVE-12996.1.patch, HIVE-12996.2.patch, > HIVE-12996.3.patch > > > Internally, INSERT INTO ... VALUES statements use temp table to accomplish > its functionality. But temp tables shouldn't be stored in the metastore > tables for ACID, because they are by definition only visible inside the > session that created them, and we don't allow multiple threads inside a > session. If a temp table is used in a query, it should be ignored by lock > manager. > {code} > mysql> select * from COMPLETED_TXN_COMPONENTS; > +-----------+--------------+-----------------------+------------------+ > | CTC_TXNID | CTC_DATABASE | CTC_TABLE | CTC_PARTITION | > +-----------+--------------+-----------------------+------------------+ > | 1 | acid | t1 | NULL | > | 1 | acid | values__tmp__table__1 | NULL | > | 2 | acid | t1 | NULL | > | 2 | acid | values__tmp__table__2 | NULL | > | 3 | acid | values__tmp__table__3 | NULL | > | 3 | acid | t1 | NULL | > | 4 | acid | values__tmp__table__1 | NULL | > | 4 | acid | t2p | ds=today | > | 5 | acid | values__tmp__table__1 | NULL | > | 5 | acid | t3p | ds=today/hour=12 | > +-----------+--------------+-----------------------+------------------+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)