It seems this error is caused by the remote metastore part? I tried the same operations with default metastore setting(embedded derby db), and no error occurred.
On 09-2-10 上午9:40, "He Yongqiang" <[email protected]> wrote: > Yes, it can be correctly loaded with non partitioned table. > > hive/data/files/kv3.txt is shipped with hive. it has the following pattern: > 38^Aval_238 > ....... > > On 09-2-10 上午2:57, "Prasad Chakka" <[email protected]> wrote: > >> 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 >> >> >> -- 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
