[GitHub] [beam] kennknowles opened a new issue, #18672: optional parameter is not supported in BeamSQL

[GitBox <gi...@apache.org>]

kennknowles opened a new issue, #18672:
URL: https://github.com/apache/beam/issues/18672

   I'm wring a UDF with optional parameters, the method code is:
   ```
   
     public static String eval(String kvString, String keyName
         , @Parameter(name = "pd", optional
   = true) String pairSeperator
         , @Parameter(name = "kvd", optional = true) String kvSeperator){
   
      //...
     }
   
   ```
   
   
   And I see this error when assembling a Beam pipeline:
   ```
   
   Execution Plan: 
   BeamProjectRel(ITEM_ID=[CAST(KV_EXT($0, 'itemId', DEFAULT(), DEFAULT())):BIGINT],
   TRANSACTION_ID=[CAST(KV_EXT($0, 'transactionId', DEFAULT(), DEFAULT())):BIGINT], TRANSACTION_TIME=[KV_EXT($0,
   'createdDT', DEFAULT(), DEFAULT())])
     BeamIOSourceRel(table=[[....]])
   
   Exception in thread "main"
   java.lang.RuntimeException: java.lang.UnsupportedOperationException: Operator: DEFAULT is not supported
   yet!
   	at .........
   Caused by: java.lang.UnsupportedOperationException: Operator: DEFAULT is not supported
   yet!
   	at org.apache.beam.sdk.extensions.sql.impl.interpreter.BeamSqlFnExecutor.buildExpression(BeamSqlFnExecutor.java:425)
   	at
   org.apache.beam.sdk.extensions.sql.impl.interpreter.BeamSqlFnExecutor.buildExpression(BeamSqlFnExecutor.java:202)
   	at
   org.apache.beam.sdk.extensions.sql.impl.interpreter.BeamSqlFnExecutor.buildExpression(BeamSqlFnExecutor.java:202)
   	at
   org.apache.beam.sdk.extensions.sql.impl.interpreter.BeamSqlFnExecutor.<init>(BeamSqlFnExecutor.java:126)
   	at
   org.apache.beam.sdk.extensions.sql.impl.rel.BeamProjectRel.buildBeamPipeline(BeamProjectRel.java:70)
   	at
   org.apache.beam.sdk.extensions.sql.impl.planner.BeamQueryPlanner.compileBeamPipeline(BeamQueryPlanner.java:116)
   	at
   org.apache.beam.sdk.extensions.sql.BeamSqlCli.compilePipeline(BeamSqlCli.java:112)
   
   ```
   
   
   Imported from Jira [BEAM-3325](https://issues.apache.org/jira/browse/BEAM-3325). Original Jira may contain additional context.
   Reported by: mingmxu.


-- 
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.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org