title: Relative path in absolute URI in hadoop hive shell
body: <p>When I am trying to execute the <strong>.hql</strong> file from a shell prompt I am getting the following error. Can anyone tell me what I am missing?</p>
  
  <blockquote>
    <p>FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: hdfs://localhost:9000./=/usr/local/hadoop/usr/Move</p>
  </blockquote>
  
  <p><strong>Query.hql</strong> contains:</p>
  
  <pre class="lang-sql prettyprint-override"><code>create table if not exists MOVE(value string) location '${hiveconf:Move_Path}';
  </code></pre>
  
  <p>In the shell prompt I using this command to execute the file:</p>
  
  <pre class="lang-none prettyprint-override"><code>$ HIVE_HOME/bin/hive  -hiveconf Move_Path =/usr/POC/Move -f /home/ram/Source_Files/Source_code/Query.hql
  </code></pre>
  
  <p>I'm unsure about what exactly I need pass to the <em>"Move_Path"</em> argument - presently I am setting it as <em>"/usr/POC/Move"</em> - is this correct?</p>