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
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
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
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 |
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
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
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