Hi Charles May I ask, why do you think, that the issue could be fixed in Drill 1.20? I am asking because I want to know, whether the https://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 <[email protected]> Надіслано: 10 лютого 2022 р. 0:17 Кому: [email protected] <[email protected]> Тема: 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, at 17:07, Naser Khodabin > <[email protected]> wrote: > > 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.UserRemoteException: DATA_READ ERROR: The > JDBC storage plugin failed while trying setup the SQL query. Sql: SELECT * > FROM "dbo"."BPASession" ORDER BY CASE WHEN "startdatetime" IS NULL THEN 0 > ELSE 1 END, "startdatetime" DESC FETCH NEXT 2 ROWS ONLY Plugin: bp Fragment: > 0:0 > > Without Limit 2, it work correctly: > SELECT * FROM bp.BPASession order by startdatetime desc > > I appreciate any kind of help! > > > Med vänliga hälsningar > > Naser Khodabin > > GÖTEBORGS STAD > Intraservice, enheten IT-projekt och -portfölj > Mobil: 076 -2060289 > E-post: > [email protected]<mailto:[email protected]> > Postadress: 403 31 Göteborg > Besök: Rosenlundsgatan 4 > http://www.goteborg.se <http://www.goteborg.se/ > >
