Home | About | Sematext search-lucene.com search-hadoop.com
 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>