drill

drill copied to clipboard

apache drill failed to execute SQL such as ' table1 left join table2 on condition 1 or condition 2'

2

Execute the following sql (although it may not make sense): SELECT aa.employee_id FROM cp.`employee.json` aa left join cp.`employee.json` bb on aa.employee_id=bb.employee_id or aa.employee_id=bb.position_id ;  I got the results： ...

fengqiyuqingpingzhimo

I am not quite sure if I understood the permission management of drill correctly. It seems that we need to set users with different permissions in the data source and...

LYCJeff

fail to execute multi-table left join queries in MySQL when using Drill 1.20.2

1

Hello everyone, I encountered some problems when I was using Drill 1.20.2 to connect MySQL database. When I execute the following SQL statement, an error occurred: SQL statement as follows:...

SeaSoonKeun

[DISCUSSION] Use INT96 as default timestamp format in Parquet tables

6

Hi everyone, i want to raise a discussion about the current behavior in drill regarding parquet timestamps. Drill uses `INT64` for timestamps and you can switch to `INT96` by setting...

Z0ltrix

select * from hive ；report refcnt = 0 error

5

create table in hive schame by drill as follows: create table hive.t (a string ,b string, c string) insert value lengths should longer than 256 words eg: insert into hive.t...

yaozhu

Any chance of INFORMATION SCHEMA updates like storing it in any database instead of in-memory data

5

**Is your feature request related to a problem? Please describe.** A clear and concise description of what the problem is. Ex. I'm always frustrated when [...] **Describe the solution you'd...

porika-v

Failed to execute an insert statement across the database

8

Failed to execute an insert statement across the database. Steps to reproduce the behavior: 1. Prepare the mysql and postgresql table structures and data. mysql： create table t1(c1 int, c2...

weijunlu

Order by expression failed to execute in mysql plugin

6

Order by expression failed to execute in mysql plugin Steps to reproduce the behavior: 1. The version information is as follows: ``` apache drill> select commit_message, commit_time from sys.version; +----------------------------------------------------------------------------------+---------------------------+...

weijunlu

The coalesce function failed in the master version Steps to reproduce the behavior: 1. The version information is as follows: apache drill> select commit_message, commit_time from sys.version; +----------------------------------------------------------------------------------+---------------------------+ | commit_message...

weijunlu

Boolean expression failed to execute in mysql plugin 1. The version information is as follows: ``` apache drill> select commit_message, commit_time from sys.version; +----------------------------------------------------------------------------------+---------------------------+ | commit_message | commit_time | +----------------------------------------------------------------------------------+---------------------------+...

weijunlu