Re: Hive 0.7.1 does not work with PostgreSQL 9.0.2

2011-08-20 Thread Xiaobo Gu
thanks ,I change the DDL manually ,change bit to boolean ,it works , 2011/8/21, wd : > you can try hive 0.5, after create the metadata, use upgrade sql file > in hive 0.7.1 to upgrade to 0.7.1 > > On Sat, Aug 20, 2011 at 2:20 PM, Xiaobo Gu wrote: >> Hi, >> I have just set up a PostgreSQL 9.0.2

Re: Hive 0.7.1 does not work with PostgreSQL 9.0.2

2011-08-20 Thread wd
you can try hive 0.5, after create the metadata, use upgrade sql file in hive 0.7.1 to upgrade to 0.7.1 On Sat, Aug 20, 2011 at 2:20 PM, Xiaobo Gu wrote: > Hi, > I have just set up a PostgreSQL 9.0.2 server for hive 0.7.1 metastore, > and I am using the postgresql-9.0-801.jdbc4.jar jdbc driver, w

Hive 0.7.1 does not work with PostgreSQL 9.0.2

2011-08-19 Thread Xiaobo Gu
Hi, I have just set up a PostgreSQL 9.0.2 server for hive 0.7.1 metastore, and I am using the postgresql-9.0-801.jdbc4.jar jdbc driver, when I test the following HQL, CREATE TABLE records (year STRING, temperature INT, quality INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'; the following e