[IMPALA-8367] from_unixtime Bad date/time conversion format: u on NULL value

• Type: Bug
• Status: Reopened
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.11.0
• Component/s: Backend
• Labels: newbie ramp-up
• Environment: impalad version 2.11.0-cdh5.14.2 RELEASE (build ed85dce709da9557aeb28be89e8044947708876c) Built on Tue Mar 27 13:39:48 PDT 2018
• Epic Color: ghx-label-4
• Assignee: Unassigned
• Reporter: Sergio Leoni
• Created: 28/Mar/19 14:20
• Updated: 11/Jun/19 16:28

Description

The function

 from_unixtime(bigint unixtime[, string format]) 

output error if the value of unixtime is NULL and format is 'u'.

 

This doesn't work:

SELECT FROM_UNIXTIME(NULL, 'u')

Bad date/time conversion format: u

 

This works:

SELECT FROM_UNIXTIME(NULL, 'yyyy-MM-dd')

|from_unixtime(null, 'yyyy-mm-dd')|
|---------------------------------|
| NULL                            |
|---------------------------------|

 

I haven't checked all the possible combinations.
Other software like Hive handles this correctly.

 

Issue Links

• is related to: IMPALA-8580 Impala Doc: Explain SimpleDateFormat in Impala
• relates to: IMPALA-2190 Complete conversion functions between timestamp, unixtime/epoch, and string dates
• relates to: IMPALA-4018 Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT <template>)