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

Reply via email to