[jira] [Resolved] (DRILL-1157) Views do not support boolean types

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

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

Jacques Nadeau resolved DRILL-1157.
-----------------------------------

    Resolution: Fixed
      Assignee: Ramana Inukonda Nagaraj

Ramana, this should be fixed by DRILL-1138 merge.  Please confirm.

> Views do not support boolean types
> ----------------------------------
>
>                 Key: DRILL-1157
>                 URL: https://issues.apache.org/jira/browse/DRILL-1157
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Norris Lee
>            Assignee: Ramana Inukonda Nagaraj
>
> I have a hive table with boolean values:
> {code}
> 0: jdbc:drill:zk=localhost:5181> select * from `hive43.default`.`bit_table`;
> +------------+------------+
> | keycolumn  |  column1   |
> +------------+------------+
> | Zero       | false      |
> | One        | true       |
> +------------+------------+
> 2 rows selected (0.496 seconds)
> {code}
> If I create a view from this table, I cannot query the view:
> {code}
> 0: jdbc:drill:zk=localhost:5181> create view `dfs.test`.`bitview` as select * from `hive43.default`.`bit_table`;
> +------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | true       | View 'bitview' created successfully in 'dfs.test' schema |
> +------------+------------+
> 1 row selected (0.629 seconds)
> 0: jdbc:drill:zk=localhost:5181> select * from `dfs.test`.`bitview`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "f68f6088-a748-4e07-9039-1d13d086a4f1"
> endpoint {
>   address: "192.168.39.43"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < IllegalArgumentException:[ No enum constant org.apache.drill.common.types.TypeProtos.MinorType.BOOLEAN ]"
> ]
> Error: exception while executing query (state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)