Is it possible to configure a drillbit to use disk when necessary?

2015-12-04 Thread Daniel Garcia
Hi, I was trying to dump into a parquet file data contained in a very big MySQL table. After setting the store.format to parquet and the compression to snappy, I used a query like: Create table dfs.tmp.`file.parquet` as (select ... from mysq.schema.table); The problem that I found is that the

RE: LIMIT clause not being sent to MySQL server

2015-12-03 Thread Daniel Garcia
(different syntaxes for quite many databases) and as such I don’t think the push down rules works for that. Regards, Magnus > 3 dec 2015 kl. 10:00 skrev Daniel Garcia <daniel.gar...@eurotaxglass.com>: > > Hi, > > I’m trying to obtain just one row from a table sto

LIMIT clause not being sent to MySQL server

2015-12-03 Thread Daniel Garcia
Hi, I'm trying to obtain just one row from a table stored in MySQL by using the following query: select * from my.schema.table limit 1; But I'm not getting just one row but all instead. I mean: apache drill only shows one line, but it retrieves all of them from the source. Looking at the