[
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)
