benj created DRILL-6978: --------------------------- Summary: typeOf drillTypeOf sqlTypeOf not work with generated tables Key: DRILL-6978 URL: https://issues.apache.org/jira/browse/DRILL-6978 Project: Apache Drill Issue Type: Bug Components: Functions - Drill Affects Versions: 1.15.0 Reporter: benj
*TypeOf functions works when request on files but doesn't work on "generated" data This works : {code:java} SELECT typeof(md5), drillTypeOf(md5), sqlTypeOf(md5) FROM dfs.tmp.`mytable.csv` LIMIT 2; => (OK) +----------+----------+--------------------+ | EXPR$0 | EXPR$1 | EXPR$2 | +----------+----------+--------------------+ | VARCHAR | VARCHAR | CHARACTER VARYING | | VARCHAR | VARCHAR | CHARACTER VARYING | +----------+----------+--------------------+{code} But not : {code:java} SELECT typeOf(a) FROM (SELECT CAST (5 as int) AS a) x; => (NOK) Error: SYSTEM ERROR: IllegalArgumentException: Can not set org.apache.drill.exec.vector.complex.reader.FieldReader field org.apache.drill.exec.expr.fn.impl.UnionFunctions$GetType.input to org.apache.drill.exec.expr.holders.IntHolder {code} And in a surprising way the next query works : {code:java} SELECT md5, typeof(t), drillTypeOf(t), sqlTypeOf(t) FROM ((SELECT 'foo' AS t ) union (SELECT 'far' AS t)) x; => (OK) +-------+----------+----------+--------------------+ | md5 | EXPR$1 | EXPR$2 | EXPR$3 | +-------+----------+----------+--------------------+ | foo | VARCHAR | VARCHAR | CHARACTER VARYING | | bar | VARCHAR | VARCHAR | CHARACTER VARYING | +-------+----------+----------+--------------------+{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)