Drill doesn't support that, but you're welcome to implement that and contribute to Drill.
A workaround would be to create your own script that takes parameters and writes a SQL file that will then be used by SQLLine to run.
From: Divya Gehlot [mailto:***@gmail.com]
Sent: Sunday, August 06, 2017 6:47 PM
Subject: Re: pass parameters to Drill query in file
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
Post by Kunal Khatua
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.
/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.
Sent: Wednesday, August 02, 2017 7:30 PM
Subject: pass parameters to Drill query in file
how to pass parameters t