You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by sa...@yahoo.com.INVALID on 2016/09/08 08:15:46 UTC

Sql Query Null Error

I am using Drill in Embedded Mode in Window 10 having latest version 1.8. I have started my drill and fire query for SQL Server through Commad Prompt.
QUERY:-  select * from <storageplugin name>.`<database name>`.`<schema nama>`.`<table name>` AS `<alias name>`;
e.g:- SELECT *  FROM demoPlugin.`SanjivDatabase`.`core`.`customer` AS T1 ;

If i run this query through command prompt it will work fine. But if i am not using my drill  for sometime (say 1 hour), and after that if i again fire same query through command prompt then  it show :-
Error: VALIDATION ERROR: From line 1, column 311 to line 1, column 376: Table 'demoPlugin.SanjivDatabase.core.customer' not found.
SQL Query null.
But again if i fire same query for 2nd time after this error, then the same query is  working fine. 
What is the problem.? Whether i have to change something in configuration  or any other problem?