Can you set the logging to debug level (in hms-log4j.properties) and try it out. I have not seen this error before.
________________________________ From: Yongqiang He <[email protected]> Reply-To: <[email protected]> Date: Mon, 9 Feb 2009 23:50:03 -0800 To: <[email protected]> Subject: Re: Error with partition 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
