[
https://issues.apache.org/jira/browse/HIVE-13497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman updated HIVE-13497:
----------------------------------
Description:
{noformat}
CREATE TABLE TXN_COMPONENTS (
TC_TXNID bigint REFERENCES TXNS (TXN_ID),
TC_DATABASE varchar(128) NOT NULL,
TC_TABLE varchar(128),
TC_PARTITION varchar(767)
);
{noformat}
but
{noformat}
select hl_db, hl_table, hl_partition, hl_txnid, from HIVE_LOCKS where
hl_txnid=" + txnid + " and hl_lock_type=" + quoteChar(LOCK_SEMI_SHARED)
{noformat}
produces the same info...
cc [~alangates]
But see TxnHandler.addDynamicPartitions()...
was:
{noformat}
CREATE TABLE TXN_COMPONENTS (
TC_TXNID bigint REFERENCES TXNS (TXN_ID),
TC_DATABASE varchar(128) NOT NULL,
TC_TABLE varchar(128),
TC_PARTITION varchar(767)
);
{noformat}
but
{noformat}
select hl_db, hl_table, hl_partition, hl_txnid, from HIVE_LOCKS where
hl_txnid=" + txnid + " and hl_lock_type=" + quoteChar(LOCK_SEMI_SHARED)
{noformat}
produces the same info...
cc [~alangates]
> eliminate TXN_COMPONENTS
> ------------------------
>
> Key: HIVE-13497
> URL: https://issues.apache.org/jira/browse/HIVE-13497
> Project: Hive
> Issue Type: Bug
> Components: Transactions
> Affects Versions: 1.3.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
>
> {noformat}
> CREATE TABLE TXN_COMPONENTS (
> TC_TXNID bigint REFERENCES TXNS (TXN_ID),
> TC_DATABASE varchar(128) NOT NULL,
> TC_TABLE varchar(128),
> TC_PARTITION varchar(767)
> );
> {noformat}
> but
> {noformat}
> select hl_db, hl_table, hl_partition, hl_txnid, from HIVE_LOCKS where
> hl_txnid=" + txnid + " and hl_lock_type=" + quoteChar(LOCK_SEMI_SHARED)
> {noformat}
> produces the same info...
> cc [~alangates]
> But see TxnHandler.addDynamicPartitions()...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
