You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Kunal Khatua (JIRA)" <ji...@apache.org> on 2019/01/18 21:29:00 UTC
[jira] [Resolved] (DRILL-6972) Error: Could not find or load main
class sqlline.SqlLine
[ https://issues.apache.org/jira/browse/DRILL-6972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua resolved DRILL-6972.
---------------------------------
Resolution: Works for Me
[~elenacampean] this worked for me with the latest Apache 1.15.0 release.
I am on a Windows 10 64-bit machine.
Here is the console output captured:
{code}
C:\Users\kkhatua\Downloads\ttl_3month\apache-drill-1.15.0.tar\apache-drill-1.15.0>dir
Volume in drive C is Windows
Volume Serial Number is 6C77-5BE3
Directory of C:\Users\kkhatua\Downloads\ttl_3month\apache-drill-1.15.0.tar\apache-drill-1.15.0
01/18/2019 01:19 PM <DIR> .
01/18/2019 01:19 PM <DIR> ..
01/18/2019 01:19 PM <DIR> bin
01/18/2019 01:19 PM <DIR> conf
12/24/2018 10:30 AM 941 git.properties
01/18/2019 01:19 PM <DIR> jars
12/24/2018 09:29 AM 46,514 KEYS
12/24/2018 09:29 AM 63,245 LICENSE
12/24/2018 09:29 AM 238 NOTICE
12/24/2018 09:29 AM 1,301 README.md
01/18/2019 01:19 PM <DIR> sample-data
5 File(s) 112,239 bytes
6 Dir(s) 351,264,067,584 bytes free
C:\Users\kkhatua\Downloads\ttl_3month\apache-drill-1.15.0.tar\apache-drill-1.15.0>type git.properties
#Generated by Git-Commit-Id-Plugin
#Mon Dec 24 20:30:32 EET 2018
git.branch=8743e8f1e8d5bca4d67c94d07a8560ad356ff2b6
git.build.host=vitalii-pc
git.build.time=24.12.2018 @ 20\:30\:32 EET
git.build.user.email=vitalii.diravka@gmail.com
git.build.user.name=Vitalii Diravka
git.build.version=1.15.0
git.closest.tag.commit.count=0
git.closest.tag.name=drill-1.15.0
git.commit.id=8743e8f1e8d5bca4d67c94d07a8560ad356ff2b6
git.commit.id.abbrev=8743e8f
git.commit.id.describe=drill-1.15.0-0-g8743e8f
git.commit.id.describe-short=drill-1.15.0-0
git.commit.message.full=[maven-release-plugin] prepare release drill-1.15.0
git.commit.message.short=[maven-release-plugin] prepare release drill-1.15.0
git.commit.time=24.12.2018 @ 20\:09\:05 EET
git.commit.user.email=vitalii.diravka@gmail.com
git.commit.user.name=Vitalii Diravka
git.dirty=false
git.remote.origin.url=https\://github.com/apache/drill.git
git.tags=drill-1.15.0
git.total.commit.count=3407
C:\Users\kkhatua\Downloads\ttl_3month\apache-drill-1.15.0.tar\apache-drill-1.15.0>cd bin
C:\Users\kkhatua\Downloads\ttl_3month\apache-drill-1.15.0.tar\apache-drill-1.15.0\bin>sqlline -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Exception in thread "main" java.lang.IllegalArgumentException: Bad history file syntax! The history file `C:\Users\kkhatua\sqlline\history` may be an older history: please remove it or use a different history file.
at org.jline.reader.impl.history.DefaultHistory.addHistoryLine(DefaultHistory.java:104)
at org.jline.reader.impl.history.DefaultHistory.lambda$load$0(DefaultHistory.java:86)
at java.util.Iterator.forEachRemaining(Iterator.java:116)
at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
at org.jline.reader.impl.history.DefaultHistory.load(DefaultHistory.java:86)
at org.jline.reader.impl.history.DefaultHistory.attach(DefaultHistory.java:69)
at sqlline.SqlLine.getConsoleReader(SqlLine.java:614)
at sqlline.SqlLine.begin(SqlLine.java:510)
at sqlline.SqlLine.start(SqlLine.java:264)
at sqlline.SqlLine.main(SqlLine.java:195)
C:\Users\kkhatua\Downloads\ttl_3month\apache-drill-1.15.0.tar\apache-drill-1.15.0\bin>del C:\Users\kkhatua\sqlline\history
C:\Users\kkhatua\Downloads\ttl_3month\apache-drill-1.15.0.tar\apache-drill-1.15.0\bin>sqlline -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Apache Drill 1.15.0
"Just Drill It."
0: jdbc:drill:zk=local> select * from sys.drillbits;
+-------------+------------+---------------+------------+------------+----------+----------+---------+
| hostname | user_port | control_port | data_port | http_port | current | version | state |
+-------------+------------+---------------+------------+------------+----------+----------+---------+
| t470s-1196 | 31010 | 31011 | 31012 | 8047 | true | 1.15.0 | ONLINE |
+-------------+------------+---------------+------------+------------+----------+----------+---------+
1 row selected (2.941 seconds)
0: jdbc:drill:zk=local> !q
Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl
{code}
> Error: Could not find or load main class sqlline.SqlLine
> --------------------------------------------------------
>
> Key: DRILL-6972
> URL: https://issues.apache.org/jira/browse/DRILL-6972
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.15.0
> Environment: Windows 10 Education
> 64-bit OS
> Reporter: Elena Campean
> Priority: Major
> Labels: apache, drill, start
>
> I am running in cmd, the command:Â sqlline.bat -u "jdbc:drill:zk=local", in order to start drill, but I get the result:
> _DRILL_ARGS - " -u jdbc:drill:zk=local"_
> _The system cannot find the path specified._
> _HADOOP_HOME not detected..._
> _HBASE_HOME not detected..._
> _Calculating Drill classpath..._
> _Error: Could not find or load main class sqlline.SqlLine_
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)