[jira] [Resolved] (IMPALA-9145) Compute stats fails with invalid timezone

["Aman Sinha (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-9145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aman Sinha resolved IMPALA-9145.
--------------------------------
    Fix Version/s: Impala 4.0
         Assignee: Aman Sinha
       Resolution: Workaround

Resolving this as a reasonable workaround exists.

> Compute stats fails with invalid timezone
> -----------------------------------------
>
>                 Key: IMPALA-9145
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9145
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 3.3.0
>            Reporter: Aman Sinha
>            Assignee: Aman Sinha
>            Priority: Minor
>              Labels: supportability
>             Fix For: Impala 4.0
>
>
> On my Ubuntu machine with latest Impala build I get the following error:
> {noformat}
> [localhost:21000] tpch> compute stats lineitem;
> Query: compute stats lineitem
> ERROR: Invalid timezone name 'posixrules'. {noformat}
> This causes a bunch of unit tests that rely on stats to fail. 
> After setting the TIMEZONE explicitly, this works: 
> {noformat}
> 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). |
> +------------------------------------------+
> {noformat}
> My /etc/timezone has a valid timezone:
> {noformat}
> $ cat /etc/timezone
> America/New_York
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)