[DRILL-1134] CompilationException for 2 or more Filters on an array type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Codegen
• Assignee: DrillCommitter
• Reporter: Aman Sinha
• Created: 11/Jul/14 21:48
• Updated: 27/Jul/14 19:33
• Resolved: 27/Jul/14 19:33

Description

The following query's generated code for the Filter consists of the doEval() block which has redefinition of variable isNull which causes a compilation failure. Note that isNull is not even referenced in the generated code.

SELECT columns[0]
FROM dfs.`/Users/asinha/data/regions.csv`
WHERE cast(columns[0] as int) > 1
ANDcast(columns[1] as varchar(20))='ASIA';

}
] < CompileException:[ Line 82, Column 28: Redefinition of local variable "isNull" ]"

I also get a Deadbuf access for this query, but that could be a separate issue.

Issue Links

• duplicates: DRILL-1148 Using multiple filters with Text files fails to compile the runtime generated code