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 Mon, 24 Sep 2018 20:05:00 GMT

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

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



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

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

{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 14996 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[mm_dp] (batchId=155)
{noformat}

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

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
Tests exited with: TestsFailedException: 1 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12941036 - 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, HIVE-20551.07.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