Hi Muhiuri, What data are you trying to query exactly? Also, is there some reason you aren't using the latest version of Drill? The last line in your logs say somehting about a timeout. My hunch is that the connection to the data source is simply timing out. -- C
> On Oct 12, 2023, at 9:03 AM, <[email protected]> <[email protected]> > wrote: > > Hi, > I am running from the drill console, The application I want to use it on is > QuerySurge. I am getting the same error message in both platforms. > > Regards, > Muhluri > > -----Original Message----- > From: James Turton <[email protected]> > Sent: Thursday, 12 October 2023 13:43 > To: [email protected] > Subject: Re: ChannelClosedException > > Also, please look in the Drillbit logs. The query may be encountering invalid > data and failing when you remove your LIMIT clause. Are you using DBeaver to > submit your queries btw? That error looks familiar... > > On 2023/10/10 15:58, Charles Givre wrote: >> 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]> >>> <[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 >>> >>> >>> > >
