[
https://issues.apache.org/jira/browse/HIVE-23951?focusedWorklogId=467384&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-467384
]
ASF GitHub Bot logged work on HIVE-23951:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 06/Aug/20 16:26
Start Date: 06/Aug/20 16:26
Worklog Time Spent: 10m
Work Description: vineetgarg02 commented on a change in pull request
#1315:
URL: https://github.com/apache/hive/pull/1315#discussion_r466534477
##########
File path: ql/src/test/queries/clientpositive/prepare_plan.q
##########
@@ -0,0 +1,113 @@
+--! qt:dataset:src
+--! qt:dataset:alltypesorc
+
+set hive.explain.user=false;
+set hive.vectorized.execution.enabled=false;
+
+explain extended prepare pcount from select count(*) from src where key > ?;
+prepare pcount from select count(*) from src where key > ?;
+execute pcount using 200;
+
+-- single param
+explain extended prepare p1 from select * from src where key > ? order by key
limit 10;
+prepare p1 from select * from src where key > ? order by key limit 10;
+
+execute p1 using 200;
+
+-- same query, different param
+execute p1 using 0;
+
+-- same query, negative param
+--TODO: fails (constant in grammar do not support negatives)
+-- execute p1 using -1;
Review comment:
https://issues.apache.org/jira/browse/HIVE-24002
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 467384)
Time Spent: 4h 10m (was: 4h)
> Support parameterized queries in WHERE/HAVING clause
> ----------------------------------------------------
>
> Key: HIVE-23951
> URL: https://issues.apache.org/jira/browse/HIVE-23951
> Project: Hive
> Issue Type: Sub-task
> Components: Query Planning
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Labels: pull-request-available
> Time Spent: 4h 10m
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
