title: Hive error when declaring hivevar
body: <p>Trying to declare a variable in Hive using Hue online. Using the following code:</p>
  
  <pre><code>SET hivevar:TABLE1=location.tablename;
  </code></pre>
  
  <p>I am getting the following error message:</p>
  
  <pre><code>Error while compiling statement: FAILED: ParseException line 1:12 missing KW_ROLE at 'hivevar' near 'hivevar' line 1:19 missing EOF at ':' near 'hivevar'.
  </code></pre>
  
  <p>Can anyone tell me what this error message means or even what the KW_ROLE statement means?</p>