PageRenderTime 45ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out

#
text | 156 lines | 156 code | 0 blank | 0 comment | 0 complexity | 810cbbc88ba88bc3625796b17ca531b3 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@partition_test_partitioned
    6. 

  6. PREHOOK: query: insert overwrite table partition_test_partitioned partition(dt=100) select * from src1
    7. 

  7. PREHOOK: type: QUERY
    8. 

  8. PREHOOK: Input: default@src1
    9. 

  9. PREHOOK: Output: default@partition_test_partitioned@dt=100
    10. 

  10. POSTHOOK: query: insert overwrite table partition_test_partitioned partition(dt=100) select * from src1
    11. 

  11. POSTHOOK: type: QUERY
    12. 

  12. POSTHOOK: Input: default@src1
    13. 

  13. POSTHOOK: Output: default@partition_test_partitioned@dt=100
    14. 

  14. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    15. 

  15. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    16. 

  16. PREHOOK: query: alter table partition_test_partitioned set fileformat rcfile
    17. 

  17. PREHOOK: type: ALTERTABLE_FILEFORMAT
    18. 

  18. PREHOOK: Input: default@partition_test_partitioned
    19. 

  19. PREHOOK: Output: default@partition_test_partitioned
    20. 

  20. POSTHOOK: query: alter table partition_test_partitioned set fileformat rcfile
    21. 

  21. POSTHOOK: type: ALTERTABLE_FILEFORMAT
    22. 

  22. POSTHOOK: Input: default@partition_test_partitioned
    23. 

  23. POSTHOOK: Output: default@partition_test_partitioned
    24. 

  24. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    25. 

  25. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    26. 

  26. PREHOOK: query: insert overwrite table partition_test_partitioned partition(dt=101) select * from src1
    27. 

  27. PREHOOK: type: QUERY
    28. 

  28. PREHOOK: Input: default@src1
    29. 

  29. PREHOOK: Output: default@partition_test_partitioned@dt=101
    30. 

  30. POSTHOOK: query: insert overwrite table partition_test_partitioned partition(dt=101) select * from src1
    31. 

  31. POSTHOOK: type: QUERY
    32. 

  32. POSTHOOK: Input: default@src1
    33. 

  33. POSTHOOK: Output: default@partition_test_partitioned@dt=101
    34. 

  34. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    35. 

  35. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    36. 

  36. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    37. 

  37. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    38. 

  38. PREHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
    39. 

  39. PREHOOK: type: ALTERTABLE_FILEFORMAT
    40. 

  40. PREHOOK: Input: default@partition_test_partitioned
    41. 

  41. PREHOOK: Output: default@partition_test_partitioned
    42. 

  42. POSTHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
    43. 

  43. POSTHOOK: type: ALTERTABLE_FILEFORMAT
    44. 

  44. POSTHOOK: Input: default@partition_test_partitioned
    45. 

  45. POSTHOOK: Output: default@partition_test_partitioned
    46. 

  46. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    47. 

  47. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    48. 

  48. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    49. 

  49. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    50. 

  50. PREHOOK: query: insert overwrite table partition_test_partitioned partition(dt=102) select * from src1
    51. 

  51. PREHOOK: type: QUERY
    52. 

  52. PREHOOK: Input: default@src1
    53. 

  53. PREHOOK: Output: default@partition_test_partitioned@dt=102
    54. 

  54. POSTHOOK: query: insert overwrite table partition_test_partitioned partition(dt=102) select * from src1
    55. 

  55. POSTHOOK: type: QUERY
    56. 

  56. POSTHOOK: Input: default@src1
    57. 

  57. POSTHOOK: Output: default@partition_test_partitioned@dt=102
    58. 

  58. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    59. 

  59. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    60. 

  60. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    61. 

  61. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    62. 

  62. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    63. 

  63. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    64. 

  64. PREHOOK: query: select * from partition_test_partitioned where dt >=100 and dt <= 102
    65. 

  65. PREHOOK: type: QUERY
    66. 

  66. PREHOOK: Input: default@partition_test_partitioned@dt=100
    67. 

  67. PREHOOK: Input: default@partition_test_partitioned@dt=101
    68. 

  68. PREHOOK: Input: default@partition_test_partitioned@dt=102
    69. 

  69. PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-43_260_5442200232343655466/-mr-10000
    70. 

  70. POSTHOOK: query: select * from partition_test_partitioned where dt >=100 and dt <= 102
    71. 

  71. POSTHOOK: type: QUERY
    72. 

  72. POSTHOOK: Input: default@partition_test_partitioned@dt=100
    73. 

  73. POSTHOOK: Input: default@partition_test_partitioned@dt=101
    74. 

  74. POSTHOOK: Input: default@partition_test_partitioned@dt=102
    75. 

  75. POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-43_260_5442200232343655466/-mr-10000
    76. 

  76. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    77. 

  77. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    78. 

  78. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    79. 

  79. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    80. 

  80. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
    81. 

  81. POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
    82. 

  82. 238	val_238	100
    83. 

  83. 		100
    84. 

  84. 311	val_311	100
    85. 

  85. 	val_27	100
    86. 

  86. 	val_165	100
    87. 

  87. 	val_409	100
    88. 

  88. 255	val_255	100
    89. 

  89. 278	val_278	100
    90. 

  90. 98	val_98	100
    91. 

  91. 	val_484	100
    92. 

  92. 	val_265	100
    93. 

  93. 	val_193	100
    94. 

  94. 401	val_401	100
    95. 

  95. 150	val_150	100
    96. 

  96. 273	val_273	100
    97. 

  97. 224		100
    98. 

  98. 369		100
    99. 

  99. 66	val_66	100
    100. 

  100. 128		100
    101. 

  101. 213	val_213	100
    102. 

  102. 146	val_146	100
    103. 

  103. 406	val_406	100
    104. 

  104. 		100
    105. 

  105. 		100
    106. 

  106. 		100
    107. 

  107. 238	val_238	101
    108. 

  108. 		101
    109. 

  109. 311	val_311	101
    110. 

  110. 	val_27	101
    111. 

  111. 	val_165	101
    112. 

  112. 	val_409	101
    113. 

  113. 255	val_255	101
    114. 

  114. 278	val_278	101
    115. 

  115. 98	val_98	101
    116. 

  116. 	val_484	101
    117. 

  117. 	val_265	101
    118. 

  118. 	val_193	101
    119. 

  119. 401	val_401	101
    120. 

  120. 150	val_150	101
    121. 

  121. 273	val_273	101
    122. 

  122. 224		101
    123. 

  123. 369		101
    124. 

  124. 66	val_66	101
    125. 

  125. 128		101
    126. 

  126. 213	val_213	101
    127. 

  127. 146	val_146	101
    128. 

  128. 406	val_406	101
    129. 

  129. 		101
    130. 

  130. 		101
    131. 

  131. 		101
    132. 

  132. 238	val_238	102
    133. 

  133. 		102
    134. 

  134. 311	val_311	102
    135. 

  135. 	val_27	102
    136. 

  136. 	val_165	102
    137. 

  137. 	val_409	102
    138. 

  138. 255	val_255	102
    139. 

  139. 278	val_278	102
    140. 

  140. 98	val_98	102
    141. 

  141. 	val_484	102
    142. 

  142. 	val_265	102
    143. 

  143. 	val_193	102
    144. 

  144. 401	val_401	102
    145. 

  145. 150	val_150	102
    146. 

  146. 273	val_273	102
    147. 

  147. 224		102
    148. 

  148. 369		102
    149. 

  149. 66	val_66	102
    150. 

  150. 128		102
    151. 

  151. 213	val_213	102
    152. 

  152. 146	val_146	102
    153. 

  153. 406	val_406	102
    154. 

  154. 		102
    155. 

  155. 		102
    156. 

  156. 		102
    157. 

  157.