Posts: 35
Registered: ‎04-07-2016

date format invalid in impala, but works in hive

I am trying to parse a date in impala using the unix_timestamp fonction. 

select unix_timestamp('Thu Dec 17 15:55:08 IST 2015', 'EEE MMM d HH:mm:ss ZZZ yyyy')

But I get the follow error: 

  • Bad date/time conversion format: EEE MMM d HH:mm:ss ZZZ yyyy

The same query works in hive. Is there something that I need to change the the pattern to make it work in impala?

I am currently on cdh 5.12