I see a similar error in OSX Sierra when using CTTAS. Haven’t looked at Drill
on Sierra yet, or the /tmp for that matter on OSX for a while, but I noticed is
a link to /private/tmp now. Perhaps someone who has tested CTTAS on Sierra can
give some insight, don’t have time to look into it.
--Andries
On 3/31/17, 2:16 AM, "Arina Yelchiyeva" <arina.yelchiy...@gmail.com> wrote:
Hi Amir,
I am not Mac user, so I can't exactly tell you what the problem is. Maybe
other Mac users will recognize this error.
Generally it seems Drill can't create table in dfs.tmp schema. By default
dfs.tmp points to /tmp directory.
Maybe you don't have write access in this directory. Directory for dfs.tmp
can be changed on Web UI in Storage Plugin tab.
Kind regards
Arina
On Thu, Mar 30, 2017 at 11:42 PM, Amir Kafri <am...@datorama.com> wrote:
> Thank you Arina.
>
> I tried your query, and the create query statement fails with the
following
> stack (on a fresh 1.10 installation, mac), any ideas?
> Regarding my issue, I'm working on re-creating it.
>
> SYSTEM ERROR: URISyntaxException: Relative path in
> absolute URI: wifi-03-30-2017__00:03:49.log
>
>
>
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected
> exception during fragment initialization: Failure while trying to
> check if a table or view with given name [t] already exists in schema
> [dfs.tmp]: java.net.URISyntaxException: Relative path in absolute URI:
> wifi-03-30-2017__00:03:49.log
> org.apache.drill.exec.work.foreman.Foreman.run():298
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (org.apache.drill.common.exceptions.DrillRuntimeException)
> Failure while trying to check if a table or view with given name [t]
> already exists in schema [dfs.tmp]: java.net.URISyntaxException:
> Relative path in absolute URI: wifi-03-30-2017__00:03:49.log
> org.apache.drill.exec.planner.sql.handlers.SqlHandlerUtil.ge
> tTableFromSchema():215
> org.apache.drill.exec.planner.sql.handlers.CreateTableHandle
> r.checkDuplicatedObjectExistence():307
> org.apache.drill.exec.planner.sql.handlers.CreateTableHandle
> r.getPlan():86
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():131
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():79
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1050
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.IllegalArgumentException)
> java.net.URISyntaxException: Relative path in absolute URI:
> wifi-03-30-2017__00:03:49.log
> org.apache.hadoop.fs.Path.initialize():205
> org.apache.hadoop.fs.Path.():171
> org.apache.hadoop.fs.Path.():93
> org.apache.hadoop.fs.Globber.glob():241
> org.apache.hadoop.fs.FileSystem.globStatus():1655
> org.apache.drill.exec.store.dfs.DrillFileSystem.globStatus():548
> org.apache.drill.exec.dotdrill.DotDrillUtil.getDotDrills():61
> org.apache.drill.exec.store.dfs.WorkspaceSchemaFactory$Works
> paceSchema.getTable():493
> org.apache.drill.exec.planner.sql.handlers.SqlHandlerUtil.ge
> tTableFromSchema():212
> org.apache.drill.exec.planner.sql.handlers.CreateTableHandle
> r.checkDuplicatedObjectExistence():307
> org.apache.drill.exec.planner.sql.handlers.CreateTableHandle
> r.getPlan():86
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():131
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():79
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1050
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.net.URISyntaxException) Relative path in absolute
> URI: wifi-03-30-2017__00:03:49.log
> java.net.URI.checkPath():1823
> java.net.URI.():745
> org.apache.hadoop.fs.Path.initialize():202
> org.apache.hadoop.fs.Path.():171
> org.apache.hadoop.fs.Path.():93
> org.apache.hadoop.fs.Globber.glob():241
> org.apache.hadoop.fs.FileSystem.globStatus():1655
> org.apache.drill.exec.store.dfs.DrillFileSystem.globStatus():548
> org.apache.drill.exec.dotdrill.DotDrillUtil.getDotDrills():61
> org.apache.drill.exec.store.dfs.WorkspaceSchemaFactory$Works
> paceSchema.getTable():493
> org.apache.drill.exec.planner.sql.handlers.SqlHandlerUtil.ge
> tTableFromSchema():212
> org.apache.drill.exec.planner.sql.handlers.CreateTableHandle
> r.checkDuplicatedObjectExistence():307
> org.apache.drill.exec.planner.sql.handlers.CreateTableHandle
> r.getPlan():86
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():131
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():79
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1050
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
>
> Thank you,
> Amir Kafri
>
> On Tue, Mar 28, 2017 at 4:12 PM Arina Yelchiyeva <
> arina.yelchiy...@gmail.com>
> wrote:
>
> > I have tried simple query on Drill 1.9.0 but seems query returns correct
> > result.
> >
> > create table dfs.tmp.t as select 1 col1, 2 col2 from (values(1));
> > select col1 c, sum(col1) over() cnt from dfs.tmp.t where col2 between 1
> and
> > 10;
> > +----+------+
> > | c | cnt |
> > +----+------+
> > | 1 | 1 |
> > +----+------+
> >
> > Amir, it would be great if you could provide sample data and
instructions
> > how to reproduce the issue (like I did above) and open Jira with this
> > information.
> >
> > Kind regards
> > Arina
> >
> > On Tue, Mar 28, 2017 at 1:23 PM, Amir Kafri <am...@datorama.com> wrote:
> >
> > > Hi Arina,
> > >
> > > I'm using V 1.9. I tried it both in embedded and jdbc.
> > >
> > > The actual query is slightly more complicated:
> > >
> > > SELECT
> > > bugs DYNAMIC_SCHEMA_2_MES_BUGS,
> > > sum(bugs) over() AS CNT
> > > FROM
> > > s3datorama.`dss`.`dynamic-schema-id=2` DYNAMIC_SCHEMA_2
> > > WHERE
> > > ( DYNAMIC_SCHEMA_2.date_id >= 2015021100 <(201)%20502-1100>
> AND
> > > DYNAMIC_SCHEMA_2.date_id <= 2017031223 <(201)%20703-1223> )
> > >
> > > On Tue, Mar 28, 2017 at 12:40 PM Arina Yelchiyeva <
> > > arina.yelchiy...@gmail.com> wrote:
> > >
> > > > Hi Amir,
> > > >
> > > > Which version of Drill are you using?
> > > > I have tried to reproduce the issue in embedded mode and in also
> using
> > > jdbc
> > > > but no luck.
> > > >
> > > > Kind regards
> > > > Arina
> > > >
> > > > On Tue, Mar 28, 2017 at 10:25 AM, Amir Kafri <am...@datorama.com>
> > wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > I think I've encountered a bug:
> > > > >
> > > > > I'm running the following query:
> > > > >
> > > > > SELECT
> > > > > metric AS m,
> > > > > COUNT(*) OVER() AS row_counter
> > > > > FROM t
> > > > >
> > > > > The result is correct, but the name of the 2nd column in the
result
> > set
> > > > is
> > > > > w0$o0.
> > > > >
> > > > > If I switch the order in the SELECT:
> > > > > SELECT
> > > > > COUNT(*) OVER() AS row_counter,
> > > > > metric AS m
> > > > > FROM t
> > > > >
> > > > > then the column names are correct (row_counter, m).
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > > *Amir Kafri*Data Engineer
> > > > >
> > > > >
> > > > > *datorama*All Your *Data*, Working Together
> > > > > *.*Habarzel 34, Ramat Hachayal, Tel-Aviv, 69710
> > > > > *E* am...@datorama.com
> > > > > *Website <http://www.datorama.com/> | LinkedIn
> > > > > <https://www.linkedin.com/company/datorama> | Twitter
> > > > > <https://twitter.com/datorama> | Facebook
> > > > > <https://www.facebook.com/pages/Datorama/232963956806382>*
> > > > >
> > > >
> > > --
> > >
> > > *Amir Kafri*Data Engineer
> > >
> > >
> > > *datorama*All Your *Data*, Working Together
> > > *.*Habarzel 34, Ramat Hachayal, Tel-Aviv, 69710
> > > *E* am...@datorama.com
> > > *Website <http://www.datorama.com/> | LinkedIn
> > > <https://www.linkedin.com/company/datorama> | Twitter
> > > <https://twitter.com/datorama> | Facebook
> > > <https://www.facebook.com/pages/Datorama/232963956806382>*
> > >
> >
> --
>
> *Amir Kafri*Data Engineer
>
>
> *datorama*All Your *Data*, Working Together
> *.*Habarzel 34, Ramat Hachayal, Tel-Aviv, 69710
> *E* am...@datorama.com
> *Website <http://www.datorama.com/> | LinkedIn
> <https://www.linkedin.com/company/datorama> | Twitter
> <https://twitter.com/datorama> | Facebook
> <https://www.facebook.com/pages/Datorama/232963956806382>*
>
