Were you able to load non-partitioned table?
________________________________ From: Yongqiang He <[email protected]> Reply-To: <[email protected]> Date: Sun, 8 Feb 2009 23:04:17 -0800 To: <[email protected]> Subject: Error with partition Hi,all I am trying to run a simple tutorial example with partition. But one error occurs. What this error means? hive>CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING); hive> LOAD DATA LOCAL INPATH 'hive/data/files/kv3.txt' OVERWRITE INTO TABLE invites partition(ds='2008'); FAILED: Error in semantic analysis: line 2:99 Exception while processing '2008': com.facebook.thrift.TApplicationException: get_partition failed: unknown result Time taken: 0.059 seconds And at the remote metastore server side, it prints: 09/02/09 13:35:13 INFO metastore.HiveMetaStore: 3: get_table : db=default tbl=invites 09/02/09 13:35:13 INFO metastore.HiveMetaStore: 3: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 09/02/09 13:35:13 INFO metastore.ObjectStore: ObjectStore, initialize called 09/02/09 13:35:13 INFO metastore.ObjectStore: Initialized ObjectStore 09/02/09 13:35:13 INFO metastore.HiveMetaStore: 4: get_partition : db=default tbl=invites 09/02/09 13:35:13 INFO metastore.HiveMetaStore: 4: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 09/02/09 13:35:13 INFO metastore.ObjectStore: ObjectStore, initialize called 09/02/09 13:35:13 INFO metastore.ObjectStore: Initialized ObjectStore -- Best regards! He Yongqiang Email: [email protected] Tel: 86-10-62600969(O) Fax：86-10-626000900 Key Laboratory of Network Science and Technology/ Research Center for Grid and Service Computing, Institute of Computing Technology, Chinese Academy of Sciences, No.3 Kexueyuan South Road, Beijing 100190, China
