Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of rajika.kumarasiri@gmail.com
 designates 209.85.220.178 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPDRHibp8UODeLYyabb1fOkvJuFN7DiYmMhgBMPa8U=LD3fghw@mail.gmail.com>
References: 
 <CAPDRHibJM-BNN_A7XNTa8P-cNuvcFfMGMtp3dSxXkTu-LG9uvA@mail.gmail.com>
	<30700E9AEF6B9447B206D67F387C91E3533D4AD0@NBL-EXCD2-02.nebula.local>
	<CAPDRHibp8UODeLYyabb1fOkvJuFN7DiYmMhgBMPa8U=LD3fghw@mail.gmail.com>
Date: Wed, 11 Dec 2013 18:10:25 -0500
Message-ID: 
 <CAPDRHiYkAd3WCt4RBs5E2zdA5mUzMcp6tRuq7U4nhLZ21y=cEA@mail.gmail.com>
Subject: Re: quick start guide
From: Rajika Kumarasiri <rajika.kumarasiri@gmail.com>
To: drill-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=001a11c2c0d68990ab04ed4a55fa

--001a11c2c0d68990ab04ed4a55fa
Content-Type: text/plain; charset=ISO-8859-1

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>
>>
>
>

--001a11c2c0d68990ab04ed4a55fa--