Hi Charles,
Java version openjdk version "11.0.15" 2022-04-19 LTS OpenJDK Runtime Environment Microsoft-32930 (build 11.0.15+10-LTS) OpenJDK 64-Bit Server VM Microsoft-32930 (build 11.0.15+10-LTS, mixed mode) Apache Drill 1.20.1 When running the below Query, I am getting the below error I will send the error logs directly to your gmail: select BSEG.ANDT ,BSEG.UKRS ,BSEG.ELNR ,BSEG.JAHR ,BSEG.UZEI ,BSEG.UZID ,BSEG.UGDT ,BSEG.UGCP ,BSEG.UGBL ,BSEG.SCHL ,BSEG.OART ,BSEG.UMSKZ ,BSEG.UMSKS ,BSEG.ZUMSK ,BSEG.SHKZG ,BSEG.GSBER ,BSEG.PARGB ,BSEG.MWSKZ ,BSEG.QSSKZ ,BSEG.DMBTR ,BSEG.WRBTR ,BSEG.PSWBT ,BSEG.PSWSL ,BSEG.MWSTS ,BSEG.WMWST ,BSEG.HWBAS ,BSEG.FWBAS ,BSEG.QSSHB ,BSEG.VALUT ,BSEG.ZUONR ,BSEG.VBUND ,BSEG.ALTKT ,BSEG.VORGN ,BSEG.KOKRS ,BSEG.KOSTL ,BSEG.AUFNR ,BSEG.VBELN ,BSEG.VBEL2 ,BSEG.POSN2 ,BSEG.ANLN1 ,BSEG.ANLN2 ,BSEG.ANBWA ,BSEG.BZDAT ,BSEG.PERNR ,BSEG.SAKNR ,BSEG.HKONT ,BSEG.KUNNR ,BSEG.LIFNR ,BSEG.XBILK ,BSEG.GVTYP ,BSEG.ZFBDT ,BSEG.ZTERM ,BSEG.ZBD1T ,BSEG.ZBD2T ,BSEG.ZBD3T ,BSEG.ZBD1P ,BSEG.ZBD2P ,BSEG.SKFBT ,BSEG.SKNTO ,BSEG.WSKTO ,BSEG.ZLSCH ,BSEG.MATNR ,BSEG.WERKS ,BSEG.MENGE ,BSEG.MEINS ,BSEG.ERFMG ,BSEG.ERFME ,BSEG.BPMNG ,BSEG.BPRME ,BSEG.EBELN ,BSEG.EBELP ,BSEG.PRCTR ,BSEG.XHKOM ,BSEG.VNAME ,BSEG.RECID ,BSEG.EGRUP ,BSEG.FIPOS ,BSEG.KSTRG ,BSEG.NPLNR ,BSEG.PROJK ,BSEG.BTYPE ,BSEG.ETYPE ,BSEG.DMBE2 ,BSEG.DMBE3 ,BSEG.PPRCT ,BSEG.KONTL ,BSEG.AGZEI ,BSEG.LSTAR ,BSEG.AUGGJ ,BSEG.SEGMENT ,BSEG.KSTAR from xxxxxxx.`QuerySurge-Test/BSEG/QS1-BSEG-TestQS.parquet`BSEG left join xxxxxxx.`BKPF.csv` b on TRIM(BSEG.MANDT) = TRIM(b.MANDT) and TRIM(BSEG.GJAHR) = TRIM(b.GJAHR) and TRIM(BSEG.BUKRS) = TRIM(b.BUKRS) and TRIM(BSEG.BELNR) = TRIM(b.BELNR) Regards, Muhluri From: desm...@ntokoto.co.za <desm...@ntokoto.co.za> Sent: Tuesday, 10 October 2023 16:16 To: Charles Givre <cgi...@gmail.com>; user@drill.apache.org; muhl...@ntokoto.co.za Subject: Re:ChannelClosedException Good day Muhluri, Please provide the request further details below. Kind regards, Desmond Mathebula Chief Executive Officer Mobile: +2782 725 0766 Work: +2711 695 4800 / +2711 318 0288 Email: <mailto:desm...@ntokoto.co.za> desm...@ntokoto.co.za Website: <http://www.ntokoto.co.za/> www.ntokoto.co.za -------- Original message -------- From: Charles Givre <cgi...@gmail.com <mailto:cgi...@gmail.com> > Date: Tue, 10 Oct 2023, 3:59 pm To: user@drill.apache.org <mailto:user@drill.apache.org> Cc: Desmond Mathebula <desm...@ntokoto.co.za <mailto:desm...@ntokoto.co.za> > Subject: Re: ChannelClosedException Hi Desmond, Can you share a bit more? What version of Drill are you running? Java? etc. What data are you trying to query? Best, -- C > On Oct 10, 2023, at 2:02 AM, <muhl...@ntokoto.co.za > <mailto:muhl...@ntokoto.co.za> > <muhl...@ntokoto.co.za > <mailto:muhl...@ntokoto.co.za> > wrote: > > Hi Team, > > > > When I run a Query for a limited number of records it returns the results. > When I remove the limit on the Query it fails with below error. May you > please assist. > > > > > > Exception: SQL_EXCEPTION java.sql.SQLException: CONNECTION ERROR: Connection > <--> (user client) closed unexpectedly. Drillbit down? [Error Id: > fba8461f-c896-4c56-b617-1625361e577d ] > > > > Regards, > > Muhluri > > >
