HI Anupam, I think you’re getting this error because you don’t have the SQLAlchemy-Drill driver installed: https://pypi.org/project/sqlalchemy-drill/
Superset will not work with Drill unless this is installed. Best, — C > On Feb 2, 2026, at 01:51, Anupam Gupta <[email protected]> wrote: > > Hi Charles, > I hope you’re doing well. I wanted to follow up again on my previous messages > regarding the Superset and Apache Drill integration issue. > As mentioned earlier, I have successfully added Superset to the Docker > Compose file, and the Superset UI is functioning as expected. However, I am > still encountering the following error when attempting to connect Superset to > Apache Drill: > ERROR: Could not load database driver: DrillEngineSpec > At this point, I wanted to check if there are any additional configurations, > drivers, or dependencies required on the Superset side to enable the Drill > database connection. Any guidance or documentation you could point me to > would be greatly appreciated. > Thank you for your time, and I look forward to your response. > Best regards, > > ________________________________ > From: Anupam Gupta <[email protected]> > Sent: Monday, January 19, 2026 11:17 AM > To: [email protected] <[email protected]> > Subject: Re: Issue with Distributed Query Execution and OutOfMemoryError in > Apache Drill > > CAUTION: External Sender. Please do not click on links or open attachments > from senders you do not trust. > > > Hi Charles, > Following up on my previous email regarding the Superset and Apache Drill > integration. > I have added Superset to the Docker Compose file and the Superset UI is > working as expected. However, when I try to connect Superset to Drill, I am > still encountering the following error: > ERROR: Could not load database driver: DrillEngineSpec > Please let me know if there are any additional configurations, drivers, or > dependencies that need to be added to resolve this issue. > Any guidance on this would be greatly appreciated. > Best regards, > > ________________________________ > From: Anupam Gupta <[email protected]> > Sent: Monday, January 12, 2026 2:54 PM > To: [email protected] <[email protected]> > Subject: Re: Issue with Distributed Query Execution and OutOfMemoryError in > Apache Drill > > CAUTION: External Sender. Please do not click on links or open attachments > from senders you do not trust. > > > Hi charles, > > i am facing one more issue while connecting superset ui with drill i have > added superset to compose file and the ui is also working but when i am > connecting it to drill i am getting > ERROR: Could not load database driver: DrillEngineSpec It would be a great > help if you could assist me with this too > ________________________________ > From: Anupam Gupta <[email protected]> > Sent: Monday, January 12, 2026 11:20 AM > To: [email protected] <[email protected]> > Subject: Re: Issue with Distributed Query Execution and OutOfMemoryError in > Apache Drill > > CAUTION: External Sender. Please do not click on links or open attachments > from senders you do not trust. > > > Hi Charles, > Thanks for the suggestions — that definitely helps. > To answer your questions: > > * > I’ve increased the Java heap, with the initial heap set to 8 GB and the max > heap set to 32 GB. > * > The Drill cluster currently consists of 3 Drill nodes. > * > The data is stored in Parquet format. > > Despite these settings, I’m still running into the immediate query issues, > which is why I wanted to confirm whether there are additional tuning > recommendations you’d suggest around fragments or parallelization. Based on > your feedback, I’ll also look into further breaking up the Parquet files to > improve parallel execution, depending on the use case. > Regarding the UI, that makes sense. I’ll avoid using the Drill UI for large > result sets and instead plan to connect Drill to a proper UI like Apache > Superset or pull results via JDBC when working with queries returning 1M+ > records. > Thanks again for the guidance — really appreciate it. > Best regards, > Anupam > > ________________________________ > From: Charles Givre <[email protected]> > Sent: Friday, January 9, 2026 2:06 AM > To: [email protected] <[email protected]> > Subject: Re: Issue with Distributed Query Execution and OutOfMemoryError in > Apache Drill > > CAUTION: External Sender. Please do not click on links or open attachments > from senders you do not trust. >
signature.asc
Description: Message signed with OpenPGP
