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?
