title: Trying to replace HIVE string literal with variable in HQL
body: <p>Hi I have a simple create table statement...</p>
  
  <pre><code>set location_stage=${env:HDFS_STAGING_DIR};
  CREATE EXTERNAL TABLE IF NOT EXISTS stage.test(
  TEST_ID INT,
  TEST_NAME STRING
  )
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
  WITH SERDEPROPERTIES (
     "separatorChar" = ",",
     "quoteChar"     = "\"",
     "escapeChar"    = "\\")
  STORED AS TEXTFILE
  LOCATION "${hivevar:location_stage}";
  </code></pre>
  
  <p>I don't need the 'hivevar:location_stage' - I just need the 'env:HDFS_STAGING_DIR'.  However, neither is working.  I have used both in the 'LOCATION' clause.  I run both with the command line </p>
  
  <pre><code>hive -f test_hive_variable.sql
  </code></pre>
  
  <p>But I get the following error...</p>
  
  <pre><code>FAILED: IllegalArgumentException java.net.URISyntaxException: Relative path in absolute URI: ${hivevar:location_stage%7D
  </code></pre>
  
  <p>The hive version is Hive 1.2.1000.2.4.2.0-258</p>