[DRILL-1850] Drill fails to aggregate on a bit field

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Functions - Drill
• Assignee: Mehant Baid
• Reporter: Jason Altekruse
• Created: 12/Dec/14 02:39
• Updated: 23/Jan/15 03:02
• Resolved: 23/Jan/15 03:02

Description

select true as t from cp.`/store/json/bit_data.json` order by t

obviously as the table is not being referenced, so you can just swap out the table with a file that is present on your machine to reproduce the error.

It looks like we do not have a definition for comparison between bits, this might be intentional as the bit can be implicitly cast to another numeric type before doing the comparison. We either need to fix implicit cast or define a function for comparing bits.

org.apache.drill.exec.rpc.RpcException: Query failed: Failure while running fragment., Failure finding function that runtime code generation expected. Signature: compare_to( BIT:REQUIREDBIT:REQUIRED, ) returns INT:REQUIRED [ db1b45ec-21aa-4a7c-acef-541f8ac8fb86 on 10.250.0.96:31010 ]
[ db1b45ec-21aa-4a7c-acef-541f8ac8fb86 on 10.250.0.96:31010 ]