incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Harri Kinnunen <Harri.Kinnu...@hitsaamo.fi>
Subject RE: quick start guide
Date Wed, 11 Dec 2013 06:53:51 GMT
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
View raw message