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:24:00 UTC

[jira] [Created] (SAMZA-2571) Add support for unnest sql operator

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)