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,
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 as [SOCKET]22:51:57,434 |-INFO in de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET] - Waiting 1s to establish connections.22:51:58,434 |-INFO in de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET] - Started de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET]22:51:58,434 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]22:51:58,439 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT]22:51:58,447 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property22:51:58,506 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@33:27 - no applicable action for [level], current ElementPath  is [[configuration][appender][level]]22:51:58,506 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.drill] to false22:51:58,506 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.drill level set to DEBUG22:51:58,507 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOCKET] to Logger[org.apache.drill]22:51:58,507 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT level set to DEBUG22:51:58,507 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOCKET] to Logger[ROOT]22:51:58,507 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.22:51:58,508 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@8c0e89 - Registering current configuration as safe fallback point
scan complete in 2207msConnecting to jdbc:drill:schema=parquet-localConnected to: Drill (version 1.0)Driver: Apache Drill JDBC Driver (version 1.0)Autocommit status: trueTransaction isolation: TRANSACTION_REPEATABLE_READsqlline version ??? by Marc Prud'hommeaux0: jdbc:drill:schema=parquet-local>
Regards,Ravi
> Date: Sun, 29 Dec 2013 12:29:29 -0800
> Subject: Re: [OS: Windows] Could not find or load main class sqlline.SqlLine
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> Ravi,
>
> sqlline.properties is included in sqlline-1.1.0.jar. You can get rid of
> this message by extracting the file and copying it into your user folder
> C:\Users\ravisankars\sqlline\. Anyway, this is not critical, you can work
> without that file.
>
> The real problem is the other error [No known driver to handle
     
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