[jira] [Commented] (HIVE-20607) TxnHandler should use PreparedStatement to execute direct SQL queries.

["Daniel Dai (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-20607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16661476#comment-16661476 ] 

Daniel Dai commented on HIVE-20607:
-----------------------------------

[~sankarh], can you commit it to branch-3 as well?

> TxnHandler should use PreparedStatement to execute direct SQL queries.
> ----------------------------------------------------------------------
>
>                 Key: HIVE-20607
>                 URL: https://issues.apache.org/jira/browse/HIVE-20607
>             Project: Hive
>          Issue Type: Bug
>          Components: Standalone Metastore, Transactions
>    Affects Versions: 4.0.0
>            Reporter: Sankar Hariappan
>            Assignee: Sankar Hariappan
>            Priority: Major
>              Labels: ACID, pull-request-available
>             Fix For: 4.0.0
>
>         Attachments: HIVE-20607.01.patch
>
>
> TxnHandler uses direct SQL queries to operate on Txn related databases/tables in Hive metastore RDBMS.
> Most of the methods are direct calls from Metastore api which should be directly append input string arguments to the SQL string.
> Need to use parameterised PreparedStatement object to set these arguments.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)