/branches/branch-0.2/hive/external/ql/src/test/results/clientpositive/stats3.q.out

# · text · 150 lines · 149 code · 1 blank · 0 comment · 0 complexity · 59d36682bc3745541a6e32d7a06511fb MD5 · raw file 

    

  1. PREHOOK: query: drop table hive_test_src
    2. 

  2. PREHOOK: type: DROPTABLE
    3. 

  3. POSTHOOK: query: drop table hive_test_src
    4. 

  4. POSTHOOK: type: DROPTABLE
    5. 

  5. PREHOOK: query: drop table hive_test_dst
    6. 

  6. PREHOOK: type: DROPTABLE
    7. 

  7. POSTHOOK: query: drop table hive_test_dst
    8. 

  8. POSTHOOK: type: DROPTABLE
    9. 

  9. PREHOOK: query: create table hive_test_src ( col1 string ) stored as textfile
    10. 

  10. PREHOOK: type: CREATETABLE
    11. 

  11. POSTHOOK: query: create table hive_test_src ( col1 string ) stored as textfile
    12. 

  12. POSTHOOK: type: CREATETABLE
    13. 

  13. POSTHOOK: Output: default@hive_test_src
    14. 

  14. PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table hive_test_src
    15. 

  15. PREHOOK: type: LOAD
    16. 

  16. PREHOOK: Output: default@hive_test_src
    17. 

  17. POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table hive_test_src
    18. 

  18. POSTHOOK: type: LOAD
    19. 

  19. POSTHOOK: Output: default@hive_test_src
    20. 

  20. PREHOOK: query: create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as sequencefile
    21. 

  21. PREHOOK: type: CREATETABLE
    22. 

  22. POSTHOOK: query: create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as sequencefile
    23. 

  23. POSTHOOK: type: CREATETABLE
    24. 

  24. POSTHOOK: Output: default@hive_test_dst
    25. 

  25. PREHOOK: query: insert overwrite table hive_test_dst partition ( pcol1='test_part', pCol2='test_Part') select col1 from hive_test_src
    26. 

  26. PREHOOK: type: QUERY
    27. 

  27. PREHOOK: Input: default@hive_test_src
    28. 

  28. PREHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    29. 

  29. POSTHOOK: query: insert overwrite table hive_test_dst partition ( pcol1='test_part', pCol2='test_Part') select col1 from hive_test_src
    30. 

  30. POSTHOOK: type: QUERY
    31. 

  31. POSTHOOK: Input: default@hive_test_src
    32. 

  32. POSTHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    33. 

  33. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    34. 

  34. PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part'
    35. 

  35. PREHOOK: type: QUERY
    36. 

  36. PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    37. 

  37. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_652_6586721606321003478/-mr-10000
    38. 

  38. POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part'
    39. 

  39. POSTHOOK: type: QUERY
    40. 

  40. POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    41. 

  41. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_652_6586721606321003478/-mr-10000
    42. 

  42. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    43. 

  43. 1	test_part	test_Part
    44. 

  44. 2	test_part	test_Part
    45. 

  45. 3	test_part	test_Part
    46. 

  46. 4	test_part	test_Part
    47. 

  47. 5	test_part	test_Part
    48. 

  48. 6	test_part	test_Part
    49. 

  49. PREHOOK: query: select count(1) from hive_test_dst
    50. 

  50. PREHOOK: type: QUERY
    51. 

  51. PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    52. 

  52. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_776_220190187790387003/-mr-10000
    53. 

  53. POSTHOOK: query: select count(1) from hive_test_dst
    54. 

  54. POSTHOOK: type: QUERY
    55. 

  55. POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    56. 

  56. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-28_776_220190187790387003/-mr-10000
    57. 

  57. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    58. 

  58. 6
    59. 

  59. PREHOOK: query: insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src
    60. 

  60. PREHOOK: type: QUERY
    61. 

  61. PREHOOK: Input: default@hive_test_src
    62. 

  62. PREHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    63. 

  63. POSTHOOK: query: insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src
    64. 

  64. POSTHOOK: type: QUERY
    65. 

  65. POSTHOOK: Input: default@hive_test_src
    66. 

  66. POSTHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    67. 

  67. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    68. 

  68. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    69. 

  69. PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
    70. 

  70. PREHOOK: type: QUERY
    71. 

  71. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_044_8444747323785684087/-mr-10000
    72. 

  72. POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
    73. 

  73. POSTHOOK: type: QUERY
    74. 

  74. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_044_8444747323785684087/-mr-10000
    75. 

  75. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    76. 

  76. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    77. 

  77. PREHOOK: query: select count(1) from hive_test_dst
    78. 

  78. PREHOOK: type: QUERY
    79. 

  79. PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    80. 

  80. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_081_7812855910433487408/-mr-10000
    81. 

  81. POSTHOOK: query: select count(1) from hive_test_dst
    82. 

  82. POSTHOOK: type: QUERY
    83. 

  83. POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    84. 

  84. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-36_081_7812855910433487408/-mr-10000
    85. 

  85. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    86. 

  86. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    87. 

  87. 6
    88. 

  88. PREHOOK: query: select * from hive_test_dst where pcol1='test_part'
    89. 

  89. PREHOOK: type: QUERY
    90. 

  90. PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    91. 

  91. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_072_3368639497562855026/-mr-10000
    92. 

  92. POSTHOOK: query: select * from hive_test_dst where pcol1='test_part'
    93. 

  93. POSTHOOK: type: QUERY
    94. 

  94. POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part
    95. 

  95. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_072_3368639497562855026/-mr-10000
    96. 

  96. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    97. 

  97. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    98. 

  98. 1	test_part	test_Part
    99. 

  99. 2	test_part	test_Part
    100. 

  100. 3	test_part	test_Part
    101. 

  101. 4	test_part	test_Part
    102. 

  102. 5	test_part	test_Part
    103. 

  103. 6	test_part	test_Part
    104. 

  104. PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
    105. 

  105. PREHOOK: type: QUERY
    106. 

  106. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_191_1429175641027987882/-mr-10000
    107. 

  107. POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'
    108. 

  108. POSTHOOK: type: QUERY
    109. 

  109. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_191_1429175641027987882/-mr-10000
    110. 

  110. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    111. 

  111. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    112. 

  112. PREHOOK: query: select * from hive_test_dst where pcol1='test_Part'
    113. 

  113. PREHOOK: type: QUERY
    114. 

  114. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_229_5765689340005511689/-mr-10000
    115. 

  115. POSTHOOK: query: select * from hive_test_dst where pcol1='test_Part'
    116. 

  116. POSTHOOK: type: QUERY
    117. 

  117. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-22-39_229_5765689340005511689/-mr-10000
    118. 

  118. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    119. 

  119. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    120. 

  120. PREHOOK: query: describe extended hive_test_dst
    121. 

  121. PREHOOK: type: DESCTABLE
    122. 

  122. POSTHOOK: query: describe extended hive_test_dst
    123. 

  123. POSTHOOK: type: DESCTABLE
    124. 

  124. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    125. 

  125. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    126. 

  126. col1	string	
    127. 

  127. pcol1	string	
    128. 

  128. pcol2	string	
    129. 

  129. 	 	 
    130. 

  130. Detailed Table Information	Table(tableName:hive_test_dst, dbName:default, owner:krishnak, createTime:1300710144, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], location:pfile:/home/krishnak/hive-howl/hive-git-apache/build/ql/test/data/warehouse/hive_test_dst, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, 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:pcol1, type:string, comment:null), FieldSchema(name:pcol2, type:string, comment:null)], parameters:{numPartitions=1, numFiles=1, transient_lastDdlTime=1300710155, numRows=6, totalSize=171}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    131. 

  131. PREHOOK: query: drop table hive_test_src
    132. 

  132. PREHOOK: type: DROPTABLE
    133. 

  133. PREHOOK: Input: default@hive_test_src
    134. 

  134. PREHOOK: Output: default@hive_test_src
    135. 

  135. POSTHOOK: query: drop table hive_test_src
    136. 

  136. POSTHOOK: type: DROPTABLE
    137. 

  137. POSTHOOK: Input: default@hive_test_src
    138. 

  138. POSTHOOK: Output: default@hive_test_src
    139. 

  139. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    140. 

  140. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    141. 

  141. PREHOOK: query: drop table hive_test_dst
    142. 

  142. PREHOOK: type: DROPTABLE
    143. 

  143. PREHOOK: Input: default@hive_test_dst
    144. 

  144. PREHOOK: Output: default@hive_test_dst
    145. 

  145. POSTHOOK: query: drop table hive_test_dst
    146. 

  146. POSTHOOK: type: DROPTABLE
    147. 

  147. POSTHOOK: Input: default@hive_test_dst
    148. 

  148. POSTHOOK: Output: default@hive_test_dst
    149. 

  149. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    150. 

  150. POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ]
    151.