I am talking about the parameters in the query itself like passing the tablename to the query or the directory parameters where the parquet file should be created
Thanks, Divya On 3 August 2017 at 12:30, Kunal Khatua <[email protected]> wrote: > If you just want to run the query with the parameters like "alter > session", you can write those session-altering SQL as the initial set of > queries before the actual query in the same file. > > Then run something like this: > > /opt /drill/apache-drill-1.11.0/bin/sqlline -u "jdbc:drill:zk=local" > --force true -f <queryFileName> > > This opens a session, and runs all the queries (separated by a semi-colon). > > The force flag is meant for ensuring that in the event a query within the > file fails, it will still continue to execute the following queries in the > file. > > > -----Original Message----- > From: Divya Gehlot [mailto:[email protected]] > Sent: Wednesday, August 02, 2017 7:30 PM > To: [email protected] > Subject: pass parameters to Drill query in file > > Hi, > how to pass parameters to Drill query in file? > > Thanks, > Divya >
