Slim Bouguerra created SAMZA-2571:
-------------------------------------
Summary: 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
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)
