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