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....@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.**** >
