Any pointers to solve the issue ? Thank you.
Rajika On Wed, Dec 11, 2013 at 2:03 AM, Rajika Kumarasiri < [email protected]> 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 < > [email protected]> 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:[email protected]] >> Sent: 11. joulukuuta 2013 8:42 >> To: [email protected] >> 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> >> > >
