[ https://issues.apache.org/jira/browse/DRILL-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Hellstrom updated DRILL-4506: --------------------------------- Affects Version/s: 1.5.0 > Allow substitution variables in SQL scripts > ------------------------------------------- > > Key: DRILL-4506 > URL: https://issues.apache.org/jira/browse/DRILL-4506 > Project: Apache Drill > Issue Type: Wish > Components: SQL Parser > Affects Versions: 1.5.0 > Reporter: Ian Hellstrom > Labels: features > > It would be great if substitution variables could be created à la SQL*Plus in > scripts. This would be especially helpful when objects need to be > (re-)created from scratch (i.e. in testing), and they share e.g. workspaces, > which have to be hard-coded otherwise. > The following is a rough idea (based on SQL*Plus syntax): > {code} > IN_LOCATION=hdfs.project > OUT_LOCATION=hdfs.storage > CREATE VIEW &OUT_LOCATION.view_name AS > SELECT * FROM &IN_LOCATION.table_name; > {code} > For a first implementation, it would be best to have simply substitution > variables and not allow computations to be done, although it is conceivable > that that would be a second step. -- This message was sent by Atlassian JIRA (v6.3.4#6332)