Hi, This query is with reference to the Indexing patch mentioned in the following link.
https://issues.apache.org/jira/browse/HIVE-678 I applied the patch (hive-678-2009-07-25) on the Hive revision 796926 and built the code. Thereafter, created a small table pokes with two fields foo and bar and also created index on this table with type projection as follows. hive>CREATE TABLE pokes(foo int , bar string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; hive>CREATE INDEX pokes_index1 TYPE PROJECTION ON TABLE pokes1(foo,bar); OK Time taken: 0.159 seconds hive> select a.* from pokes_index1 a; OK Time taken: 0.073 seconds As seen in the last query, I am not able to see the contents of index. Is there any way to see the contents of index table? Secondly, three kinds of indexes have been mentioned in the link namely, Projection, Summary and Compact. Could somebody explain the scenarions in which we can use them. DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
