[HIVE-2307] Schema creation scripts for PostgreSQL use bit(1) instead of boolean

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.5.0, 0.6.0, 0.7.0, 0.7.1
• Fix Version/s: 0.8.0
• Component/s: Configuration, Metastore
• Labels: metastore postgres
• Hadoop Flags: Reviewed
• Assignee: Esteban Gutierrez
• Reporter: Esteban Gutierrez
• Created: 26/Jul/11 05:38
• Updated: 16/Dec/11 23:56
• Resolved: 28/Jul/11 21:18

Description

The specified type for DEFERRED_REBUILD (IDXS) and IS_COMPRESSED (SDS) columns in the metastore is defined as bit(1) type which is not supported by PostgreSQL JDBC.

hive> create table test (id int);
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@4f1adeb7" using statement "INSERT INTO "SDS" ("SD_ID","INPUT_FORMAT","OUTPUT_FORMAT","LOCATION","SERDE_ID","NUM_BUCKETS","IS_COMPRESSED") VALUES (?,?,?,?,?,?,?)" failed : ERROR: column "IS_COMPRESSED" is of type bit but expression is of type boolean

Issue Links

• is a clone of: HIVE-2176 Schema creation scripts are incomplete since they leave out tables that are specific to DataNucleus