drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <abhishek.gir...@gmail.com>
Subject Re: Slow query on parquet imported from SQL Server while the external SQL server is down.
Date Wed, 30 Nov 2016 06:12:31 GMT
Can you attempt to disable to jdbc plugin (configured with SQLServer) and
try the query (on parquet) when SQL Server is offline?

I've seen a similar issue previously when the HBase / Hive plugin was
enabled but either the plugin configuration was wrong or the underlying
data source was down.

On Fri, Nov 25, 2016 at 3:21 AM, Rahul Raj <rahul.raj@option3consulting.com>
wrote:

> 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