Re: MSSQL query with Limit

2022-02-09 Thread Charles Givre
Hi Naser Thanks for your question. I believe this was fixed in the latest version of Drill (1.20) which will be released any day now. Sent from my iPhone > On Feb 9, 2022, at 17:07, Naser Khodabin > wrote: > > Hi! > > I'm wondering if there is a way to query MSSQL in apache drill (versi

MSSQL query with Limit

2022-02-09 Thread Naser Khodabin
Hi! I'm wondering if there is a way to query MSSQL in apache drill (version 1.19) to get a given number of rows. For instance I tried this select-statement: SELECT * FROM bp.BPASession order by startdatetime desc limit 2 Which cause the following error: org.apache.drill.common.exceptions.User

Re: [VOTE] Release Apache Drill 1.20.0 - RC1

2022-02-09 Thread Jingchuan Hu
+1 for the release Did following test manually: 1. Started Drill in distributed mode. 2. Checked basically functions in Web UI 3. Did sample query by Web UI and sqlline respectively. 4. Checked log files. 5. Stopped Drill gracefully. On Tue, Feb 8, 2022 at 10:54 PM James Turton wrote: > H

Re: [VOTE] Release Apache Drill 1.20.0 - RC1

2022-02-09 Thread James Turton
The storage-phoenix plugin put up an unexpected final fight when it was asked to build under the -Phadoop-2 profile but I think that all is now okay with the Hadoop 2 build. Tar balls https://dist.apache.org/repos/dist/dev/drill/drill-1.20.0-hadoop-2-rc1/ Git tag https://github.com/jnturton/d