hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20551) Create PreparedStatement query dynamically when IN clause is used
Date Sat, 22 Sep 2018 21:44:00 GMT

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

Hive QA commented on HIVE-20551:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12940796/HIVE-20551.06.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:green}SUCCESS:{color} +1 due to 14993 tests passed

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13982/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13982/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13982/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12940796 - PreCommit-HIVE-Build

> 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
>          Components: Hive
>            Reporter: Laszlo Pinter
>            Assignee: Laszlo Pinter
>            Priority: Major
>         Attachments: HIVE-20551.01.patch, HIVE-20551.02.patch, HIVE-20551.03.patch, HIVE-20551.04.patch,
HIVE-20551.05.patch, HIVE-20551.06.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