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
