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 = '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 = '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] ] *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 = '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 <aengelbre...@maprtech.com>: > 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 <paolosp...@gmail.com> > 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 > >
