Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 67656200C1A for ; Mon, 13 Feb 2017 18:06:19 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 65D41160B60; Mon, 13 Feb 2017 17:06:19 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id AFB2D160B4A for ; Mon, 13 Feb 2017 18:06:18 +0100 (CET) Received: (qmail 19279 invoked by uid 500); 13 Feb 2017 17:06:17 -0000 Mailing-List: contact reviews-help@impala.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list reviews@impala.incubator.apache.org Received: (qmail 19267 invoked by uid 99); 13 Feb 2017 17:06:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Feb 2017 17:06:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 1E6C91A7AEC for ; Mon, 13 Feb 2017 17:06:17 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.362 X-Spam-Level: X-Spam-Status: No, score=0.362 tagged_above=-999 required=6.31 tests=[RDNS_DYNAMIC=0.363, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 6QbgHQhQLhkC for ; Mon, 13 Feb 2017 17:06:16 +0000 (UTC) Received: from ip-10-146-233-104.ec2.internal (ec2-75-101-130-251.compute-1.amazonaws.com [75.101.130.251]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 0B78A5FC4A for ; Mon, 13 Feb 2017 17:06:16 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by ip-10-146-233-104.ec2.internal (8.14.4/8.14.4) with ESMTP id v1DH691P003804; Mon, 13 Feb 2017 17:06:09 GMT Message-Id: <201702131706.v1DH691P003804@ip-10-146-233-104.ec2.internal> Date: Mon, 13 Feb 2017 17:06:09 +0000 From: "Jim Apple (Code Review)" To: Taras Bobrovytsky , impala-cr@cloudera.com, reviews@impala.incubator.apache.org CC: Matthew Jacobs , Alex Behm , Jim Apple Reply-To: jbapple-impala@apache.org X-Gerrit-MessageType: comment Subject: =?UTF-8?Q?=5BImpala-ASF-CR=5D_IMPALA-4546=3A_Fix_Moscow_timezone_conversion_after_2014=0A?= X-Gerrit-Change-Id: Id6e3f2c9f6ba29749a26bc1087e664637bc02528 X-Gerrit-ChangeURL: X-Gerrit-Commit: b874ce9ee628cde13a9a3fe952b6929e9590f532 In-Reply-To: References: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Content-Disposition: inline User-Agent: Gerrit/2.12.7 archived-at: Mon, 13 Feb 2017 17:06:19 -0000 Jim Apple has posted comments on this change. Change subject: IMPALA-4546: Fix Moscow timezone conversion after 2014 ...................................................................... Patch Set 1: (7 comments) http://gerrit.cloudera.org:8080/#/c/5969/1/be/src/exprs/expr-test.cc File be/src/exprs/expr-test.cc: Line 3588: // IMPALA-4209: Moscow time change in 2011. Moscow could use a test on its own, rather than adding so many lines to TimestampFunctions. PS1, Line 3590: cast(from_utc_timestamp('2010-10-30 22:59:00', " : "'Europe/Moscow') as string) This could be turned into a template of calling TestStringValue with "cast(to_utc_timestamp('" and "'Europe/Moscow') as string)" appearing just once in this file to make reading what each test is supposed to do easier. Line 3596: TestIsNull("cast(to_utc_timestamp('2010-10-31 02:00:00', " Each one of these lines could use a short comment like "spring forward into DST, so 2am to 3am did not exist" or "TZs with ST/DST transitions were discontiguous on this region" http://gerrit.cloudera.org:8080/#/c/5969/1/be/src/exprs/timestamp-functions.cc File be/src/exprs/timestamp-functions.cc: PS1, Line 194: January 19, 1992 What about in 1991? http://gerrit.cloudera.org:8080/#/c/5969/1/be/src/exprs/timezone_db.h File be/src/exprs/timezone_db.h: PS1, Line 41: "tz" 'tz', because the parameter tz is a std::string and so "tz" is a valid value of 'tz'. Line 45: /// Moscow timezone UTC+3 with DST, for use before 27 March 2011. Between 27 March 2011 and 26 October 2014, which timezone was Moscow in? PS1, Line 48: October 26 2014 "26 October 2014" for parallelism with above comment. -- To view, visit http://gerrit.cloudera.org:8080/5969 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id6e3f2c9f6ba29749a26bc1087e664637bc02528 Gerrit-PatchSet: 1 Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-Owner: Taras Bobrovytsky Gerrit-Reviewer: Alex Behm Gerrit-Reviewer: Jim Apple Gerrit-Reviewer: Matthew Jacobs Gerrit-HasComments: Yes