Hi,
I have a table and index that look like
<snip>
CREATE TABLE table_t1(id1 int, id2 int)
CREATE INDEX table_t1_idx ON TABLE table_t1(id1) AS
'org.apache.hadoop.hive.ql.index.AggregateIndexHandler' WITH DEFERRED
REBUILD IDXPROPERTIES("AGGREGATES"="count(id2)");
ALTER INDEX table_t1_idx ON table_t1 REBUILD;
</snip>
Now, I am seeing 2 problems with the query 'set
hive.optimize.index.groupby=false;select count(id2) from table_t1
group by id1',
firstly,
<snip>
FAILED: Error in semantic analysis: Line 1:11 Invalid table alias or
column reference '`_count_Of_id2`': (possible column names are: id1,
_bucketname, _offsets, _count_of_id2)
</snip>
So, I assumed that it was a typo or something, and I change all 'Of'
to 'of' in the relevant places in the code.
Then I ran the query again, with the option set to true and then to
false, the run times were almost the same. Also 'explain' on the
queries show identical query plans.
I am using hive revision 1172989 from trunk
Could someone help me with this?
Regards,
--
Rohan Monga
