drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bridget Bevens (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4721) Doc "dateDiff" in Drill
Date Tue, 14 Jun 2016 00:21:23 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328693#comment-15328693
] 

Bridget Bevens commented on DRILL-4721:
---------------------------------------

Cool. I believe so, let me check.

On the datediff, it seems like we have it but never documented? I see at least one JIRA around
this.
https://issues.apache.org/jira/browse/DRILL-4116

On Mon, Jun 13, 2016 at 1:24 PM, Zelaine Fong <zfong@maprtech.com> wrote:
Alicia Alvarez recently contributed DRILL-4607.  Is that what you're looking for, as far as
#2?

-- Zelaine

On Mon, Jun 13, 2016 at 1:15 PM, Neeraja Rentachintala <nrentachintala@maprtech.com>
wrote:
A customer of ours is interested in using the following functions in Hive with Drill.

I was wondering if they can use these functions as Hive UDFs within Drill. Any thoughts on
if this is possible. Did anyone try to do this.
Additionally would do we have Drill equivalents for these (I am certain that we don't have
equivalents for the split ones).

-Neeraja


int
datediff(string enddate, string startdate)
Returns the number of days from startdate to enddate: datediff('2009-03-01', '2009-02-27')
= 2.
array
split(string str, string pat)
Splits str around pat (pat is a regular expression).
map<string,string>
str_to_map(text[, delimiter1, delimiter2])
Splits text into key-value pairs using two delimiters. Delimiter1 separates text into K-V
pairs, and Delimiter2 splits each K-V pair. Default delimiters are ',' for delimiter1 and
'=' for delimiter2.


> Doc "dateDiff" in Drill
> -----------------------
>
>                 Key: DRILL-4721
>                 URL: https://issues.apache.org/jira/browse/DRILL-4721
>             Project: Apache Drill
>          Issue Type: Task
>          Components: Documentation
>            Reporter: Bridget Bevens
>            Assignee: Bridget Bevens
>            Priority: Minor
>
> Fwd: [mapr-tech-qa:12242]Doc "dateDiff" in Drill
> Inbox
> x 
> Neeraja Rentachintala
> 3:32 PM (19 minutes ago)
> to me 
> we should document the datediff function. Cisco was asking about it today.
> ---------- Forwarded message ----------
> From: Bob Rumsby <brumsby@maprtech.com>
> Date: Thu, Aug 20, 2015 at 11:56 AM
> Subject: Re: [mapr-tech-qa:12242] "dateDiff" in Drill
> To: "mapr-tech-qa@maprtech.com" <mapr-tech-qa@maprtech.com>
> Yes, it should be. We can fix that.
> Bob
> On Thu, Aug 20, 2015 at 11:46 AM, Joseph Blue <jblue@maprtech.com> wrote:
> Seems as though functions like datediff should be here:
> https://drill.apache.org/docs/date-time-functions-and-arithmetic/
> On Thu, Aug 20, 2015 at 11:32 AM, Ted Dunning <tdunning@maprtech.com> wrote:
> Joe
> Do you have a suggestion for the docs?  Perhaps a few cross links would make it better?
> Sent from my iPhone
> On Aug 20, 2015, at 5:36, Joseph Blue <jblue@maprtech.com> wrote:
> OK, duh. Thanks for that. I just went down the wrong path in the documentation. 
> This obviously does exactly what I want.
> On Wed, Aug 19, 2015 at 10:26 PM, Mehant Baid <mbaid@maprtech.com> wrote:
> You can use the datediff function as follows:
>  select datediff(date '2008-2-23', date '2008-1-20') from cp.`employee.json` limit 1;
> +---------+
> | EXPR$0  |
> +---------+
> | 34      |
> +---------+
> Thanks
> Mehant
> On Wed, Aug 19, 2015 at 7:00 PM, Joseph Blue <jblue@maprtech.com> wrote:
> Want to get the difference between two dates in Drill. I used the AGE function which
produces an interval. But I want the answer in days, not months & days. Am I missing something
from the documentation?
> select age(cast('2015-01-01' as timestamp),cast('2014-11-30' as timestamp)) from sys.version;
> +---------+
> | EXPR$0  |
> +---------+
> | P1M2D   |
> +---------+
> -- 
> Joseph Blue
> Data Scientist



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

Mime
View raw message