Re: Can't drop table

[wd <wd...@wdicc.com>]

Seems I found the reason.

I'm try to upgrade my hive-0.5.0 to hive-0.7 today, and executed the sql in
upgrade directory, migrate conf to new hive. Then found that can't drop
table again.

When drop a table, I found there is a connection from hive try to do
something on "IDXS" table in  postgress, and hung at this sql.

 16385 | hive_metadb |    8259 |    16386 | hive    | ALTER TABLE "IDXS" ADD
CONSTRAINT "IDXS_FK1" FOREIGN KEY ("SD_ID") REFERENCES "SDS" (
"SD_ID") INITIALLY DEFERRED  | t       | 2011-04-28 13:54:16.384769+08 |
2011-04-28 13:54:16.404204+08 | 2011-04-28 13:54:01.784839+08 | 12
7.0.0.1   |       37438

But there is no table named "IDXS" exists. So I think this problem is cased
by these missing tables. Then I migrate a upgrade sql file from mysql, and
upgrade my postgress, the problem solved.

The attachment is the upgrade SQLs to run.

2011/1/6 wd <wd...@wdicc.com>

> hi,
>
> I've setup a single node hadoop and hive. And can create table in hive, but
> can't drop table, hive cli will hang there, nothing more infos.
>
> hive-0.6.0-bin
> hadoop-0.20.2
> jre1.6.0_23
> postgresql-9.0-801.jdbc4.jar (have tried postgresql-8.4-701.jdbc4.jar)
> pgsql 9.0.2
>
> How to find what's wrong happed? thx.
>