[DRILL-1157] Views do not support boolean types

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Ramana Inukonda Nagaraj
• Reporter: Norris Lee
• Created: 17/Jul/14 20:55
• Updated: 31/Jul/14 06:32
• Resolved: 21/Jul/14 03:31

Description

I have a hive table with boolean values:

0: jdbc:drill:zk=localhost:5181> select * from `hive43.default`.`bit_table`;
+------------+------------+
| keycolumn  |  column1   |
+------------+------------+
| Zero       | false      |
| One        | true       |
+------------+------------+
2 rows selected (0.496 seconds)

If I create a view from this table, I cannot query the view:

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)

Issue Links

• duplicates: DRILL-1138 Explicit casting to boolean fails