hive> show tables; OK Time taken: 0.049 seconds hive> describe extended srcpart; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask hive> create table srcpart(key string, value string) partitioned by (ds string, hr int); OK Time taken: 0.201 seconds hive> describe extended srcpart; OK key string value string ds string hr int Detailed Table Information Table(tableName:srcpart, dbName:default, owner:char, createTime:1248419245, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/user/hive/warehouse/srcpart, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:int, comment:null)], parameters:{}) File System Information total number of files:0, total files size:0, max file size:0, min file size:0, last access time:0, last update time:1248418199000 Time taken: 0.083 seconds hive> describe extended srcpart partition(ds='2008-04-08', hr=12); FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask hive> load data local inpath "/Users/char/Documents/workspace/Hive-Clean/data/files/kv1_cb.txt" into table srcpart PARTITION(ds='2008-04-08', hr=12); Copying data from file:/Users/char/Documents/workspace/Hive-Clean/data/files/kv1_cb.txt Loading data to table srcpart partition {ds=2008-04-08, hr=12} OK Time taken: 0.262 seconds hive> load data local inpath "/Users/char/Documents/workspace/Hive-Clean/data/files/kv1_cb.txt" into table srcpart PARTITION(ds='2008-04-08', hr=12); Copying data from file:/Users/char/Documents/workspace/Hive-Clean/data/files/kv1_cb.txt Loading data to table srcpart partition {ds=2008-04-08, hr=12} Failed with exception checkPaths: file:/user/hive/warehouse/srcpart/ds=2008-04-08/hr=12/kv1_cb.txt already exists FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask hive> describe extended srcpart partition(ds='2008-04-08', hr=12); OK key string value string ds string hr int Detailed Partition Information Partition(values:[2008-04-08, 12], dbName:default, tableName:srcpart, createTime:0, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/user/hive/warehouse/srcpart/ds=2008-04-08/hr=12, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{}) File System Information total number of files:1, total files size:5812, max file size:5812, min file size:5812, last access time:0, last update time:1248419280000 Time taken: 0.088 seconds hive> load data local inpath "/Users/char/Documents/workspace/Hive-Clean/data/files/kv1.txt" into table srcpart PARTITION(ds='2008-04-08', hr=12); Copying data from file:/Users/char/Documents/workspace/Hive-Clean/data/files/kv1.txt Loading data to table srcpart partition {ds=2008-04-08, hr=12} OK Time taken: 0.14 seconds hive> describe extended srcpart partition(ds='2008-04-08', hr=12); OK key string value string ds string hr int Detailed Partition Information Partition(values:[2008-04-08, 12], dbName:default, tableName:srcpart, createTime:0, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/user/hive/warehouse/srcpart/ds=2008-04-08/hr=12, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{}) File System Information total number of files:2, total files size:11624, max file size:5812, min file size:5812, last access time:0, last update time:1248419318000 Time taken: 0.082 seconds hive> dfs -rmr file:/user/hive/warehouse/srcpart/ds=2008-04-08 > ; Deleted file:/user/hive/warehouse/srcpart/ds=2008-04-08 hive> describe extended srcpart partition(ds='2008-04-08', hr=12); OK key string value string ds string hr int Detailed Partition Information Partition(values:[2008-04-08, 12], dbName:default, tableName:srcpart, createTime:0, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/user/hive/warehouse/srcpart/ds=2008-04-08/hr=12, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{}) File System Information error:File file:/user/hive/warehouse/srcpart/ds=2008-04-08/hr=12 does not exist. Time taken: 0.121 seconds hive> describe extended srcpart; OK key string value string ds string hr int Detailed Table Information Table(tableName:srcpart, dbName:default, owner:char, createTime:1248419245, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/user/hive/warehouse/srcpart, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:int, comment:null)], parameters:{}) File System Information total number of files:0, total files size:0, max file size:0, min file size:0, last access time:0, last update time:1248419491000 Time taken: 0.106 seconds