Hi,

we have the context as , A table containing the date column with STRING as data type in the format  2014-09-24 19:21:38:532+0000. Tableau  is taking a lot of time while doing operations on this date column. Impala does not support DATE data type to convert it to date though hive supports, so we changed to TIMESTAMP format but Impala returns the following error.

Error converting column: 10 TO TIMESTAMP (Data is: 2014-10-09 11:46:48:424+0000). Not sure if that is because the data is following the format as HH:MM:SEC:sssss. Any ideas on this how can we make this data better read through impala with out much performance issue.

Regards

Sree