You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by pengcheng xiong <px...@hortonworks.com> on 2015/09/01 01:55:06 UTC
Re: Review Request 37620: Hive Parser to Support multi col in clause
(x, y..) in ((..), ..., ())
> On Aug. 25, 2015, 1:17 a.m., John Pullokkaran wrote:
> > ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g, line 475
> > <https://reviews.apache.org/r/37620/diff/2/?file=1047868#file1047868line475>
> >
> > How about (x,y) in (select a,b from t)
We are going to support this in the next phase.
- pengcheng
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/37620/#review96264
-----------------------------------------------------------
On Aug. 21, 2015, 10:07 p.m., pengcheng xiong wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/37620/
> -----------------------------------------------------------
>
> (Updated Aug. 21, 2015, 10:07 p.m.)
>
>
> Review request for hive and John Pullokkaran.
>
>
> Repository: hive-git
>
>
> Description
> -------
>
> Current hive only support single column in clause, e.g.,
> {code}select * from src where col0 in (v1,v2,v3);{code}
> We want it to support
> {code}select * from src where (col0,col1+3) in ((col0+v1,v2),(v3,v4-col1));{code}
>
>
> Diffs
> -----
>
> ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g 64af7d1
> ql/src/test/org/apache/hadoop/hive/ql/parse/TestSQL11ReservedKeyWordsNegative.java 61b5892
> ql/src/test/org/apache/hadoop/hive/ql/parse/TestSQL11ReservedKeyWordsPositive.java 4c84e91
> ql/src/test/queries/clientpositive/char_udf1.q 8848609
> ql/src/test/queries/clientpositive/multi_column_in.q PRE-CREATION
> ql/src/test/queries/clientpositive/varchar_udf1.q 395fb12
> ql/src/test/results/clientpositive/char_udf1.q.java1.7.out ced0132
> ql/src/test/results/clientpositive/multi_column_in.q.out PRE-CREATION
> ql/src/test/results/clientpositive/varchar_udf1.q.java1.7.out 96ba06e
>
> Diff: https://reviews.apache.org/r/37620/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> pengcheng xiong
>
>