[DRILL-5620] aggregate FILTER pushing invalid SQL to vendors that do not support it.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: SQL Parser

Environment

Drill 1.10

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 29/Jun/17 12:03
• Updated: 29/Jun/17 12:07

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 SELECT "CINT", "RNUM" > -1 "$f1" FROM X"."Y"

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