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: [email protected] <[email protected]> Sent: Tuesday, 10 October 2023 16:16 To: Charles Givre <[email protected]>; [email protected]; [email protected] 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:[email protected]> [email protected] Website: <http://www.ntokoto.co.za/> www.ntokoto.co.za -------- Original message -------- From: Charles Givre <[email protected] <mailto:[email protected]> > Date: Tue, 10 Oct 2023, 3:59 pm To: [email protected] <mailto:[email protected]> Cc: Desmond Mathebula <[email protected] <mailto:[email protected]> > 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, <[email protected] > <mailto:[email protected]> > <[email protected] > <mailto:[email protected]> > 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 > > >
