Hi Clint, Indeed this is a bug, "DEFERRED_REBUILD" should be boolean and not bit(1) in "IDXS".
Regards, Esteban. -- Support Engineer, Cloudera. On Wed, Jun 22, 2011 at 11:25 AM, Clint Green <cgr...@data-tactics.com>wrote: > Dear Hive User List,**** > > ** ** > > I am trying to build indexes on a hive 0.7.1 environment using postgresql > as the metastore, but it is failing silently.**** > > ** ** > > The following command doesn’t generate any errors:**** > > ** ** > > hive> CREATE TABLE t (i INT);**** > > OK**** > > Time taken: 0.299 seconds**** > > hive> CREATE INDEX i ON TABLE t (i) with ‘COMPACT’ WITH DEFERRED REBUILD;* > *** > > OK**** > > Time taken: 0.287 seconds**** > > ** ** > > A directory is created for the index in “/usr/hive/warehouse/”, but the > index can’t be found:**** > > ** ** > > hive> show tables;**** > > OK**** > > t**** > > Time taken: 0.163 seconds**** > > hive> show indexes on t;**** > > OK**** > > Time taken: 0.303 seconds**** > > ** ** > > There are no errors in the hive.log file, and I am running the 0.7.1 > release.**** > > ** ** > > Thank you,**** > > Clint**** > > ** ** > > --**** > > The information contained in this message may be privileged and/or > confidential and protected from disclosure. If the reader of this message is > not the intended recipient or an employee or agent responsible for > delivering this message to the intended recipient, you are hereby notified > that any dissemination, distribution or copying of this communication is > strictly prohibited. If you have received this communication in error, > please notify the sender immediately by replying to this message and > deleting the material from any computer. **** > > ** ** > > ** ** >
