PREHOOK: query: create table exim_employee (emp_id int comment 'employee id', emp_name string, emp_dob string comment 'employee date of birth', emp_sex string comment 'M/F') comment 'employee table' partitioned by (emp_country string comment '2-char code', emp_state string comment '2-char code') clustered by (emp_sex) sorted by (emp_id ASC) into 10 buckets row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" with serdeproperties ('serialization.format'='1') stored as rcfile PREHOOK: type: CREATETABLE POSTHOOK: query: create table exim_employee (emp_id int comment 'employee id', emp_name string, emp_dob string comment 'employee date of birth', emp_sex string comment 'M/F') comment 'employee table' partitioned by (emp_country string comment '2-char code', emp_state string comment '2-char code') clustered by (emp_sex) sorted by (emp_id ASC) into 10 buckets row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" with serdeproperties ('serialization.format'='1') stored as rcfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@exim_employee PREHOOK: query: alter table exim_employee add partition (emp_country='in', emp_state='tn') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@exim_employee POSTHOOK: query: alter table exim_employee add partition (emp_country='in', emp_state='tn') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee@emp_country=in/emp_state=tn PREHOOK: query: alter table exim_employee add columns (emp_dept int) PREHOOK: type: ALTERTABLE_ADDCOLS PREHOOK: Input: default@exim_employee PREHOOK: Output: default@exim_employee POSTHOOK: query: alter table exim_employee add columns (emp_dept int) POSTHOOK: type: ALTERTABLE_ADDCOLS POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee PREHOOK: query: alter table exim_employee set serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" with serdeproperties ('serialization.format'='2') PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: default@exim_employee PREHOOK: Output: default@exim_employee POSTHOOK: query: alter table exim_employee set serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" with serdeproperties ('serialization.format'='2') POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee PREHOOK: query: alter table exim_employee set fileformat inputformat "org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat" outputformat "org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat" PREHOOK: type: ALTERTABLE_FILEFORMAT PREHOOK: Input: default@exim_employee PREHOOK: Output: default@exim_employee POSTHOOK: query: alter table exim_employee set fileformat inputformat "org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat" outputformat "org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat" POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee PREHOOK: query: alter table exim_employee clustered by (emp_sex, emp_dept) sorted by (emp_id desc) into 5 buckets PREHOOK: type: ALTERTABLE_CLUSTER_SORT PREHOOK: Input: default@exim_employee PREHOOK: Output: default@exim_employee POSTHOOK: query: alter table exim_employee clustered by (emp_sex, emp_dept) sorted by (emp_id desc) into 5 buckets POSTHOOK: type: ALTERTABLE_CLUSTER_SORT POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee PREHOOK: query: alter table exim_employee add partition (emp_country='in', emp_state='ka') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@exim_employee POSTHOOK: query: alter table exim_employee add partition (emp_country='in', emp_state='ka') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee@emp_country=in/emp_state=ka PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee' PREHOOK: type: EXPORT PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee' POSTHOOK: type: EXPORT POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_employee PREHOOK: query: drop table exim_employee PREHOOK: type: DROPTABLE PREHOOK: Input: default@exim_employee PREHOOK: Output: default@exim_employee POSTHOOK: query: drop table exim_employee POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee PREHOOK: query: create database importer PREHOOK: type: CREATEDATABASE POSTHOOK: query: create database importer POSTHOOK: type: CREATEDATABASE PREHOOK: query: use importer PREHOOK: type: SWITCHDATABASE POSTHOOK: query: use importer POSTHOOK: type: SWITCHDATABASE PREHOOK: query: import from 'ql/test/data/exports/exim_employee' PREHOOK: type: IMPORT POSTHOOK: query: import from 'ql/test/data/exports/exim_employee' POSTHOOK: type: IMPORT POSTHOOK: Output: importer@exim_employee POSTHOOK: Output: importer@exim_employee@emp_country=in/emp_state=ka POSTHOOK: Output: importer@exim_employee@emp_country=in/emp_state=tn PREHOOK: query: describe extended exim_employee PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended exim_employee POSTHOOK: type: DESCTABLE emp_id int from deserializer emp_name string from deserializer emp_dob string from deserializer emp_sex string from deserializer emp_dept int from deserializer emp_country string 2-char code emp_state string 2-char code Detailed Table Information Table(tableName:exim_employee, dbName:importer, owner:krishnak, createTime:1297311791, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:emp_id, type:int, comment:from deserializer), FieldSchema(name:emp_name, type:string, comment:from deserializer), FieldSchema(name:emp_dob, type:string, comment:from deserializer), FieldSchema(name:emp_sex, type:string, comment:from deserializer), FieldSchema(name:emp_dept, type:int, comment:from deserializer)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee, inputFormat:org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:5, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe, parameters:{serialization.format=2}), bucketCols:[emp_sex, emp_dept], sortCols:[Order(col:emp_id, order:0)], parameters:{}), partitionKeys:[FieldSchema(name:emp_country, type:string, comment:2-char code), FieldSchema(name:emp_state, type:string, comment:2-char code)], parameters:{last_modified_by=krishnak, last_modified_time=1297311789, transient_lastDdlTime=1297311791, comment=employee table}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: describe extended exim_employee partition (emp_country='in', emp_state='tn') PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended exim_employee partition (emp_country='in', emp_state='tn') POSTHOOK: type: DESCTABLE emp_id int from deserializer emp_name string from deserializer emp_dob string from deserializer emp_sex string from deserializer emp_dept int from deserializer emp_country string 2-char code emp_state string 2-char code Detailed Partition Information Partition(values:[in, tn], dbName:importer, tableName:exim_employee, createTime:1297311791, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:emp_id, type:int, comment:employee id), FieldSchema(name:emp_name, type:string, comment:), FieldSchema(name:emp_dob, type:string, comment:employee date of birth), FieldSchema(name:emp_sex, type:string, comment:M/F)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee/emp_country=in/emp_state=tn, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:10, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[emp_sex], sortCols:[Order(col:emp_id, order:1)], parameters:{}), parameters:{transient_lastDdlTime=1297311791}) PREHOOK: query: describe extended exim_employee partition (emp_country='in', emp_state='ka') PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended exim_employee partition (emp_country='in', emp_state='ka') POSTHOOK: type: DESCTABLE emp_id int from deserializer emp_name string from deserializer emp_dob string from deserializer emp_sex string from deserializer emp_dept int from deserializer emp_country string 2-char code emp_state string 2-char code Detailed Partition Information Partition(values:[in, ka], dbName:importer, tableName:exim_employee, createTime:1297311791, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:emp_id, type:int, comment:from deserializer), FieldSchema(name:emp_name, type:string, comment:from deserializer), FieldSchema(name:emp_dob, type:string, comment:from deserializer), FieldSchema(name:emp_sex, type:string, comment:from deserializer), FieldSchema(name:emp_dept, type:int, comment:from deserializer)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee/emp_country=in/emp_state=ka, inputFormat:org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:5, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe, parameters:{serialization.format=2}), bucketCols:[emp_sex, emp_dept], sortCols:[Order(col:emp_id, order:0)], parameters:{}), parameters:{transient_lastDdlTime=1297311792}) PREHOOK: query: show table extended like exim_employee PREHOOK: type: SHOW_TABLESTATUS POSTHOOK: query: show table extended like exim_employee POSTHOOK: type: SHOW_TABLESTATUS tableName:exim_employee owner:krishnak location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_employee inputformat:org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat columns:struct columns { i32 emp_id, string emp_name, string emp_dob, string emp_sex, i32 emp_dept} partitioned:true partitionColumns:struct partition_columns { string emp_country, string emp_state} totalNumberFiles:0 totalFileSize:0 maxFileSize:0 minFileSize:0 lastAccessTime:0 lastUpdateTime:1297311791000 PREHOOK: query: select * from exim_employee PREHOOK: type: QUERY PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka PREHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-23-13_239_2893413516045547407/-mr-10000 POSTHOOK: query: select * from exim_employee POSTHOOK: type: QUERY POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=ka POSTHOOK: Input: importer@exim_employee@emp_country=in/emp_state=tn POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-02-09_20-23-13_239_2893413516045547407/-mr-10000 PREHOOK: query: drop table exim_employee PREHOOK: type: DROPTABLE PREHOOK: Input: importer@exim_employee PREHOOK: Output: importer@exim_employee POSTHOOK: query: drop table exim_employee POSTHOOK: type: DROPTABLE POSTHOOK: Input: importer@exim_employee POSTHOOK: Output: importer@exim_employee PREHOOK: query: drop database importer PREHOOK: type: DROPDATABASE POSTHOOK: query: drop database importer POSTHOOK: type: DROPDATABASE