Forum Discussion
Impala Cloudera Direct Query create Date table
Hello all we are trying to connect to Impala using Direct query option . We are able to connect but the date /datetime columns (Timestamp) are coming as text . When we try to change the type to Date ...
Is there an answer for this question
Try not to revive old threads, but yes, there is an answer.
As Angelia said, you can only change datatypes, etc. in Import mode; in DirectQuery, you're pulling data directly from the datasource, so if you want anything changed, it needs to be done in the backend (i.e. change the datatype in Impala).