drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5620) aggregate FILTER pushing invalid SQL to vendors that do not support it.
Date Thu, 29 Jun 2017 12:08:00 GMT

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

N Campbell updated DRILL-5620:
------------------------------
    Description: 
Calcite's parser documentation indicates that it has provided for aggregate(<exp>) FILTER.

This construct is not supported by many vendors, hence it such a statement is expressed to
Drill against a plugin mapped to JDBC it may fail due to the statement being push down (i.e.
to ORACLE). But the operation will parse/execute when performed locally on dfs etc

select count(  CINT ) filter ( where RNUM > -1) from x.y.z
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query

Looks like it tries to emit
sql SELECT "CINT", "RNUM" > -1 "$f1" FROM X"."Y"

https://calcite.apache.org/docs/reference.html



  was:
Calcite's parser documentation indicates that it has provided for aggregate(<exp>) FILTER.

This construct is not supported by many vendors, hence it such a statement is expressed to
Drill against a plugin mapped to JDBC it may fail due to the statement being push down (i.e.
to ORACLE). But the operation will parse/execute when performed locally on dfs etc

select count(  CINT ) filter ( where RNUM > -1) from x.y.z
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query

Looks like it tries to emit
sql SELECT "CINT", "RNUM" > -1 "$f1"
FROM "DBCERT"."VINT"

https://calcite.apache.org/docs/reference.html




> aggregate FILTER pushing invalid SQL to vendors that do not support it. 
> ------------------------------------------------------------------------
>
>                 Key: DRILL-5620
>                 URL: https://issues.apache.org/jira/browse/DRILL-5620
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>    Affects Versions: 1.10.0
>         Environment: Drill 1.10
>            Reporter: N Campbell
>
> Calcite's parser documentation indicates that it has provided for aggregate(<exp>)
FILTER.
> This construct is not supported by many vendors, hence it such a statement is expressed
to Drill against a plugin mapped to JDBC it may fail due to the statement being push down
(i.e. to ORACLE). But the operation will parse/execute when performed locally on dfs etc
> select count(  CINT ) filter ( where RNUM > -1) from x.y.z
> DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query
> Looks like it tries to emit
> sql SELECT "CINT", "RNUM" > -1 "$f1" FROM X"."Y"
> https://calcite.apache.org/docs/reference.html



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

Mime
View raw message