[jira] [Created] (DRILL-6978) typeOf drillTypeOf sqlTypeOf not work with generated tables

["benj (JIRA)" <ji...@apache.org>]

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)