You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Divya Gehlot <di...@gmail.com> on 2017/08/03 03:50:17 UTC
unable to run drill sql in shell script
Hi,
I have installed Drill on windows Embedded mode.
Have a git Bash installed and I am trying to start the sqlline through the
shell script
Below is script which I am using :
> SQLLINE="/c/ApacheDrill/apache-drill-1.11.0.tar/apache-drill-1.11.0/bin/drill-localhost
> -u \"jdbc:drill:zk=localhost:2181\"";
> $SQLLINE
When I run above shell script it gives me below error :
> Running query from bash
> Error: Could not find or load main class sqlline.SqlLine
> Java HotSpot(TM) 64-Bit Server VM warning: ignoring option
> MaxPermSize=512M; support was removed in 8.0
Options which I have tried are :
1.sqlline
2.drill-localhost
3.drill-embedded
All gives the same error as above
Appreciate the help.
Thanks,
Divya
RE: unable to run drill sql in shell script
Posted by Kunal Khatua <kk...@mapr.com>.
You seem to be missing the jars in the classpath.
Notice the line before the error... "Calculating Drill classpath"
What you probably need to do is to navigate to your installation's bin directory and launch from there.
-----Original Message-----
From: Divya Gehlot [mailto:divya.htconex@gmail.com]
Sent: Sunday, August 06, 2017 6:45 PM
To: user@drill.apache.org
Subject: Re: unable to run drill sql in shell script
yes thats the first step I tried and when I start drill using thatI get below error :
*Command *:
apache-drill-1.11.0/bin/sqlline.bat -u \"jdbc:drill:zk=local\""
*Error :*
$ sh drilltest.sh
> Running query from bash
> DRILL_ARGS - " -u \"jdbc:drill:zk localhost:2181\"""
> Calculating HADOOP_CLASSPATH ...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Error: Could not find or load main class sqlline.SqlLine
Is it possible to run through git bash installed in embedded mode on windows machine ?
Thanks,
Divya
On 3 August 2017 at 12:18, Padma Penumarthy <pp...@mapr.com> wrote:
> Did you look at this link ?
>
> https://drill.apache.org/docs/starting-drill-on-windows/
>
>
> It says, to start drill on windows, do this:
> sqlline.bat -u "jdbc:drill:zk=local"
>
>
> Try that and see.
>
> Thanks,
> Padma
>
> ________________________________
> From: Divya Gehlot <di...@gmail.com>
> Sent: Wednesday, August 2, 2017 8:50 PM
> To: user@drill.apache.org
> Subject: unable to run drill sql in shell script
>
> Hi,
> I have installed Drill on windows Embedded mode.
> Have a git Bash installed and I am trying to start the sqlline through
> the shell script Below is script which I am using :
>
> > SQLLINE="/c/ApacheDrill/apache-drill-1.11.0.tar/
> apache-drill-1.11.0/bin/drill-localhost
> > -u \"jdbc:drill:zk=localhost:2181\"";
> > $SQLLINE
>
>
> When I run above shell script it gives me below error :
>
> > Running query from bash
> > Error: Could not find or load main class sqlline.SqlLine Java
> > HotSpot(TM) 64-Bit Server VM warning: ignoring option
> > MaxPermSize=512M; support was removed in 8.0
>
>
> Options which I have tried are :
> 1.sqlline
> 2.drill-localhost
> 3.drill-embedded
>
> All gives the same error as above
>
> Appreciate the help.
>
>
> Thanks,
> Divya
>
Re: unable to run drill sql in shell script
Posted by Divya Gehlot <di...@gmail.com>.
yes thats the first step I tried and when I start drill using thatI get
below error :
*Command *:
apache-drill-1.11.0/bin/sqlline.bat -u \"jdbc:drill:zk=local\""
*Error :*
$ sh drilltest.sh
> Running query from bash
> DRILL_ARGS - " -u \"jdbc:drill:zk localhost:2181\"""
> Calculating HADOOP_CLASSPATH ...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Error: Could not find or load main class sqlline.SqlLine
Is it possible to run through git bash installed in embedded mode on
windows machine ?
Thanks,
Divya
On 3 August 2017 at 12:18, Padma Penumarthy <pp...@mapr.com> wrote:
> Did you look at this link ?
>
> https://drill.apache.org/docs/starting-drill-on-windows/
>
>
> It says, to start drill on windows, do this:
> sqlline.bat -u "jdbc:drill:zk=local"
>
>
> Try that and see.
>
> Thanks,
> Padma
>
> ________________________________
> From: Divya Gehlot <di...@gmail.com>
> Sent: Wednesday, August 2, 2017 8:50 PM
> To: user@drill.apache.org
> Subject: unable to run drill sql in shell script
>
> Hi,
> I have installed Drill on windows Embedded mode.
> Have a git Bash installed and I am trying to start the sqlline through the
> shell script
> Below is script which I am using :
>
> > SQLLINE="/c/ApacheDrill/apache-drill-1.11.0.tar/
> apache-drill-1.11.0/bin/drill-localhost
> > -u \"jdbc:drill:zk=localhost:2181\"";
> > $SQLLINE
>
>
> When I run above shell script it gives me below error :
>
> > Running query from bash
> > Error: Could not find or load main class sqlline.SqlLine
> > Java HotSpot(TM) 64-Bit Server VM warning: ignoring option
> > MaxPermSize=512M; support was removed in 8.0
>
>
> Options which I have tried are :
> 1.sqlline
> 2.drill-localhost
> 3.drill-embedded
>
> All gives the same error as above
>
> Appreciate the help.
>
>
> Thanks,
> Divya
>
Re: unable to run drill sql in shell script
Posted by Padma Penumarthy <pp...@mapr.com>.
Did you look at this link ?
https://drill.apache.org/docs/starting-drill-on-windows/
It says, to start drill on windows, do this:
sqlline.bat -u "jdbc:drill:zk=local"
Try that and see.
Thanks,
Padma
________________________________
From: Divya Gehlot <di...@gmail.com>
Sent: Wednesday, August 2, 2017 8:50 PM
To: user@drill.apache.org
Subject: unable to run drill sql in shell script
Hi,
I have installed Drill on windows Embedded mode.
Have a git Bash installed and I am trying to start the sqlline through the
shell script
Below is script which I am using :
> SQLLINE="/c/ApacheDrill/apache-drill-1.11.0.tar/apache-drill-1.11.0/bin/drill-localhost
> -u \"jdbc:drill:zk=localhost:2181\"";
> $SQLLINE
When I run above shell script it gives me below error :
> Running query from bash
> Error: Could not find or load main class sqlline.SqlLine
> Java HotSpot(TM) 64-Bit Server VM warning: ignoring option
> MaxPermSize=512M; support was removed in 8.0
Options which I have tried are :
1.sqlline
2.drill-localhost
3.drill-embedded
All gives the same error as above
Appreciate the help.
Thanks,
Divya