Can we run queries from file

["Raghavendra Ganji - ERS, HCL Tech" <ra...@hcl.com>]

Hi,

I want to run SQL queries (spans many lines) from a file instead of interactive mode. Is this possible in drill. If yes how to do this. Help is appreciated.

Thanks and Regards,
Raghavendra



::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

Re: Can we run queries from file

[Andries Engelbrecht <ae...@maprtech.com>]

You have a few options

from the OS shell you can use the sqlline syntax as mentioned by Rajkumar

./sqlline -u <jdbc string> -n <user> -p <password> --run=<sql_file>  > <output file>
or you can use -f <sql_file> instead of --run=

In the sqlline shell

sqlline> !record <output file name>
sqlline> !run <sql_file>
sqlline> !record
Last record stop spooling output to a file

For comments in the sql file you can use # and /* */  , but had some interesting things pop, someone may provide more input here.


--Andries



> On Nov 10, 2015, at 10:52 PM, Rajkumar Singh <rs...@maprtech.com> wrote:
> 
> try 
> bin/sqlline -u jdbc:drill:zk=zk_qourum —run=run.sql
>> On Nov 11, 2015, at 12:01 PM, Raghavendra Ganji - ERS, HCL Tech <ra...@hcl.com> wrote:
>> 
>> Hi,
>> 
>> I want to run SQL queries (spans many lines) from a file instead of interactive mode. Is this possible in drill. If yes how to do this. Help is appreciated.
>> 
>> Thanks and Regards,
>> Raghavendra
>> 
>> 
>> 
>> ::DISCLAIMER::
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
>> 
>> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
>> E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
>> lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
>> (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
>> Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
>> views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
>> distribution and / or publication of this message without the prior written consent of authorized representative of
>> HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
>> Before opening any email and/or attachments, please check them for viruses and other defects.
>> 
>> ----------------------------------------------------------------------------------------------------------------------------------------------------
> 

Re: Can we run queries from file

[Rajkumar Singh <rs...@maprtech.com>]

try 
bin/sqlline -u jdbc:drill:zk=zk_qourum —run=run.sql
> On Nov 11, 2015, at 12:01 PM, Raghavendra Ganji - ERS, HCL Tech <ra...@hcl.com> wrote:
> 
> Hi,
> 
> I want to run SQL queries (spans many lines) from a file instead of interactive mode. Is this possible in drill. If yes how to do this. Help is appreciated.
> 
> Thanks and Regards,
> Raghavendra
> 
> 
> 
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
> 
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior written consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses and other defects.
> 
> ----------------------------------------------------------------------------------------------------------------------------------------------------