hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1333) javax.jdo.option.NonTransactionalRead ignored?
Date Fri, 30 Apr 2010 18:48:54 GMT
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	hivadm@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	hivadm@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.


Mime
View raw message