You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@beam.apache.org by "Anton Kedin (JIRA)" <ji...@apache.org> on 2017/12/19 22:24:00 UTC

[jira] [Updated] (BEAM-3188) [SQL] Query Parametrization

     [ https://issues.apache.org/jira/browse/BEAM-3188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anton Kedin updated BEAM-3188:
------------------------------
    Description: 
Look into SQL query parametrization/templating. 

Calcite supports parameters: https://issues.apache.org/jira/browse/CALCITE-2054

Beam does not:
{code:java}
Caused by: java.lang.UnsupportedOperationException: class org.apache.calcite.rex.RexDynamicParam is not supported yet!
	at org.apache.beam.sdk.extensions.sql.impl.interpreter.BeamSqlFnExecutor.buildExpression(BeamSqlFnExecutor.java:430)
{code}

  was:
Look into SQL query parametrization/templating. 

From a brief glance neither Beam SQL nor Calcite support query parameters/templating. It would be a nice feature to have, maybe it could work together with things like Dataflow Templates.


> [SQL] Query Parametrization
> ---------------------------
>
>                 Key: BEAM-3188
>                 URL: https://issues.apache.org/jira/browse/BEAM-3188
>             Project: Beam
>          Issue Type: Bug
>          Components: dsl-sql
>            Reporter: Anton Kedin
>
> Look into SQL query parametrization/templating. 
> Calcite supports parameters: https://issues.apache.org/jira/browse/CALCITE-2054
> Beam does not:
> {code:java}
> Caused by: java.lang.UnsupportedOperationException: class org.apache.calcite.rex.RexDynamicParam is not supported yet!
> 	at org.apache.beam.sdk.extensions.sql.impl.interpreter.BeamSqlFnExecutor.buildExpression(BeamSqlFnExecutor.java:430)
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)