benj created DRILL-7396: --------------------------- Summary: Exception when trying to access last element of an array with repeated_count Key: DRILL-7396 URL: https://issues.apache.org/jira/browse/DRILL-7396 Project: Apache Drill Issue Type: Bug Components: Functions - Drill Affects Versions: 1.16.0 Reporter: benj
Use of array in drill is not friendly {code:sql} SELECT (split('a,b,c',','))[0]; /*NOK */ Error: SYSTEM ERROR: ClassCastException: org.apache.drill.common.expression.FunctionCall cannot be cast to org.apache.drill.common.expression.SchemaPath /* outer SELECT needed*/ SELECT x[0] FROM (SELECT split('a,b,c',',') x); /* OK */ {code} And access last element of an array is worse {code:sql} SELECT x[repeated_count(x) - 1] AS lasteltidx FROM (SELECT split('a,b,c',',') x); Error: SYSTEM ERROR: ClassCastException: org.apache.calcite.rex.RexCall cannot be cast to org.apache.calcite.rex.RexLiteral /* while */ SELECT x[2] lastelt, (repeated_count(x) - 1) AS lasteltidx FROM (SELECT split('a,b,c',',') x); +---------+------------+ | lastelt | lasteltidx | +---------+------------+ | c | 2 | +---------+------------+ {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)