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
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