You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Volodymyr Vysotskyi (JIRA)" <ji...@apache.org> on 2019/01/25 16:59:00 UTC
[jira] [Resolved] (DRILL-6978) typeOf drillTypeOf sqlTypeOf not
work with generated tables
[ https://issues.apache.org/jira/browse/DRILL-6978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Volodymyr Vysotskyi resolved DRILL-6978.
----------------------------------------
Resolution: Fixed
Fixed in DRILL-6533
> 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
> Fix For: 1.16.0
>
>
>
> *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)