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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
