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 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
> 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>
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