RE: TIMESTAMPADD sql jdbc function execution in drill

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 I'll try to check further on the date-time functions. Thanks, Sudip -Original

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 wrote: > Thanks Khurram.

Re: [VOTE] Release Apache Drill 1.5.0 RC2

+1 - Downloaded src and built, ran unit tests on my Mac - Manually ran a few queries against TPC-DS - Verified partition pruning, metadata caching was working as expected for these test queries - Checked query profile in Web UI, checked query cancellation - Found 1 performance issue with lots of

[jira] [Created] (DRILL-4365) Performance with lots of small parquet files

Aman Sinha created DRILL-4365: - Summary: Performance with lots of small parquet files Key: DRILL-4365 URL: https://issues.apache.org/jira/browse/DRILL-4365 Project: Apache Drill Issue Type: Bug

[jira] [Created] (DRILL-4366) case expression referencing columns[..] = literal fails to resolve to tru

N Campbell created DRILL-4366: - Summary: case expression referencing columns[..] = literal fails to resolve to tru Key: DRILL-4366 URL: https://issues.apache.org/jira/browse/DRILL-4366 Project: Apache

[GitHub] drill pull request: DRILL-4132 Ability to submit simple type of ph...

GitHub user yufeldman opened a pull request: https://github.com/apache/drill/pull/368 DRILL-4132 Ability to submit simple type of physical plan directly to… … EndPoint DrillBit for execution. There are multiple changes to achieve this: 1. During physical planning

TIMESTAMPADD sql jdbc function execution in drill

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

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/ On Mon, Feb 8, 2016 at 12:09 PM, Sudip Mukherjee wrote: > Hi, > Are TIMESTAMPADD / TIMESTAMPDIFF functions supported through drill? I am >