Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Trouble creating indexes with psql metastore


Copy link to this message
-
Re: Trouble creating indexes with psql metastore
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 <[EMAIL PROTECTED]>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. ****
>
> ** **
>
> ** **
>