/branches/branch-0.2/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 

    

  1. PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
    2. 

  2. 	stored as textfile	
    3. 

  3. 	tblproperties("creator"="krishna")
    4. 

  4. PREHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
    6. 

  6. 	stored as textfile	
    7. 

  7. 	tblproperties("creator"="krishna")
    8. 

  8. POSTHOOK: type: CREATETABLE
    9. 

  9. POSTHOOK: Output: default@exim_department
    10. 

  10. PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
    11. 

  11. PREHOOK: type: LOAD
    12. 

  12. PREHOOK: Output: default@exim_department
    13. 

  13. POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department
    14. 

  14. POSTHOOK: type: LOAD
    15. 

  15. POSTHOOK: Output: default@exim_department
    16. 

  16. PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
    17. 

  17. PREHOOK: type: EXPORT
    18. 

  18. PREHOOK: Input: default@exim_department
    19. 

  19. PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
    20. 

  20. POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
    21. 

  21. POSTHOOK: type: EXPORT
    22. 

  22. POSTHOOK: Input: default@exim_department
    23. 

  23. POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department
    24. 

  24. PREHOOK: query: drop table exim_department
    25. 

  25. PREHOOK: type: DROPTABLE
    26. 

  26. PREHOOK: Input: default@exim_department
    27. 

  27. PREHOOK: Output: default@exim_department
    28. 

  28. POSTHOOK: query: drop table exim_department
    29. 

  29. POSTHOOK: type: DROPTABLE
    30. 

  30. POSTHOOK: Input: default@exim_department
    31. 

  31. POSTHOOK: Output: default@exim_department
    32. 

  32. PREHOOK: query: create database importer
    33. 

  33. PREHOOK: type: CREATEDATABASE
    34. 

  34. POSTHOOK: query: create database importer
    35. 

  35. POSTHOOK: type: CREATEDATABASE
    36. 

  36. PREHOOK: query: use importer
    37. 

  37. PREHOOK: type: SWITCHDATABASE
    38. 

  38. POSTHOOK: query: use importer
    39. 

  39. POSTHOOK: type: SWITCHDATABASE
    40. 

  40. PREHOOK: query: create table exim_department ( dep_id int comment "department id") 	
    41. 

  41. 	partitioned by (emp_org string)
    42. 

  42. 	stored as textfile	
    43. 

  43. 	tblproperties("creator"="krishna")
    44. 

  44. PREHOOK: type: CREATETABLE
    45. 

  45. POSTHOOK: query: create table exim_department ( dep_id int comment "department id") 	
    46. 

  46. 	partitioned by (emp_org string)
    47. 

  47. 	stored as textfile	
    48. 

  48. 	tblproperties("creator"="krishna")
    49. 

  49. POSTHOOK: type: CREATETABLE
    50. 

  50. POSTHOOK: Output: importer@exim_department
    51. 

  51. PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department partition (emp_org="hr")
    52. 

  52. PREHOOK: type: LOAD
    53. 

  53. PREHOOK: Output: importer@exim_department
    54. 

  54. POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department partition (emp_org="hr")
    55. 

  55. POSTHOOK: type: LOAD
    56. 

  56. POSTHOOK: Output: importer@exim_department
    57. 

  57. POSTHOOK: Output: importer@exim_department@emp_org=hr
    58. 

  58. PREHOOK: query: import table exim_imported_dept from 'ql/test/data/exports/exim_department'
    59. 

  59. PREHOOK: type: IMPORT
    60. 

  60. POSTHOOK: query: import table exim_imported_dept from 'ql/test/data/exports/exim_department'
    61. 

  61. POSTHOOK: type: IMPORT
    62. 

  62. POSTHOOK: Output: importer@exim_imported_dept
    63. 

  63. PREHOOK: query: describe extended exim_imported_dept
    64. 

  64. PREHOOK: type: DESCTABLE
    65. 

  65. POSTHOOK: query: describe extended exim_imported_dept
    66. 

  66. POSTHOOK: type: DESCTABLE
    67. 

  67. dep_id	int	department id
    68. 

  68. 	 	 
    69. 

  69. Detailed 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)	
    70. 

  70. PREHOOK: query: select * from exim_imported_dept
    71. 

  71. PREHOOK: type: QUERY
    72. 

  72. PREHOOK: Input: importer@exim_imported_dept
    73. 

  73. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-39_058_186230401741920612/-mr-10000
    74. 

  74. POSTHOOK: query: select * from exim_imported_dept
    75. 

  75. POSTHOOK: type: QUERY
    76. 

  76. POSTHOOK: Input: importer@exim_imported_dept
    77. 

  77. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-04-39_058_186230401741920612/-mr-10000
    78. 

  78. 1
    79. 

  79. 2
    80. 

  80. 3
    81. 

  81. 4
    82. 

  82. 5
    83. 

  83. 6
    84. 

  84. PREHOOK: query: drop table exim_imported_dept
    85. 

  85. PREHOOK: type: DROPTABLE
    86. 

  86. PREHOOK: Input: importer@exim_imported_dept
    87. 

  87. PREHOOK: Output: importer@exim_imported_dept
    88. 

  88. POSTHOOK: query: drop table exim_imported_dept
    89. 

  89. POSTHOOK: type: DROPTABLE
    90. 

  90. POSTHOOK: Input: importer@exim_imported_dept
    91. 

  91. POSTHOOK: Output: importer@exim_imported_dept
    92. 

  92. PREHOOK: query: drop table exim_department
    93. 

  93. PREHOOK: type: DROPTABLE
    94. 

  94. PREHOOK: Input: importer@exim_department
    95. 

  95. PREHOOK: Output: importer@exim_department
    96. 

  96. POSTHOOK: query: drop table exim_department
    97. 

  97. POSTHOOK: type: DROPTABLE
    98. 

  98. POSTHOOK: Input: importer@exim_department
    99. 

  99. POSTHOOK: Output: importer@exim_department
    100. 

  100. PREHOOK: query: drop database importer
    101. 

  101. PREHOOK: type: DROPDATABASE
    102. 

  102. POSTHOOK: query: drop database importer
    103. 

  103. POSTHOOK: type: DROPDATABASE
    104.