Ok,I will try it when I get lab this morning. 7 hours later :(
On 09-2-11 上午1:50, "Prasad Chakka" <[email protected]> wrote: > 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
