[
https://issues.apache.org/jira/browse/BEAM-7100?focusedWorklogId=229422&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-229422
]
ASF GitHub Bot logged work on BEAM-7100:
----------------------------------------
Author: ASF GitHub Bot
Created on: 17/Apr/19 21:50
Start Date: 17/Apr/19 21:50
Worklog Time Spent: 10m
Work Description: akedin commented on pull request #8339: [BEAM-7100]
BeamValuesRel should accept empty tuples
URL: https://github.com/apache/beam/pull/8339#discussion_r276447848
##########
File path:
sdks/java/extensions/sql/src/test/java/org/apache/beam/sdk/extensions/sql/impl/rel/BeamJoinRelBoundedVsBoundedTest.java
##########
@@ -105,6 +105,34 @@ public void testLeftOuterJoin() throws Exception {
pipeline.run();
}
+ @Test
+ public void testLeftOuterJoinWithEmptyTuplesOnRightSide() throws Exception {
+ String sql =
+ "SELECT * "
+ + "FROM ORDER_DETAILS1 o1"
+ + " LEFT OUTER JOIN (SELECT * FROM ORDER_DETAILS2 WHERE FALSE) o2"
Review comment:
What gets converted to `Values` in this query?
----------------------------------------------------------------
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: 229422)
Time Spent: 50m (was: 40m)
> BeamValuesRel should accept empty tuples
> ----------------------------------------
>
> Key: BEAM-7100
> URL: https://issues.apache.org/jira/browse/BEAM-7100
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql
> Reporter: Rui Wang
> Assignee: Rui Wang
> Priority: Major
> Time Spent: 50m
> Remaining Estimate: 0h
>
> It is possible for a OUTER JOIN, one side of JOIN contains no tuples. Right
> now such case will thrown an exception with "empty tuples are not allowed".
> However, for OUTER JOIN, empty values on one side can still produce results
> if another side has tuples.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
