Paolo, Are you using Drill in Embedded mode? I believe in embedded mode the 'tmp' data is not persistent when shutting Drill down, you probably should use a different workspace (also good practice for distributed mode not to use tmp workspace for persistent objects).
When you say write the Drill do you mean creating a table or a view with Drill? --Andries > On Jan 23, 2016, at 10:47 AM, Paolo Spanevello <[email protected]> wrote: > > Dear All, > > i'm using drill explorer to write the drill. I save them , when I click on > create as. When I close drill explorer and i opened it again it happen two > things: > > 1. the output of query is come from the query that I saved > 2. The text of the SQL query is changed and it is: SELECT * FROM > `dfs`.`tmp`.`provaRider9` > > where provaRider9 is the name of the drill saved. > > Thansk again for your support. > > best, > Paolo
