Norris Lee created DRILL-1157:
---------------------------------
Summary: 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
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)
