[IMPALA-9145] Compute stats fails with invalid timezone

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Workaround
• Affects Version/s: Impala 3.3.0
• Fix Version/s: Impala 4.0.0
• Component/s: Backend
• Labels: supportability

Docs Text

Workaround:
Set the TIMEZONE query option or the TZ environment variable to override this.

• Epic Color: ghx-label-12
• Assignee: Aman Sinha
• Reporter: Aman Sinha
• Created: 11/Nov/19 21:15
• Updated: 23/Feb/21 00:29
• Resolved: 23/Feb/21 00:29

Description

On my Ubuntu machine with latest Impala build I get the following error:

[localhost:21000] tpch> compute stats lineitem;
Query: compute stats lineitem
ERROR: Invalid timezone name 'posixrules'. 

This causes a bunch of unit tests that rely on stats to fail.

After setting the TIMEZONE explicitly, this works:

localhost:21000] tpch> set TIMEZONE=America/Los_Angeles;
TIMEZONE set to America/Los_Angeles
[localhost:21000] tpch> compute stats lineitem;
Query: compute stats lineitem
+------------------------------------------+
| summary                                  |
+------------------------------------------+
| Updated 1 partition(s) and 16 column(s). |
+------------------------------------------+

My /etc/timezone has a valid timezone:

$ cat /etc/timezone
America/New_York