Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # dev >> RE: [OS: Windows] Could not find or load main class sqlline.SqlLine


Copy link to this message
-
RE: [OS: Windows] Could not find or load main class sqlline.SqlLine
Hi Marco,
Thanks.  That is working.
0: jdbc:drill:schema=parquet-local> select * from "sample-data/region.parquet";SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".SLF4J: Defaulting to no-operation (NOP) logger implementationSLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|                                                                                  _MAP                                                                               |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {"R_REGIONKEY":0,"R_NAME":"AFRICA","R_COMMENT":"lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to  |
| {"R_REGIONKEY":1,"R_NAME":"AMERICA","R_COMMENT":"hs use ironic, even requests. s"}                                                                                  |
| {"R_REGIONKEY":2,"R_NAME":"ASIA","R_COMMENT":"ges. thinly even pinto beans ca"}                                                                                     |
| {"R_REGIONKEY":3,"R_NAME":"EUROPE","R_COMMENT":"ly final courts cajole furiously final excuse"}                                                                     |
| {"R_REGIONKEY":4,"R_NAME":"MIDDLE EAST","R_COMMENT":"uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl"} |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows selected (3.452 seconds)0: jdbc:drill:schema=parquet-local>
Regards,Ravi
> Date: Sat, 11 Jan 2014 16:53:09 -0800
> Subject: Re: [OS: Windows] Could not find or load main class sqlline.SqlLine
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> Hi Ravi,
>
> It looks good to me. Did you try to execute a query? For example:
> select * from "sample-data/region.parquet";
>
> If you like to get rid of the log messages on the console you can edit the
> logback.xml and remove (or comment) this line in the STDOUT appender:
> <level value="warn" />
>
> Marco
>
> On Sat, Jan 11, 2014 at 9:27 AM, Ravisankar Sivasubramaniam <
> [EMAIL PROTECTED]> wrote:
>
> > Hi Marco,
> > Thank you very much for your time.  I abandoned the classpath approach and
> > went back to "copy-dependency" approach.  Given below is the output of
> > sqlline.bat.  Can you quickly confirm if the output is as expected?  I will
> > send across the patch for Windows setup separately for code review.
> > D:\workspace\incubator-drill>sqlline.bat -u
> > jdbc:drill:schema=parquet-local -n admin -p admin
> > D:\workspace\incubator-drill>if not exist
> > contrib\sqlline\target\dependencies (call mvn -B -f contrib\sqlline\pom.xml
> > package )
> > D:\workspace\incubator-drill>java -Xmx1G
> > -Dlogback.configurationFile=.\sqlparser\src\test\resources\logback.xml
> > -cp ".\contrib\sqlline\target\dependencies\*" sqlline.SqlLine
> > --verbose=true -u jdbc:drill:schema=parquet-local -n admin -p adminLoaded
> > singnal handler: SunSignalHandlerissuing: !connect
> > jdbc:drill:schema=parquet-local admin adminscan complete in 9ms22:51:57,241
> > |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource
> > [.\sqlparser\src\test\resources\logback.xml] at
> > [file:/D:/workspace/incubator-drill/./sqlparser/src/test/resources/logback.xml]22:51:57,361
> > |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug
> > attribute not set22:51:57,374 |-INFO in
> > ch.qos.logback.core.joran.action.AppenderAction - About to instantiate
> > appender of type
> > [de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender]22:51:57,385
> > |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender
     
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB