hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laszlo Pinter (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20551) Create PreparedStatement query dynamically when IN clause is used
Date Fri, 14 Sep 2018 10:14:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-20551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Laszlo Pinter updated HIVE-20551:
---------------------------------
    Attachment: HIVE-20551.02.patch

> Create PreparedStatement query dynamically when IN clause is used
> -----------------------------------------------------------------
>
>                 Key: HIVE-20551
>                 URL: https://issues.apache.org/jira/browse/HIVE-20551
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Laszlo Pinter
>            Assignee: Laszlo Pinter
>            Priority: Major
>         Attachments: HIVE-20551.01.patch, HIVE-20551.02.patch
>
>
> In the MetaStoreDirectSql class when IN clause is used, the query statement is created
via string concatenation.
> Since JDBC API allows only one literal for one “?” parameter, PreparedStatement doesn’t
work for IN clause queries. To create the PreparedStatement query dynamically based on the
size of the elements in IN clause, the makeParams() should be used instead of concatenation. 



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

Mime
View raw message