drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Raj <rahul....@option3consulting.com>
Subject Slow query on parquet imported from SQL Server while the external SQL server is down.
Date Fri, 25 Nov 2016 11:21:29 GMT
I have created a parquet file using CTAS from a MS SQL Server. The query on
parquet is getting stuck in STARTING state for a long time before returning
the results.

We could see that drill was trying to connect to the MS SQL server from
which the data was imported. The MSSQL server was down, drill threw an
exception "Failure while attempting to load JDBC schema", and then returned
the results. While SQL server is running, the query executes without
issues.

Why is drill querying the DB metadata externally and not the imported
parquets?

Rahul.

-- 
**** This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom it is 
addressed. If you are not the named addressee then you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately and delete this e-mail from your system.****

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message