Re: Apache DRILL v1.11.0 handling Postgres citext columns with Inconsistency

2017-10-01 Thread Mick Bisignani
Kunal , no errors generated or is a stack generated when I run the commands. ..Just getting "null" for column term when it does not work. just to recap , here is what I see # CITEXT must be CAST SELECT CAST(tb1.id AS INTEGER) AS id, tb1.term as term1, CAST(tb1.term AS VARC

RE: Apache DRILL v1.11.0 handling Postgres citext columns with Inconsistency

2017-09-18 Thread Kunal Khatua
It's odd that adding just a term_count column is causing an error but the other 2 columns (created, updated) don't seem to be... and gets resolved on removing the cast. Can you provide the stack trace and error message? Also, what are the data types for the other columns? -Original Messag