You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@samza.apache.org by "Slim Bouguerra (Jira)" <ji...@apache.org> on 2020/07/30 17:25:00 UTC
[jira] [Commented] (SAMZA-2571) Add support for unnest sql operator
[ https://issues.apache.org/jira/browse/SAMZA-2571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17168091#comment-17168091 ]
Slim Bouguerra commented on SAMZA-2571:
---------------------------------------
cc [~atoomula]
> Add support for unnest sql operator
> -----------------------------------
>
> Key: SAMZA-2571
> URL: https://issues.apache.org/jira/browse/SAMZA-2571
> Project: Samza
> Issue Type: Improvement
> Reporter: Slim Bouguerra
> Priority: Major
>
> Currently Samza Sql does not support unnest operator.
> {code:java}
> "Insert into testavro.outputTopic (id, string_value)
> select innertable.kind as string_value, innertable.number from unnest(select `phoneNumbers` from testavro.PROFILE) as innertable";
> {code}
> Planned as
> {code:java}
> 2020-07-30 10:17:23.877 [main] [] QueryPlanner [INFO] query plan without optimization:
> LogicalProject(string_value=[$0], number=[$1])
> Uncollect
> LogicalProject(EXPR$0=[$5])
> LogicalTableScan(table=[[testavro, PROFILE]])
> {code}
> Fails with
> {code:java}
> Caused by: java.lang.NullPointerException
> at org.apache.samza.sql.translator.ProjectTranslator.translate(ProjectTranslator.java:306)
> at org.apache.samza.sql.translator.QueryTranslator$2.visit(QueryTranslator.java:258)
> at org.apache.calcite.rel.logical.LogicalProject.accept(LogicalProject.java:144)
> at org.apache.samza.sql.translator.QueryTranslator.translate(QueryTranslator.java:228)
> at org.apache.samza.sql.runner.SamzaSqlApplication.describe(SamzaSqlApplication.java:80)
> at org.apache.samza.sql.runner.SamzaSqlApplication.describe(SamzaSqlApplication.java:47)
> at org.apache.samza.application.descriptors.StreamApplicationDescriptorImpl.<init>(StreamApplicationDescriptorImpl.java:81)
> at org.apache.samza.application.descriptors.ApplicationDescriptorUtil.getAppDescriptor(ApplicationDescriptorUtil.java:45)
> at org.apache.samza.runtime.LocalApplicationRunner.<init>(LocalApplicationRunner.java:132)
> at org.apache.samza.runtime.LocalApplicationRunner.<init>(LocalApplicationRunner.java:104)
> ... 31 more
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)