title: Hive query Error -- FAILED: Error in semantic analysis: Line 1:117 Invalid table alias or column reference state
body: <p>Getting this error</p>
  
  <pre><code>hive&gt; insert overwrite table employees_partition partition (country ='IND', State='HR') select * from employees_data where state = 'Haryana';     
  FAILED: Error in semantic analysis: Line 1:117 Invalid table alias or column reference state
  </code></pre>
  
  <p>My partitioned table structure is</p>
  
  <pre><code>CREATE TABLE employees_partition (
  name STRING,
  salary FLOAT,
  subordinates ARRAY&lt;STRING&gt;,
  deductions MAP&lt;STRING, FLOAT&gt;,
  address STRUCT&lt;street:STRING, city:STRING, state:STRING, zip:INT&gt;) PARTITIONED BY (country STRING, state STRING) 
  row format delimited fields terminated by ','
  collection items terminated by '$'
  map keys terminated by '#';
  </code></pre>