[
https://issues.apache.org/jira/browse/HIVE-24613?focusedWorklogId=534216&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-534216
]
ASF GitHub Bot logged work on HIVE-24613:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 11/Jan/21 12:40
Start Date: 11/Jan/21 12:40
Worklog Time Spent: 10m
Work Description: kasakrisz opened a new pull request #1847:
URL: https://github.com/apache/hive/pull/1847
### What changes were proposed in this pull request?
Prior this patch for defining a row of constant values Select clause could
be used:
```
SELECT * FROM t1 foo
JOIN (select 1,'a') as bar ON foo.col1 = bar.col1
```
This enables the usage of Values clasuse:
```
SELECT * FROM t1 foo
JOIN (VALUES(1,'a'),(4,'b')) as bar ON foo.col1 = bar.col1
```
### Why are the changes needed?
With Select clause only one row could be defined. There is no such
limitation with Values clause.
### Does this PR introduce _any_ user-facing change?
Yes. From now the Values clause can be used in subqueries and can be a query
itself.
### How was this patch tested?
```
mvn test -Dtest=TestValuesClause -pl parser
mvn test -Dtest.output.overwrite -DskipSparkTests
-Dtest=TestMiniLlapLocalCliDriver -Dqfile=values.q -pl itests/qtest -Pitests
```
----------------------------------------------------------------
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: 534216)
Remaining Estimate: 0h
Time Spent: 10m
> Support Values clause without Insert
> ------------------------------------
>
> Key: HIVE-24613
> URL: https://issues.apache.org/jira/browse/HIVE-24613
> Project: Hive
> Issue Type: Improvement
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Standalone:
> {code}
> VALUES(1,2,3),(4,5,6);
> {code}
> {code}
> 1 2 3
> 4 5 6
> {code}
> In subquery:
> {code}
> SELECT * FROM (VALUES(1,2,3),(4,5,6)) as FOO;
> {code}
> {code}
> 1 2 3
> 4 5 6
> {code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
