drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paolo Spanevello <paolosp...@gmail.com>
Subject Re: Drill Explorer: missing the SQL statement
Date Sun, 07 Feb 2016 10:19:02 GMT
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