Hive optimiser seems not to use for a covered query

Hi, I am very new to hive optimiser Here I have a table with 4 million rows imported from Oracle via sqoop/hive. In this table object_id column is unique. Oracle table has primary key constraint on object_id column which is basically a unique B-tree index. I do a very simple query to

Re: Hive optimiser seems not to use for a covered query

Hive's optimizer never uses the indexes. Indexes aren't fully implemented in Hive. Alan. Mich Talebzadeh mailto:m...@peridale.co.uk March 27, 2015 at 1:33