Return-Path: X-Original-To: apmail-incubator-drill-user-archive@minotaur.apache.org Delivered-To: apmail-incubator-drill-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E933C10BC9 for ; Wed, 11 Dec 2013 06:43:02 +0000 (UTC) Received: (qmail 28865 invoked by uid 500); 11 Dec 2013 06:42:57 -0000 Delivered-To: apmail-incubator-drill-user-archive@incubator.apache.org Received: (qmail 28794 invoked by uid 500); 11 Dec 2013 06:42:51 -0000 Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: drill-user@incubator.apache.org Delivered-To: mailing list drill-user@incubator.apache.org Received: (qmail 28779 invoked by uid 99); 11 Dec 2013 06:42:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Dec 2013 06:42:48 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rajika.kumarasiri@gmail.com designates 209.85.220.178 as permitted sender) Received: from [209.85.220.178] (HELO mail-vc0-f178.google.com) (209.85.220.178) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Dec 2013 06:42:40 +0000 Received: by mail-vc0-f178.google.com with SMTP id lh4so5275532vcb.23 for ; Tue, 10 Dec 2013 22:42:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=wI/zLjgWvcfFNBEz/6XDLAG1S7sq1kHrv+MXJIDkFFs=; b=nFHpe4Fj8rLGieFdlkmtrFBW3ndImfuMJvh+l/1pO/9jhjw4XYlJwJRoaqju/3eHQe pNlzav7qFYZMBIROgxUFMeHTq1O6vEwE8loIZUWAnmeypc7Lyf5fNBsL/dmROQM3WP6f +mAlkEZ/9F2iECCmoD2cHMD161t6FoYdjrjAq14fAdmTFzOObbFP8cLB99C1rQn0iEB6 /A/oWz86Ft/Y8jk1J8/fbbSxFBU25YmgsNp5aOl2uYnsOtIrXg0vK85gmjT378v/86ml Ui6LYIJO4Q5MwU+aj2IErDWSDSNt+Q2Mdg4d41RTj0TvtJhylEeZZvLiLuTSVeydtzfY lN6Q== MIME-Version: 1.0 X-Received: by 10.52.164.37 with SMTP id yn5mr2410788vdb.26.1386744139424; Tue, 10 Dec 2013 22:42:19 -0800 (PST) Received: by 10.220.201.67 with HTTP; Tue, 10 Dec 2013 22:42:19 -0800 (PST) Date: Wed, 11 Dec 2013 01:42:19 -0500 Message-ID: Subject: quick start guide From: Rajika Kumarasiri To: drill-user@incubator.apache.org Content-Type: multipart/alternative; boundary=001a11c2320ad329fb04ed3c8763 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2320ad329fb04ed3c8763 Content-Type: text/plain; charset=ISO-8859-1 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.(FileOutputStream.java:212) at at ch.qos.logback.core.recovery.ResilientFileOutputStream.(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.(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.(DrillHandler.java:51) at at org.apache.drill.jdbc.RefDriver.createHandler(RefDriver.java:65) at at net.hydromatic.optiq.jdbc.UnregisteredDriver.(UnregisteredDriver.java:52) at at org.apache.drill.jdbc.RefDriver.(RefDriver.java:32) at at org.apache.drill.jdbc.RefDriver.(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> --001a11c2320ad329fb04ed3c8763--