title: How to declare and use variable in Hive SQL?
body: <p>I am using below syntax to declare and use variable in hive sql query. But it gives me an error as below</p>
  <pre><code>SET aa='10';
  
  SELECT
  col1 as data,
  ${aa} as myVar from myTable;
  </code></pre>
  <p>ERROR:
  org.apache.hive.service.cli.HiveSQLException: Error while processing statement: Cannot modify aa at runtime. It is not in list of params that are allowed to be modified at runtime</p>
  <p>I have also tried using hiveconf</p>
  <pre><code>SELECT ${hiveconf:aa} from myTable;
  </code></pre>