drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject Re: TIMESTAMPADD sql jdbc function execution in drill
Date Mon, 08 Feb 2016 15:43:54 GMT
Please vote for this enhancement to raise visibility in the community.

--Andries

> On Feb 8, 2016, at 12:47 AM, Sudip Mukherjee <smukherjee@commvault.com> wrote:
> 
> Thanks a lot for the information.
> 
> Regards,
> Sudip
> 
> From: Arina Yelchiyeva [mailto:arina.yelchiyeva@gmail.com <mailto:arina.yelchiyeva@gmail.com>]
> Sent: 08 February 2016 PM 01:13
> To: dev@drill.apache.org <mailto:dev@drill.apache.org>; Sudip Mukherjee
> Subject: Re: TIMESTAMPADD sql jdbc function execution in drill
> 
> Hi Sudip,
> 
> timestampadd / timestampdiff functions are not currently implemented in Drill but they
are in development.
> See Jira https://issues.apache.org/jira/browse/DRILL-3610
> 
> 
> Kind regards
> Arina
> On Mon, Feb 8, 2016 at 9:29 AM Sudip Mukherjee <smukherjee@commvault.com <mailto:smukherjee@commvault.com><mailto:smukherjee@commvault.com
<mailto:smukherjee@commvault.com>>> wrote:
> Thanks Khurram.
> 
> I am not sure if I am looking at the correct place. Seeing it in calcite,
> https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/SqlJdbcFunctionCall.java
<https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/SqlJdbcFunctionCall.java>
> 
> I'll try to check further on the date-time functions.
> 
> Thanks,
> Sudip
> 
> -----Original Message-----
> From: Khurram Faraaz [mailto:kfaraaz@maprtech.com <mailto:kfaraaz@maprtech.com><mailto:kfaraaz@maprtech.com
<mailto:kfaraaz@maprtech.com>>]
> Sent: 08 February 2016 PM 12:14
> To: dev@drill.apache.org <mailto:dev@drill.apache.org><mailto:dev@drill.apache.org
<mailto:dev@drill.apache.org>>
> Subject: Re: TIMESTAMPADD sql jdbc function execution in drill
> 
> I didn't find it on the documented date time functions here https://drill.apache.org/docs/date-time-functions-and-arithmetic/
<https://drill.apache.org/docs/date-time-functions-and-arithmetic/>
> 
> On Mon, Feb 8, 2016 at 12:09 PM, Sudip Mukherjee <smukherjee@commvault.com <mailto:smukherjee@commvault.com><mailto:smukherjee@commvault.com
<mailto:smukherjee@commvault.com>>>
> wrote:
> 
>> Hi,
>> Are  TIMESTAMPADD / TIMESTAMPDIFF functions supported through drill? I
>> am getting an error while running the below query
>> 
>> SELECT CAST(EXTRACT(YEAR FROM CAST({fn
>> TIMESTAMPADD(SQL_TSI_YEAR,CAST(`myshare`.`mtm` AS INTEGER),{d
>> '1970-01-01'})} AS DATE)) AS INTEGER) AS
>> `yr_Calculation_IGIAGIIHHFEBCCIFEE_ok`
>> FROM `dfs.data`.`MyFileShare_2214` `myshare` GROUP BY
>> CAST(EXTRACT(YEAR FROM CAST({fn
>> TIMESTAMPADD(SQL_TSI_YEAR,CAST(`myshare`.`mtm` AS INTEGER),{d
>> '1970-01-01'})} AS DATE)) AS INTEGER)
>> 
>> 
>> VALIDATION ERROR: From line 3, column 55 to line 3, column 66: Column
>> 'SQL_TSI_YEAR' not found in any table
>> 
>> Thanks,
>> Sudip
>> 
>> 
>> 
>> ***************************Legal Disclaimer***************************
>> "This communication may contain confidential and privileged material
>> for the sole use of the intended recipient. Any unauthorized review,
>> use or distribution by others is strictly prohibited. If you have
>> received the message by mistake, please advise the sender by reply
>> email and delete the message. Thank you."
>> **********************************************************************
> 
> 
> 
> ***************************Legal Disclaimer***************************
> "This communication may contain confidential and privileged material for the
> sole use of the intended recipient. Any unauthorized review, use or distribution
> by others is strictly prohibited. If you have received the message by mistake,
> please advise the sender by reply email and delete the message. Thank you."
> **********************************************************************
> 
> 
> 
> ***************************Legal Disclaimer***************************
> "This communication may contain confidential and privileged material for the
> sole use of the intended recipient. Any unauthorized review, use or distribution
> by others is strictly prohibited. If you have received the message by mistake,
> please advise the sender by reply email and delete the message. Thank you."
> **********************************************************************


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message