RE: unable to run drill sql in shell script

[Kunal Khatua]

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.htco...@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 <ppenumar...@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 <divya.htco...@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

[Padma Penumarthy]

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