Ended up being a file system permission issue. (email thread went private).
--Andries > On Feb 8, 2016, at 8:14 AM, Andries Engelbrecht <[email protected]> > wrote: > > Make sure when you configured the file system plug in and workspace that you > set the workspace as mutable. > > By setting this flag to true > > "writable": true, > > > Also make sure that the OS user that Drill runs as has write permissions on > the file system which the workspace is set to. > If you use Drill security check the permissions for the users you are using > on the file system. > > > --Andries > > > > > >> On Feb 7, 2016, at 2:19 AM, Paolo Spanevello <[email protected] >> <mailto:[email protected]>> wrote: >> >> Hi Andries, >> >> I set, as you told me, a new workspace but I can not save the view in the >> new one. I have this error: >> >> [07/02/2016 11:15:05] Executing Query: CREATE VIEW >> `Performance_Ride_Analytics.GC`.`prova2` AS select >> concat(tt.Athlete,'_',tt.ride_date) as Athlete_Ride_Date, tt.Athlete, >> tt.ride_date, >> CAST(tt.flat_intervals.metrics.`1s_critical_power` as FLOAT) as >> `1s_critical_power` >> >> from >> (select RTRIM(t.flat_rides.tags.Athlete,' ') as Athlete,t.flat_rides.`date` >> as ride_date,flatten(t.flat_rides.INTERVALS) as flat_intervals from >> (select flatten(rides) as flat_rides from >> `Performance_Ride_Analytics`.`GC`.`./prova2/cache/rideDB.json`) as t) as tt >> where tt.flat_intervals.name <http://tt.flat_intervals.name/> = 'Attivita'' >> intera ' >> [07/02/2016 11:15:05] ERROR [HY000] [MapR][Drill] (1040) Drill failed to >> execute the query: CREATE VIEW `Performance_Ride_Analytics.GC`.`prova2` AS >> select >> concat(tt.Athlete,'_',tt.ride_date) as Athlete_Ride_Date, tt.Athlete, >> tt.ride_date, >> CAST(tt.flat_intervals.metrics.`1s_critical_power` as FLOAT) as >> `1s_critical_power` >> >> from >> (select RTRIM(t.flat_rides.tags.Athlete,' ') as Athlete,t.flat_rides.`date` >> as ride_date,flatten(t.flat_rides.INTERVALS) as flat_intervals from >> (select flatten(rides) as flat_rides from >> `Performance_Ride_Analytics`.`GC`.`./prova2/cache/rideDB.json`) as t) as tt >> where tt.flat_intervals.name <http://tt.flat_intervals.name/> = 'Attivita'' >> intera ' >> [30027]Query execution error. Details:[ >> SYSTEM ERROR: PatternSyntaxException: Unexpected internal error near index 1 >> \ >> ^ >> >> >> [Error Id: cff767ba-c900-4912-b510-ed7edb01aa9b on 192.168.1.108:31010 >> <http://192.168.1.108:31010/>] >> ] >> >> >> Is if I save it in the /tmp workspace it works. >> >> ] >> [07/02/2016 11:15:55] Executing Query: CREATE VIEW >> `Performance_Ride_Analytics.tmp`.`prova2` AS select >> concat(tt.Athlete,'_',tt.ride_date) as Athlete_Ride_Date, tt.Athlete, >> tt.ride_date, >> CAST(tt.flat_intervals.metrics.`1s_critical_power` as FLOAT) as >> `1s_critical_power` >> >> from >> (select RTRIM(t.flat_rides.tags.Athlete,' ') as Athlete,t.flat_rides.`date` >> as ride_date,flatten(t.flat_rides.INTERVALS) as flat_intervals from >> (select flatten(rides) as flat_rides from >> `Performance_Ride_Analytics`.`GC`.`./prova2/cache/rideDB.json`) as t) as tt >> where tt.flat_intervals.name <http://tt.flat_intervals.name/> = 'Attivita'' >> intera ' >> [07/02/2016 11:15:55] SUCCESS: View 'prova2' created successfully in >> 'Performance_Ride_Analytics.tmp' schema >> >> >> Could you please support? >> >> Best, >> Paolo >> >> 2016-01-25 17:09 GMT+01:00 Andries Engelbrecht <[email protected] >> <mailto:[email protected]>>: >> 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] >> > <mailto:[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 >> >> >
