[ https://issues.apache.org/jira/browse/DRILL-6978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva reassigned DRILL-6978: --------------------------------------- Assignee: Volodymyr Vysotskyi > 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 > Assignee: Volodymyr Vysotskyi > Priority: Major > > > *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)