Re: Error while applying interval on a postgresql query

2017-03-20 Thread Rahul Raj
This happens on a JDBC Storage plugin to Postgres. It errors out on cast/DATE_ADD function call. Regards, Rahul On Tue, Mar 21, 2017 at 2:33 AM, Boaz Ben-Zvi wrote: > What do you mean by ‘postrgresql table’ ? > > I just retried the query below (on a json table) and it

Re: Inequality join error with date range and calendar table

2017-03-20 Thread Boaz Ben-Zvi
The hash join does not support inequality yet. Try nested loop join by setting: alter system set `planner.enable_nljoin_for_scalar_only` = false; And change the LEFT to a regular join followed by an inequality predicate: ``` SELECT m.startdate as monthdate, COUNT(distinct

Inequality join error with date range and calendar table

2017-03-20 Thread Matt
Using a calendar table with monthly start and end dates, I am attempting to count records in another table that has cycle start and end dates. In PostgreSQL I would either use a date range type, or in standard SQL do something like: ``` SELECT m.startdate as monthdate, COUNT(distinct

Re: Error while applying interval on a postgresql query

2017-03-20 Thread Boaz Ben-Zvi
What do you mean by ‘postrgresql table’ ? I just retried the query below (on a json table) and it worked OK: 0: jdbc:drill:zk=local> select * from test2 limit 2; +-+-+ | id | start_date | +-+-+ | 1 | 1997-10-27 | | 2 | 1997-10-27 |

Error while applying interval on a postgresql query

2017-03-20 Thread Rahul Raj
Hi, Drill 1.9 gives error while applying interval function on a postgresql table. The below two queries error out. Not sure about the other databases. select `id` from (select * from config_1.public.project_release) where CAST(DATE_ADD(`start_date`,interval '19800' second(5)) AS DATE) = DATE

Re: Drill memory configuration in windows

2017-03-20 Thread Bob Rudis
Follow this thread : http://mail-archives.apache.org/mod_mbox/drill-user/201703.mbox/%3CCAJgUOA7OyXFeX4WCTZv6fAzvOxQt_kjTJBbxk8_QEGDW_3nZbA%40mail.gmail.com%3E Searching mailing list archives is generally step #2 before posting (step #1 is generally google, but it doesn't catch the list archives

Drill memory configuration in windows

2017-03-20 Thread jasbir.sing
Hi, I want to run Drill on my local machine (Windows) and want to assign 1GB heap memory and direct memory. Can someone help me how to do it? Regards, Jasbir Singh This message is for the designated recipient only and may contain privileged, proprietary, or