incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajika Kumarasiri <rajika.kumaras...@gmail.com>
Subject Re: quick start guide
Date Wed, 11 Dec 2013 07:03:14 GMT
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