drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shankar Mane <shankar.m...@games24x7.com>
Subject Re: Query execution in Drill
Date Fri, 03 Jun 2016 15:22:20 GMT
You can use the following:

$DRILL_HOME/bin/drill-conf --force=true -f filename.sql

Where
--force=true : Continue even after there is an error in sql query. This is
useful where you do: drop table t1 and create table t1.

-f : path to sql file.

You can check for more options using:
$DRILL_HOME/bin/drill-conf --help


On 3 Jun 2016 20:26, "Dechang Gu" <dgu@maprtech.com> wrote:

> On Fri, Jun 3, 2016 at 7:41 AM, Sebastian Hamann <drvmmen@web.de> wrote:
>
> > Hi,
> > Iam currently trying to write a shell script to automatically setup drill
> > (embedded for now) and execute queries on it.
> > 1. Is there an option to execute SQL from command line or file, like in
> > Hive?
> > (I mean the hive -e 'sql statement' or hive -f <filename>)
> >
> >
> Yes,  you can use "-f <query file>" on the command line to run the query
> from shell. E.g.,
> sqlline -u "jdbc:drill:zk=local" -f q1.sql
>
> where q1.sql the a file containing the sql statements to be executed.
>
>
> -Dechang
>
>
> > 2. If not: What is a good way to simulate such behaviour? Based on an
> idea
> > of mine: Is there maybe a way to start drill without starting the drill
> > prompt so that I can send queries through the rest API in the same
> script?
> >
> > I have looked throught he archives and google and still could not find an
> > easy solution for this.
> >
> > Thanks in advance!
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message