[DRILL-1138] Explicit casting to boolean fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.4.0
• Component/s: Execution - Data Types
• Assignee: Aditya Kishore
• Reporter: Ramana Inukonda Nagaraj
• Created: 13/Jul/14 18:35
• Updated: 29/Sep/14 06:15
• Resolved: 21/Jul/14 02:48

Description

0: jdbc:drill:schema=dfs.TpcHMulti> select cast(C_CUSTKEY as boolean) as booleantest from customer limit 1;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "c20bd69f-bb5c-443e-a01b-8571b4c86490"
endpoint {
address: "drillats1.qa.lab"
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

• is duplicated by: DRILL-1157 Views do not support boolean types