[
https://issues.apache.org/jira/browse/HIVE-4996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13744162#comment-13744162
]
Logan Hardy commented on HIVE-4996:
-----------------------------------
Thanks for your reply Teddy. I have a hive script that drops then
re-creates a couple of tables. I assumed that it was the "drop table if
exists" steps but upon further investigation at least in the latest
instance it was the last step that failed. *--uber_responsemapping*
[root@ALLEG-P-H0001 exec_etl-wf]# cat drop_uber_tables.q
DROP TABLE if exists ${hivedbname}.uber_responsemapping;
DROP TABLE if exists ${hivedbname}.ubermap;
--ubermap
Create table ${hivedbname}.ubermap (
ubermapid int,
id int,
value string,
surveyid int,
uberindex int,
uberbit bigint,
modifieddate string)
Partitioned by (Maptype int )
Clustered by (id ) into 20 BUCKETS;
*--uber_responsemapping*
*Create Table ${hivedbname}.uber_responsemapping (*
*id int, *
*responseid int, *
*respondentid int, *
*answerid int, *
*scaleid int, *
*responserank int, *
*respondentstate int, *
*modifieddatetime string, *
*value string, *
*answerweight int,*
*answerdatatype string,*
*dataaction string)*
*Partitioned by (surveyid int)*
*Clustered by (respondentid) into 50 BUCKETS;*
> unbalanced calls to openTransaction/commitTransaction
> -----------------------------------------------------
>
> Key: HIVE-4996
> URL: https://issues.apache.org/jira/browse/HIVE-4996
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.10.0
> Environment: hiveserver1 Java HotSpot(TM) 64-Bit Server VM (build
> 20.6-b01, mixed mode)
> Reporter: wangfeng
> Priority: Critical
> Labels: hive, metastore
> Original Estimate: 504h
> Remaining Estimate: 504h
>
> when we used hiveserver1 based on hive-0.10.0, we found the Exception
> thrown.It was:
> FAILED: Error in metadata: MetaException(message:java.lang.RuntimeException:
> commitTransaction was called but openTransactionCalls = 0. This probably
> indicates that the
> re are unbalanced calls to openTransaction/commitTransaction)
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> help
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
