You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/01/08 21:10:34 UTC
[jira] [Updated] (DRILL-1959) Issues with explicit casts to TINYINT
and SMALLINT
[ https://issues.apache.org/jira/browse/DRILL-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Girish updated DRILL-1959:
-----------------------------------
Description:
*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)
was:
*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)
> Issues with explicit casts to TINYINT and SMALLINT
> --------------------------------------------------
>
> Key: DRILL-1959
> URL: https://issues.apache.org/jira/browse/DRILL-1959
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Reporter: Abhishek Girish
> Assignee: Jacques Nadeau
>
> *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)