It sounds like the query over the full set is crashing your Drillbit,
perhaps due to an OOM error.
On 2023/10/12 13:58, muhl...@ntokoto.co.za wrote:
Hi,
I am running directly from the drill. The main application I want to run from
is QuerySurge.
Is there any solution you can advise?
Regards,
Muhluri
-----Original Message-----
From: James Turton <dz...@apache.org>
Sent: Thursday, 12 October 2023 13:43
To: muhl...@ntokoto.co.za
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, <muhl...@ntokoto.co.za> <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
