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 ...
Hi hmpatel9,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.
Best Regards,
Angelia
Hello Angelia .. Thank you for your inputs but I have not been able to solve this issue . WhenI try to change the data type of compluted column data type it gives a error that "Change type is not supprted for this source"
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).
