Re: MSSQL query with Limit

2022-02-10 Thread James Turton
://issues.apache.org/jira/browse/DRILL-8128 may have the same root cause which also was fixed in Drill 1.20. Regards, Maksym Від: Charles Givre Надіслано: 10 лютого 2022 р. 0:17 Кому: user@drill.apache.org Тема: Re: MSSQL query with Limit Hi Naser Thanks for your question. I

Re: MSSQL query with Limit

2022-02-10 Thread Rumar, Maksym
Від: Charles Givre Надіслано: 10 лютого 2022 р. 0:17 Кому: user@drill.apache.org Тема: Re: MSSQL query with Limit 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,

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