drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Nadeau <jacq...@apache.org>
Subject Re: quick start guide
Date Thu, 12 Dec 2013 05:25:43 GMT
It looks like you are having an issue where your distribution folder isn't
set up right.  Did you go into the distribution/target folder and use that
for your experimentation?  It looks like you're missing the parquet sample
data files (or they are in the wrong location).

The logging errors shouldn't impact function.  The important line is: File
sample-data/region.parquet does not exist.

There is a way to change the location of the log file.  I think it is in
one of the files in the conf directory.  I'm thinking logback.xml but I'm
not 100%.  Maybe Steven can remind us.

Jacques


On Wed, Dec 11, 2013 at 3:10 PM, Rajika Kumarasiri <
rajika.kumarasiri@gmail.com> wrote:

> Any pointers to solve the issue ?
>
> Thank you.
>
> Rajika
>
>
> On Wed, Dec 11, 2013 at 2:03 AM, Rajika Kumarasiri <
> rajika.kumarasiri@gmail.com> wrote:
>
> > 1. Yeah I tried.
> >
> > 0: jdbc:drill:schema=parquet-local> select * from
> > "sample-data/region.parquet";
> > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure
> while
> > running query.[error_id: "8ad8adcf-d926-49f5-9a6e-9089ac155f77"
> > endpoint {
> >   address: "localhost"
> >   user_port: 31010
> >   bit_port: 31011
> > }
> > error_type: 0
> > message: "Failure while converting logical plan to physical plan. <
> > OptimizerException:[ Failure while attempting to retrieve storage
> engine. ]
> > < FileNotFoundException:[ File sample-data/region.parquet does not
> exist. ]"
> > ]
> > java.lang.RuntimeException: org.apache.drill.exec.rpc.RpcException:
> Remote
> > failure while running query.[error_id:
> > "8ad8adcf-d926-49f5-9a6e-9089ac155f77"
> > endpoint {
> >   address: "localhost"
> >   user_port: 31010
> >   bit_port: 31011
> > }
> > error_type: 0
> > message: "Failure while converting logical plan to physical plan. <
> > OptimizerException:[ Failure while attempting to retrieve storage
> engine. ]
> > < FileNotFoundException:[ File sample-data/region.parquet does not
> exist. ]"
> > ]
> > at
> >
> org.apache.drill.sql.client.full.ResultEnumerator.moveNext(ResultEnumerator.java:61)
> > at
> >
> net.hydromatic.optiq.runtime.ObjectEnumeratorCursor.next(ObjectEnumeratorCursor.java:44)
> >  at
> net.hydromatic.optiq.jdbc.OptiqResultSet.next(OptiqResultSet.java:162)
> > at sqlline.SqlLine$BufferedRows.<init>(SqlLine.java:2499)
> >  at sqlline.SqlLine.print(SqlLine.java:1886)
> > at sqlline.SqlLine$Commands.execute(SqlLine.java:3835)
> > at sqlline.SqlLine$Commands.sql(SqlLine.java:3738)
> >  at sqlline.SqlLine.dispatch(SqlLine.java:882)
> > at sqlline.SqlLine.begin(SqlLine.java:717)
> > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
> >  at sqlline.SqlLine.main(SqlLine.java:443)
> > Caused by: org.apache.drill.exec.rpc.RpcException: Remote failure while
> > running query.[error_id: "8ad8adcf-d926-49f5-9a6e-9089ac155f77"
> > endpoint {
> >   address: "localhost"
> >   user_port: 31010
> >   bit_port: 31011
> > }
> > error_type: 0
> > message: "Failure while converting logical plan to physical plan. <
> > OptimizerException:[ Failure while attempting to retrieve storage
> engine. ]
> > < FileNotFoundException:[ File sample-data/region.parquet does not
> exist. ]"
> > ]
> > at
> >
> org.apache.drill.exec.rpc.user.QueryResultHandler.batchArrived(QueryResultHandler.java:72)
> > at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:79)
> >  at
> >
> org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:48)
> > at
> >
> org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:33)
> >  at
> > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:142)
> > at
> org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:127)
> >  at
> >
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
> > at
> >
> io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
> >  at
> >
> io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
> > at
> >
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
> >  at
> >
> io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
> > at
> >
> io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
> >  at
> >
> io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:173)
> > at
> >
> io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
> >  at
> >
> io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
> > at
> >
> io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:785)
> >  at
> >
> io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:100)
> > at
> >
> io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:497)
> >  at
> >
> io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:465)
> > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:359)
> >  at
> >
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:101)
> > at java.lang.Thread.run(Thread.java:724)
> > 0: jdbc:drill:schema=parquet-local>
> >
> >
> > 2. Where can I configure that log path instead default /var/log/drill ?
> >
> >
> > There are more errors;
> >
> > ls: cannot access /home/rajika/project/accumulo/hadoop-1.0.4/lib/*jar: No
> > such file or directory
> >
> > Rajika
> >
> >
> >
> > On Wed, Dec 11, 2013 at 1:53 AM, Harri Kinnunen <
> > Harri.Kinnunen@hitsaamo.fi> wrote:
> >
> >> No access to drill right now... But:
> >>
> >> 1) Have tried to run a query in the prompt anyways? (select * from
> >> "sample-data/region.parquet";  for example)
> >> 2) It says there:
> >> java.io.FileNotFoundException: /var/log/drill/sqlline.log (No such file
> >> ordirectory)
> >> --> Have you checked the file/directory permissions?
> >>
> >> Cheers,
> >> -Harri
> >>
> >>
> >> -----Original Message-----
> >> From: Rajika Kumarasiri [mailto:rajika.kumarasiri@gmail.com]
> >> Sent: 11. joulukuuta 2013 8:42
> >> To: drill-user@incubator.apache.org
> >> Subject: quick start guide
> >>
> >> I built the binary distribution from the source. When I try the guide
> >> https://cwiki.apache.org/confluence/display/DRILL/Running+Queries it
> >> gave me below errors. It seems I didn't complete some prerequisites.
> Where
> >> can I read about them ?
> >>
> >> Rajika
> >>
> >>
> >> [rajika@localhost bin]$ ./sqlline -u jdbc:drill:schema=parquet-local -n
> >> admin -p admin
> >> ls: cannot access /home/rajika/project/accumulo/hadoop-1.0.4/lib/*jar:
> No
> >> such file or directory
> >>
> >> Loaded singnal handler: SunSignalHandler
> >> /home/rajika/.sqlline/sqlline.properties (No such file or directory)
> scan
> >> complete in 39ms
> >> 01:32:55,640 |-INFO in ch.qos.logback.classic.LoggerContext[default] -
> >> Could NOT find resource [logback.groovy]
> >> 01:32:55,641 |-INFO in ch.qos.logback.classic.LoggerContext[default] -
> >> Could NOT find resource [logback-test.xml]
> >> 01:32:55,641 |-INFO in ch.qos.logback.classic.LoggerContext[default] -
> >> Found resource [logback.xml] at
> >>
> [file:/home/rajika/project/apache/drill/distribution/target/apache-drill-1.0.0-m2-incubating-SNAPSHOT/conf/logback.xml]
> >> 01:32:55,805 |-INFO in
> >> ch.qos.logback.classic.joran.action.ConfigurationAction - debug
> attribute
> >> not set
> >> 01:32:55,838 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
> >> About to instantiate appender of type
> >> [de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender]
> >> 01:32:55,854 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
> >> Naming appender as [SOCKET]
> >> 01:32:55,884 |-INFO in
> >>
> de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET]
> >> - Waiting 1s to establish connections.
> >> 01:32:56,884 |-INFO in
> >>
> de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET]
> >> - Started
> >>
> de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET]
> >> 01:32:56,884 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
> >> About to instantiate appender of type
> [ch.qos.logback.core.ConsoleAppender]
> >> 01:32:56,893 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
> >> Naming appender as [STDOUT]
> >> 01:32:56,900 |-INFO in
> >> ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming
> >> default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for
> >> [encoder] property
> >> 01:32:56,979 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
> >> About to instantiate appender of type
> >> [ch.qos.logback.core.rolling.RollingFileAppender]
> >> 01:32:56,981 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
> >> Naming appender as [FILE]
> >> 01:32:56,996 |-INFO in
> >> ch.qos.logback.core.rolling.FixedWindowRollingPolicy@2ed6ddda - No
> >> compression will be used
> >> 01:32:57,003 |-INFO in
> >> ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming
> >> default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for
> >> [encoder] property
> >> 01:32:57,004 |-INFO in
> >> ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file
> >> name: /var/log/drill/sqlline.log
> >> 01:32:57,004 |-INFO in
> >> ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is
> >> set to [/var/log/drill/sqlline.log]
> >> 01:32:57,005 |-ERROR in
> >> ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Failed to create
> >> parent directories for [/var/log/drill/sqlline.log]
> >> 01:32:57,005 |-ERROR in
> >> ch.qos.logback.core.rolling.RollingFileAppender[FILE] -
> >> openFile(/var/log/drill/sqlline.log,true) call failed.
> >> java.io.FileNotFoundException: /var/log/drill/sqlline.log (No such file
> or
> >> directory)
> >> at java.io.FileNotFoundException: /var/log/drill/sqlline.log (No such
> >> file or directory) at at java.io.FileOutputStream.open(Native Method)
> at at
> >> java.io.FileOutputStream.<init>(FileOutputStream.java:212)
> >> at at
> >>
> >>
> ch.qos.logback.core.recovery.ResilientFileOutputStream.<init>(ResilientFileOutputStream.java:28)
> >> at at ch.qos.logback.core.FileAppender.openFile(FileAppender.java:149)
> >> at at ch.qos.logback.core.FileAppender.start(FileAppender.java:108)
> >> at at
> >>
> >>
> ch.qos.logback.core.rolling.RollingFileAppender.start(RollingFileAppender.java:86)
> >> at at
> >>
> >>
> ch.qos.logback.core.joran.action.AppenderAction.end(AppenderAction.java:96)
> >> at at
> >>
> >>
> ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:317)
> >> at at
> >>
> ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:196)
> >> at at
> >>
> ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:182)
> >> at at
> ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)
> >> at at
> >>
> >>
> ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:149)
> >> at at
> >>
> >>
> ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:135)
> >> at at
> >>
> >>
> ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:99)
> >> at at
> >>
> >>
> ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:49)
> >> at at
> >>
> >>
> ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)
> >> at at
> >>
> >>
> ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:148)
> >> at at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:85)
> >> at at
> >> org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
> >> at at org.slf4j.LoggerFactory.bind(LoggerFactory.java:128)
> >> at at
> >> org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:107)
> >> at at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:295)
> >> at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:269)
> >> at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:281)
> >> at at org.apache.drill.jdbc.DrillHandler.<clinit>(DrillHandler.java:51)
> >> at at org.apache.drill.jdbc.RefDriver.createHandler(RefDriver.java:65)
> >> at at
> >>
> >>
> net.hydromatic.optiq.jdbc.UnregisteredDriver.<init>(UnregisteredDriver.java:52)
> >> at at org.apache.drill.jdbc.RefDriver.<init>(RefDriver.java:32)
> >> at at org.apache.drill.jdbc.RefDriver.<clinit>(RefDriver.java:38)
> >> at at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> >> Method) at at
> >>
> >>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> >> at at
> >>
> >>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> >> at at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> >> at at java.lang.Class.newInstance(Class.java:374)
> >> at at sqlline.SqlLine.scanDrivers(SqlLine.java:1763)
> >> at at sqlline.SqlLine.scanForDriver(SqlLine.java:1687)
> >> at at sqlline.SqlLine.access$2300(SqlLine.java:58)
> >> at at sqlline.SqlLine$Commands.connect(SqlLine.java:4069)
> >> at at sqlline.SqlLine$Commands.connect(SqlLine.java:4003)
> >> at at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at at
> >>
> >>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> >> at at
> >>
> >>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> >> at at java.lang.reflect.Method.invoke(Method.java:606)
> >> at at
> sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2964)
> >> at at sqlline.SqlLine.dispatch(SqlLine.java:878)
> >> at at sqlline.SqlLine.initArgs(SqlLine.java:652)
> >> at at sqlline.SqlLine.begin(SqlLine.java:699)
> >> at at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
> >> at at sqlline.SqlLine.main(SqlLine.java:443)
> >> 01:32:57,006 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction
> -
> >> Setting additivity of logger [org.apache.drill] to false
> >> 01:32:57,006 |-INFO in ch.qos.logback.classic.joran.action.LevelAction -
> >> org.apache.drill level set to INFO
> >> 01:32:57,006 |-INFO in
> ch.qos.logback.core.joran.action.AppenderRefAction
> >> - Attaching appender named [FILE] to Logger[org.apache.drill]
> >> 01:32:57,006 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction
> -
> >> Setting additivity of logger [org.apache.drill] to false
> >> 01:32:57,007 |-INFO in ch.qos.logback.classic.joran.action.LevelAction -
> >> org.apache.drill level set to DEBUG
> >> 01:32:57,007 |-INFO in
> ch.qos.logback.core.joran.action.AppenderRefAction
> >> - Attaching appender named [SOCKET] to Logger[org.apache.drill]
> >> 01:32:57,007 |-INFO in ch.qos.logback.classic.joran.action.LevelAction -
> >> ROOT level set to ERROR
> >> 01:32:57,007 |-INFO in
> ch.qos.logback.core.joran.action.AppenderRefAction
> >> - Attaching appender named [STDOUT] to Logger[ROOT]
> >> 01:32:57,007 |-INFO in
> >> ch.qos.logback.classic.joran.action.ConfigurationAction - End of
> >> configuration.
> >> 01:32:57,007 |-INFO in
> >> ch.qos.logback.classic.joran.JoranConfigurator@75a2edef - Registering
> >> current configuration as safe fallback point
> >>
> >> scan complete in 3196ms
> >> Connecting to jdbc:drill:schema=parquet-local Connected to: Drill
> >> (version 1.0)
> >> Driver: Apache Drill JDBC Driver (version 1.0) Autocommit status: true
> >> Transaction isolation: TRANSACTION_REPEATABLE_READ sqlline version ???
> by
> >> Marc Prud'hommeaux
> >> 0: jdbc:drill:schema=parquet-local>
> >> 0: jdbc:drill:schema=parquet-local>
> >>
> >
> >
>

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