drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Drill Explorer: missing the SQL statement
Date Sun, 07 Feb 2016 17:02:10 GMT
Can you create a table in this workspace?



On Sun, Feb 7, 2016 at 2:19 AM, Paolo Spanevello <paolospane@gmail.com>
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 <aengelbrecht@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 <paolospane@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
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message