Create Hive index on complex column
<p>It is possible to create an index on a complex column in hive. Complex as in map, struct, array, etc. columns.</p>

<p>Example:</p>

<pre><code>CREATE TABLE employees (
  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);
</code></pre>

<p>The following does not seem to work:</p>

<pre><code>CREATE INDEX employees_index
ON TABLE employees (address.street)
AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler'
WITH DEFERRED REBUILD;
</code></pre>

<p>FAILED: ParseException line 2:28 mismatched input '.' expecting ) near 'address' in create index statement</p>