Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

date format invalid in impala, but works in hive

Highlighted

date format invalid in impala, but works in hive

Contributor

Hi, 
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


thanks

Don't have an account?
Coming from Hortonworks? Activate your account here