Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0B4C710B1C for ; Mon, 1 Dec 2014 18:45:59 +0000 (UTC) Received: (qmail 59083 invoked by uid 500); 1 Dec 2014 18:45:58 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 59018 invoked by uid 500); 1 Dec 2014 18:45:58 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 59007 invoked by uid 500); 1 Dec 2014 18:45:58 -0000 Delivered-To: apmail-incubator-drill-dev@incubator.apache.org Received: (qmail 59001 invoked by uid 99); 1 Dec 2014 18:45:58 -0000 Received: from reviews-vm.apache.org (HELO reviews.apache.org) (140.211.11.40) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Dec 2014 18:45:58 +0000 Received: from reviews.apache.org (localhost [127.0.0.1]) by reviews.apache.org (Postfix) with ESMTP id A29D81FB85C; Mon, 1 Dec 2014 18:45:56 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============3546579138830391114==" MIME-Version: 1.0 Subject: Re: Review Request 28496: DRILL-1779: Add unix_timestamp function From: "Venkata krishnan Sowrirajan" To: "Mehant Baid" Cc: "drill" , "Venkata krishnan Sowrirajan" , "Kannan Rajah" Date: Mon, 01 Dec 2014 18:45:56 -0000 Message-ID: <20141201184556.29131.68935@reviews.apache.org> X-ReviewBoard-URL: https://reviews.apache.org Auto-Submitted: auto-generated Sender: "Venkata krishnan Sowrirajan" X-ReviewGroup: drill-git X-ReviewRequest-URL: https://reviews.apache.org/r/28496/ X-Sender: "Venkata krishnan Sowrirajan" References: <20141129025859.15977.1948@reviews.apache.org> In-Reply-To: <20141129025859.15977.1948@reviews.apache.org> Reply-To: "Venkata krishnan Sowrirajan" X-ReviewRequest-Repository: drill-git --===============3546579138830391114== MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit > On Nov. 29, 2014, 2:58 a.m., Kannan Rajah wrote: > > exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/DateTypeFunctions.java, line 484 > > > > > > Why we do need to create formatter when it is not used? Please take a look at this commit for the fix that I had made. It is returning milliseconds by mistake, so ignore that part. Yeah, you are right. This is not required here. Copy/paste mistake. > On Nov. 29, 2014, 2:58 a.m., Kannan Rajah wrote: > > exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/DateTypeFunctions.java, line 508 > > > > > > Curious to know how we will hit this case since we have an overloaded function that does not take any args. Yeah, this is also not required, I think. As we will not hit this condition for the reason you mentioned above. > On Nov. 29, 2014, 2:58 a.m., Kannan Rajah wrote: > > exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/DateTypeFunctions.java, line 489 > > > > > > Can we not just use the queryStartDate instead of creating a new date instance? If I am not wrong, is this the fragment's queryStartTime("incoming.getContext().getQueryStartTime()")? Like this instead of creating an instance of Date. - Venkata krishnan ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/28496/#review63276 ----------------------------------------------------------- On Nov. 27, 2014, 8:16 a.m., Venkata krishnan Sowrirajan wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/28496/ > ----------------------------------------------------------- > > (Updated Nov. 27, 2014, 8:16 a.m.) > > > Review request for drill and Mehant Baid. > > > Repository: drill-git > > > Description > ------- > > Added functionality for unix_timestamp() similar to MySQL > > > Diffs > ----- > > exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/DateTypeFunctions.java f063466 > exec/java-exec/src/test/java/org/apache/drill/exec/fn/impl/TestDateFunctions.java 1ecae19 > exec/java-exec/src/test/resources/functions/date/to_unixtimestamp_for_date.json PRE-CREATION > exec/java-exec/src/test/resources/functions/date/to_unixtimestamp_for_date_with_pattern.json PRE-CREATION > > Diff: https://reviews.apache.org/r/28496/diff/ > > > Testing > ------- > > Added testcases > > > Thanks, > > Venkata krishnan Sowrirajan > > --===============3546579138830391114==--