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 <[email protected]> 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 >> <[email protected]> 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. >> >> ---------------------------------------------------------------------------------------------------------------------------------------------------- >
