[jira] [Updated] (HIVE-23042) Merge queries to a single one for updating MIN_OPEN_TXNS table
[ https://issues.apache.org/jira/browse/HIVE-23042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-23042: -- Fix Version/s: 4.0.0 Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master. Thanks for the review [~dkuzmenko]! > Merge queries to a single one for updating MIN_OPEN_TXNS table > -- > > Key: HIVE-23042 > URL: https://issues.apache.org/jira/browse/HIVE-23042 > Project: Hive > Issue Type: Bug > Components: Transactions >Reporter: Peter Vary >Assignee: Peter Vary >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-23042.2.patch, HIVE-23042.3.patch, > HIVE-23042.4.patch, HIVE-23042.patch > > > When opening a new transaction we issue 2 queries to update the MIN_OPEN_TXN > table. > {code} > > values(763, 763)> > {code} > This could be archived with a single query faster, if we do not open > transactions in batch, like: > {code} >SELECT ?, MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'> > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23042) Merge queries to a single one for updating MIN_OPEN_TXNS table
[ https://issues.apache.org/jira/browse/HIVE-23042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-23042: -- Attachment: HIVE-23042.4.patch > Merge queries to a single one for updating MIN_OPEN_TXNS table > -- > > Key: HIVE-23042 > URL: https://issues.apache.org/jira/browse/HIVE-23042 > Project: Hive > Issue Type: Bug > Components: Transactions >Reporter: Peter Vary >Assignee: Peter Vary >Priority: Major > Attachments: HIVE-23042.2.patch, HIVE-23042.3.patch, > HIVE-23042.4.patch, HIVE-23042.patch > > > When opening a new transaction we issue 2 queries to update the MIN_OPEN_TXN > table. > {code} > > values(763, 763)> > {code} > This could be archived with a single query faster, if we do not open > transactions in batch, like: > {code} >SELECT ?, MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'> > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23042) Merge queries to a single one for updating MIN_OPEN_TXNS table
[ https://issues.apache.org/jira/browse/HIVE-23042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-23042: -- Attachment: HIVE-23042.3.patch > Merge queries to a single one for updating MIN_OPEN_TXNS table > -- > > Key: HIVE-23042 > URL: https://issues.apache.org/jira/browse/HIVE-23042 > Project: Hive > Issue Type: Bug > Components: Transactions >Reporter: Peter Vary >Assignee: Peter Vary >Priority: Major > Attachments: HIVE-23042.2.patch, HIVE-23042.3.patch, HIVE-23042.patch > > > When opening a new transaction we issue 2 queries to update the MIN_OPEN_TXN > table. > {code} > > values(763, 763)> > {code} > This could be archived with a single query faster, if we do not open > transactions in batch, like: > {code} >SELECT ?, MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'> > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23042) Merge queries to a single one for updating MIN_OPEN_TXNS table
[ https://issues.apache.org/jira/browse/HIVE-23042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-23042: -- Attachment: HIVE-23042.2.patch > Merge queries to a single one for updating MIN_OPEN_TXNS table > -- > > Key: HIVE-23042 > URL: https://issues.apache.org/jira/browse/HIVE-23042 > Project: Hive > Issue Type: Bug > Components: Transactions >Reporter: Peter Vary >Assignee: Peter Vary >Priority: Major > Attachments: HIVE-23042.2.patch, HIVE-23042.patch > > > When opening a new transaction we issue 2 queries to update the MIN_OPEN_TXN > table. > {code} > > values(763, 763)> > {code} > This could be archived with a single query faster, if we do not open > transactions in batch, like: > {code} >SELECT ?, MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'> > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23042) Merge queries to a single one for updating MIN_OPEN_TXNS table
[ https://issues.apache.org/jira/browse/HIVE-23042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-23042: -- Status: Patch Available (was: Open) > Merge queries to a single one for updating MIN_OPEN_TXNS table > -- > > Key: HIVE-23042 > URL: https://issues.apache.org/jira/browse/HIVE-23042 > Project: Hive > Issue Type: Bug > Components: Transactions >Reporter: Peter Vary >Assignee: Peter Vary >Priority: Major > Attachments: HIVE-23042.patch > > > When opening a new transaction we issue 2 queries to update the MIN_OPEN_TXN > table. > {code} > > values(763, 763)> > {code} > This could be archived with a single query faster, if we do not open > transactions in batch, like: > {code} >SELECT ?, MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'> > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23042) Merge queries to a single one for updating MIN_OPEN_TXNS table
[ https://issues.apache.org/jira/browse/HIVE-23042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-23042: -- Attachment: HIVE-23042.patch > Merge queries to a single one for updating MIN_OPEN_TXNS table > -- > > Key: HIVE-23042 > URL: https://issues.apache.org/jira/browse/HIVE-23042 > Project: Hive > Issue Type: Bug > Components: Transactions >Reporter: Peter Vary >Assignee: Peter Vary >Priority: Major > Attachments: HIVE-23042.patch > > > When opening a new transaction we issue 2 queries to update the MIN_OPEN_TXN > table. > {code} > > values(763, 763)> > {code} > This could be archived with a single query faster, if we do not open > transactions in batch, like: > {code} >SELECT ?, MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'> > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)