You can change the default query options via impalad command line options: -default_query_options='PARQUET_FALLBACK_SCHEMA_RESOLUTION=name' The same can be done in Cloudera Manager: https://www.cloudera.com/documentation/enterprise/5-12-x/topics/impala_config_options.html ... View more

You can create a table with a text column first, and then use to_timestamp to convert it into a table with a timestamp column. create table timestamp_table as select column_1, column_2, to_timestamp(column_3, "dd/MM/yyyy HH:mm") from text_table; For documentations on timestamp-related functions, please visit https://impala.apache.org/docs/build/html/topics/impala_datetime_functions.html ... View more