PageRenderTime 20ms CodeModel.GetById 16ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out

#
text | 103 lines | 102 code | 1 blank | 0 comment | 0 complexity | 36a29b6dc9ade6e41c69b4e25828f64f MD5 | raw file
  1PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
  2	stored as textfile	
  3	tblproperties("creator"="krishna")
  4PREHOOK: type: CREATETABLE
  5POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
  6	stored as textfile	
  7	tblproperties("creator"="krishna")
  8POSTHOOK: type: CREATETABLE
  9POSTHOOK: Output: default@exim_department
 10PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
 11PREHOOK: type: LOAD
 12PREHOOK: Output: default@exim_department
 13POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
 14POSTHOOK: type: LOAD
 15POSTHOOK: Output: default@exim_department
 16PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
 17PREHOOK: type: EXPORT
 18PREHOOK: Input: default@exim_department
 19PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
 20POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
 21POSTHOOK: type: EXPORT
 22POSTHOOK: Input: default@exim_department
 23POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
 24PREHOOK: query: drop table exim_department
 25PREHOOK: type: DROPTABLE
 26PREHOOK: Input: default@exim_department
 27PREHOOK: Output: default@exim_department
 28POSTHOOK: query: drop table exim_department
 29POSTHOOK: type: DROPTABLE
 30POSTHOOK: Input: default@exim_department
 31POSTHOOK: Output: default@exim_department
 32PREHOOK: query: create database importer
 33PREHOOK: type: CREATEDATABASE
 34POSTHOOK: query: create database importer
 35POSTHOOK: type: CREATEDATABASE
 36PREHOOK: query: use importer
 37PREHOOK: type: SWITCHDATABASE
 38POSTHOOK: query: use importer
 39POSTHOOK: type: SWITCHDATABASE
 40PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
 41	partitioned by (emp_org string)
 42	stored as textfile	
 43	tblproperties("creator"="krishna")
 44PREHOOK: type: CREATETABLE
 45POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
 46	partitioned by (emp_org string)
 47	stored as textfile	
 48	tblproperties("creator"="krishna")
 49POSTHOOK: type: CREATETABLE
 50POSTHOOK: Output: importer@exim_department
 51PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department partition (emp_org="hr")
 52PREHOOK: type: LOAD
 53PREHOOK: Output: importer@exim_department
 54POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department partition (emp_org="hr")
 55POSTHOOK: type: LOAD
 56POSTHOOK: Output: importer@exim_department
 57POSTHOOK: Output: importer@exim_department@emp_org=hr
 58PREHOOK: query: import table exim_imported_dept from 'ql/test/data/exports/exim_department'
 59PREHOOK: type: IMPORT
 60POSTHOOK: query: import table exim_imported_dept from 'ql/test/data/exports/exim_department'
 61POSTHOOK: type: IMPORT
 62POSTHOOK: Output: importer@exim_imported_dept
 63PREHOOK: query: describe extended exim_imported_dept
 64PREHOOK: type: DESCTABLE
 65POSTHOOK: query: describe extended exim_imported_dept
 66POSTHOOK: type: DESCTABLE
 67dep_id	int	department id
 68	 	 
 69Detailed Table Information	Table(tableName:exim_imported_dept, dbName:importer, owner:krishnak, createTime:1300687478, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:dep_id, type:int, comment:department id)], location:pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/warehouse/importer.db/exim_imported_dept, 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:[], parameters:{transient_lastDdlTime=1300687478, creator=krishna}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
 70PREHOOK: query: select * from exim_imported_dept
 71PREHOOK: type: QUERY
 72PREHOOK: Input: importer@exim_imported_dept
 73PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-39_058_186230401741920612/-mr-10000
 74POSTHOOK: query: select * from exim_imported_dept
 75POSTHOOK: type: QUERY
 76POSTHOOK: Input: importer@exim_imported_dept
 77POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-39_058_186230401741920612/-mr-10000
 781
 792
 803
 814
 825
 836
 84PREHOOK: query: drop table exim_imported_dept
 85PREHOOK: type: DROPTABLE
 86PREHOOK: Input: importer@exim_imported_dept
 87PREHOOK: Output: importer@exim_imported_dept
 88POSTHOOK: query: drop table exim_imported_dept
 89POSTHOOK: type: DROPTABLE
 90POSTHOOK: Input: importer@exim_imported_dept
 91POSTHOOK: Output: importer@exim_imported_dept
 92PREHOOK: query: drop table exim_department
 93PREHOOK: type: DROPTABLE
 94PREHOOK: Input: importer@exim_department
 95PREHOOK: Output: importer@exim_department
 96POSTHOOK: query: drop table exim_department
 97POSTHOOK: type: DROPTABLE
 98POSTHOOK: Input: importer@exim_department
 99POSTHOOK: Output: importer@exim_department
100PREHOOK: query: drop database importer
101PREHOOK: type: DROPDATABASE
102POSTHOOK: query: drop database importer
103POSTHOOK: type: DROPDATABASE