drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1959) Issues with explicit casts to TINYINT, SMALLINT & REAL
Date Fri, 13 Feb 2015 02:32:11 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Abhishek Girish updated DRILL-1959:
-----------------------------------
    Assignee: Sean Hsuan-Yi Chu  (was: Jacques Nadeau)

> Issues with explicit casts to TINYINT, SMALLINT & REAL
> ------------------------------------------------------
>
>                 Key: DRILL-1959
>                 URL: https://issues.apache.org/jira/browse/DRILL-1959
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Execution - Data Types
>            Reporter: Abhishek Girish
>            Assignee: Sean Hsuan-Yi Chu
>             Fix For: Future
>
>
> *The following have Issues:*
> > create table tiny1 as select cast(1 as *tinyint*) from sys.options limit 1;
> +------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | false      | *Error: Unable to convert the value of 1 and type TINYINT to a Drill constant
expression.* |
> +------------+------------+
> 1 row selected (0.055 seconds)
> > create table small1 as select cast(1 as *smallint*) from sys.options limit 1;
> +------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | false      | *Error: Unable to convert the value of 1 and type SMALLINT to a Drill
constant expression.* |
> +------------+------------+
> 1 row selected (0.055 seconds)
> *The following work:*
> > create table int1 as select cast(1 as *int*) from sys.options limit 1;
> +------------+---------------------------+
> |  Fragment  | Number of records written |
> +------------+---------------------------+
> | 0_0        | 1                         |
> +------------+---------------------------+
> 1 row selected (0.172 seconds)
> > create table big1 as select cast(1 as *bigint*) from sys.options limit 1;
> +------------+---------------------------+
> |  Fragment  | Number of records written |
> +------------+---------------------------+
> | 0_0        | 1                         |
> +------------+---------------------------+
> 1 row selected (0.195 seconds)
> > create table float1 as select cast(1 as *float*) from sys.options limit 1;
> +------------+---------------------------+
> |  Fragment  | Number of records written |
> +------------+---------------------------+
> | 0_0        | 1                         |
> +------------+---------------------------+
> 1 row selected (0.174 seconds)
> 0: jdbc:drill:zk=10.10.103.34:5181> create table double1 as select cast(1 as *double*)
from sys.options limit 1;
> +------------+---------------------------+
> |  Fragment  | Number of records written |
> +------------+---------------------------+
> | 0_0        | 1                         |
> +------------+---------------------------+
> 1 row selected (0.153 seconds)
> 0: jdbc:drill:zk=10.10.103.34:5181> create table decimal1 as select cast(1 as *decimal(1,1)*)
from sys.options limit 1;
> +------------+---------------------------+
> |  Fragment  | Number of records written |
> +------------+---------------------------+
> | 0_0        | 1                         |
> +------------+---------------------------+
> 1 row selected (0.159 seconds)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message