[ 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 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. 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 https://calcite.apache.org/docs/reference.html > aggregate FILTER is being pushed 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 > https://calcite.apache.org/docs/reference.html -- This message was sent by Atlassian JIRA (v6.4.14#64029)