[ https://issues.apache.org/jira/browse/IMPALA-8241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16777242#comment-16777242 ]
Tim Armstrong commented on IMPALA-8241: --------------------------------------- I think this is the thing we have --use_local_tz_for_unix_timestamp_conversions for If I run impala with "start-impala-cluster.py --impalad_args=--use_local_tz_for_unix_timestamp_conversions=true", i get: {noformat} [localhost:21000] default> select from_utc_timestamp(cast(400000 * 3600.0 as timestamp), 'EST'); Query: select from_utc_timestamp(cast(400000 * 3600.0 as timestamp), 'EST') Query submitted at: 2019-02-25 11:44:01 (Coordinator: http://tarmstrong-box:25000) Query progress can be monitored at: http://tarmstrong-box:25000/query_plan?query_id=9e435928e630b26d:2489fb7800000000 +---------------------------------------------------------------+ | from_utc_timestamp(cast(400000 * 3600.0 as timestamp), 'est') | +---------------------------------------------------------------+ | 2015-08-19 04:00:00 | +---------------------------------------------------------------+ Fetched 1 row(s) in 0.30s {noformat} [~attilaj] can confirm maybe > from_utc_timestamp returns inconsistent results with Hive > --------------------------------------------------------- > > Key: IMPALA-8241 > URL: https://issues.apache.org/jira/browse/IMPALA-8241 > Project: IMPALA > Issue Type: Bug > Reporter: Quanlong Huang > Priority: Major > > This can be reproduced in both master and 2.x branches. > {code} > [localhost:21000] default> select from_utc_timestamp(cast(400000 * 3600.0 as > timestamp), 'EST'); > Query: select from_utc_timestamp(cast(400000 * 3600.0 as timestamp), 'EST') > Query submitted at: 2019-02-23 17:27:02 (Coordinator: > http://impala-jenkins-slave-02:25000) > Query progress can be monitored at: > http://impala-jenkins-slave-02:25000/query_plan?query_id=f476c87a904f281:71588a2400000000 > +---------------------------------------------------------------+ > | from_utc_timestamp(cast(400000 * 3600.0 as timestamp), 'est') | > +---------------------------------------------------------------+ > | 2015-08-19 11:00:00 | > +---------------------------------------------------------------+ > Fetched 1 row(s) in 0.64s > {code} > {code} > hive> select from_utc_timestamp(cast(400000 * 3600.0 as timestamp), 'EST'); > OK > 2015-08-19 04:00:00 > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org