[jira] [Created] (DRILL-4244) Need to understand and document where the setting of user.timezone is picked up by default

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-4244:
---------------------------------------

             Summary: Need to understand and document where the setting of user.timezone is picked up by default
                 Key: DRILL-4244
                 URL: https://issues.apache.org/jira/browse/DRILL-4244
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.5.0
            Reporter: Victoria Markman


I have two boxes where /etc/localtime is pointing to the same timezone:

{code}
[bin]# ls -l /etc/localtime
lrwxrwxrwx 1 root root 26 Dec 31 00:25 /etc/localtime -> /usr/share/zoneinfo/Israel
[bin]# date
Mon Jan  4 20:38:21 IST 2016
{code}

However, when I query sys.boot table, I see two different settings:

box #1
{code}
0: jdbc:drill:drillbit=localhost> select * from sys.boot where name like '%timezone%';
+----------------+---------+-------+---------+----------+------------------------+-----------+------------+
|      name      |  kind   | type  | status  | num_val  |       string_val       | bool_val  | float_val  |
+----------------+---------+-------+---------+----------+------------------------+-----------+------------+
| user.timezone  | STRING  | BOOT  | BOOT    | null     | "America/Los_Angeles"  | null      | null       |
+----------------+---------+-------+---------+----------+------------------------+-----------+------------+
1 row selected (0.638 seconds)
{code}

box #2
{code}
0: jdbc:drill:drillbit=localhost> select * from sys.boot where name like '%timezone%';
+----------------+---------+-------+---------+----------+-------------+-----------+------------+
|      name      |  kind   | type  | status  | num_val  | string_val  | bool_val  | float_val  |
+----------------+---------+-------+---------+----------+-------------+-----------+------------+
| user.timezone  | STRING  | BOOT  | BOOT    | null     | "UTC"       | null      | null       |
+----------------+---------+-------+---------+----------+-------------+-----------+------------+
1 row selected (0.425 seconds)
{code}

The only way to change timezone on a server is to start a drillbit with 
DRILL_JAVA_OPTS=-Duser.timezone=<desired timezone>. This works correctly. However, I'm not sure where the default is picked up from, because I'm running with the default settings and I did not touch neither drill-env.sh nor drill-override.conf (Supposedly you can't even change the setting there: DRILL-2779)
 
The only place where I see any reference to user.timezone is here:
SimpleParallelizer.java:    int timeZone = DateUtility.getIndex(System.getProperty("user.timezone"));





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)