Can you create a table in this workspace?
On Sun, Feb 7, 2016 at 2:19 AM, Paolo Spanevello <[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 = '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 <[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]> > > 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 > > > > >
