[jira] Created: (HIVE-1333) javax.jdo.option.NonTransactionalRead ignored?

[Edward Capriolo (JIRA)]

javax.jdo.option.NonTransactionalRead ignored?
----------------------------------------------

                 Key: HIVE-1333
                 URL: https://issues.apache.org/jira/browse/HIVE-1333
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Metastore, Query Processor
            Reporter: Edward Capriolo


{noformat}

<property>
  <name>javax.jdo.option.NonTransactionalRead</name>
  <value>true</value>
  <description>reads outside of transactions</description>
</property>

{noformat}
hive> show tables

{noformat}
100430 14:41:39  1874 Connect   hiv...@localhost on 
                 1874 Init DB   m6_XXXX
                 1874 Query     SHOW SESSION VARIABLES
                 1874 Query     SHOW COLLATION
                 1874 Query     SET character_set_results = NULL
                 1874 Query     SET autocommit=1
                 1874 Query     SET sql_mode='STRICT_TRANS_TABLES'
                 1874 Query     SET autocommit=0
                 1874 Query     SELECT @@session.tx_isolation
                 1874 Query     SET SESSION TRANSACTION ISOLATION LEVEL READ 
COMMITTED
                 1874 Query     SELECT `THIS`.`TBL_NAME` FROM `TBLS` `THIS` 
LEFT OUTER JOIN `DBS` `THIS_DATABASE_NAME` ON `THIS`.`DB_ID` = 
`THIS_DATABASE_NAME`.`DB_ID` WHERE `THIS_DATABASE_NAME`.`NAME` = 'default' AND 
(LOWER(`THIS`.`TBL_NAME`) LIKE '_%' ESCAPE '\\' )
                 1874 Query     commit
                 1874 Query     rollback
                 1874 Quit      
{noformat}

now set to false


{noformat}
100430 14:46:59  1889 Connect   hiv...@localhost on 
                 1889 Init DB   m6_rshive
                 1889 Query     SHOW SESSION VARIABLES
                 1889 Query     SHOW COLLATION
                 1889 Query     SET character_set_results = NULL
                 1889 Query     SET autocommit=1
                 1889 Query     SET sql_mode='STRICT_TRANS_TABLES'
                 1889 Query     SET autocommit=0
                 1889 Query     SELECT @@session.tx_isolation
                 1889 Query     SET SESSION TRANSACTION ISOLATION LEVEL READ 
COMMITTED
                 1889 Query     SELECT `THIS`.`TBL_NAME` FROM `TBLS` `THIS` 
LEFT OUTER JOIN `DBS` `THIS_DATABASE_NAME` ON `THIS`.`DB_ID` = 
`THIS_DATABASE_NAME`.`DB_ID` WHERE `THIS_DATABASE_NAME`.`NAME` = 'default' AND 
(LOWER(`THIS`.`TBL_NAME`) LIKE '_%' ESCAPE '\\' )
                 1889 Query     commit
                 1889 Query     rollback
                 1889 Quit      

{noformat}

Unless I misuderstand the property it looks like the reads are still inside a 
transaction. Also why does this transaction call commit as well as rollback?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.