Hi Pradeep, partition definition need to be key-value pairs. partition key `action` seems missed the value.
Thanks Yongqiang On Wed, Jun 16, 2010 at 5:22 PM, Pradeep Kamath <[email protected]>wrote: > Hi, > > I am trying to create an external table against already existing data > in sequencefile format. However I have written a custom Serde to interpret > the data. I am able to create the table fine but get the exception shown in > the session output below when I try to add partition – any help would be > greatly appreciated. > > > > Thanks, > > Pradeep > > > > == session output === > > > > [prade...@chargesize:~/dev/howl]hive --auxpath ult-serde.jar -e "ALTER > TABLE mytable add partition(datestamp = '20091101', srcid = ‘10’,action) > location '/user/pradeepk/mytable/20091101/10’;" > > 10/06/16 17:08:59 WARN conf.Configuration: DEPRECATED: hadoop-site.xml > found in the classpath. Usage of hadoop-site.xml is deprecated. Instead use > core-site.xml, mapred-site.xml and hdfs-site.xml to override properties of > core-default.xml, mapred-default.xml and hdfs-default.xml respectively > > Hive history > file=/tmp/pradeepk/hive_job_log_pradeepk_201006161709_1934304805.txt > > *FAILED: Error in metadata: org.apache.thrift.TApplicationException: > get_partition failed: unknown result* > > *FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask* > > [prade...@chargesize:~/dev/howl] > > > > == session output === > > > > /tmp/pradeepk/hive.log has: > > 2010-06-16 17:09:00,841 ERROR exec.DDLTask > (SessionState.java:printError(269)) - FAILED: Error in metadata: > org.apache.thrift.TApplicationException: get_partition failed: unknown > result > > org.apache.hadoop.hive.ql.metadata.HiveException: > org.apache.thrift.TApplicationException: get_partition failed: unknown > result > > at org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:778) > > at > org.apache.hadoop.hive.ql.exec.DDLTask.addPartition(DDLTask.java:231) > > at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:150) > > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:631) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:504) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:382) > > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:138) > > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:197) > > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:268) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) > > *Caused by: org.apache.thrift.TApplicationException: get_partition failed: > unknown result* > > * at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_partition(ThriftHiveMetastore.java:931) > * > > * at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_partition(ThriftHiveMetastore.java:899) > * > > * at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getPartition(HiveMetaStoreClient.java:500) > * > > * at > org.apache.hadoop.hive.ql.metadata.Hive.getPartition(Hive.java:756)* > > * ... 15 more* > > > > The thrift server messages are: > > 10/06/16 17:09:00 INFO metastore.HiveMetaStore: 22: get_table : db=default > tbl=mytable > > 10/06/16 17:09:00 INFO metastore.HiveMetaStore: 22: Opening raw store with > implemenation class:org.apache.hadoop.hive.metastore.ObjectStore > > 10/06/16 17:09:00 INFO metastore.ObjectStore: ObjectStore, initialize > called > > 10/06/16 17:09:00 INFO metastore.ObjectStore: Initialized ObjectStore > > 10/06/16 17:09:00 INFO metastore.HiveMetaStore: 22: get_partition : > db=default tbl=mytable > > > > >
