PageRenderTime 75ms CodeModel.GetById 24ms RepoModel.GetById 2ms app.codeStats 0ms

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

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

  1. PREHOOK: query: CREATE table rcfileTableLazyDecompress (key STRING, value STRING) STORED AS RCFile
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE table rcfileTableLazyDecompress (key STRING, value STRING) STORED AS RCFile
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@rcfileTableLazyDecompress
    6. 

  6. PREHOOK: query: FROM src
    7. 

  7. INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
    8. 

  8. PREHOOK: type: QUERY
    9. 

  9. PREHOOK: Input: default@src
    10. 

  10. PREHOOK: Output: default@rcfiletablelazydecompress
    11. 

  11. POSTHOOK: query: FROM src
    12. 

  12. INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
    13. 

  13. POSTHOOK: type: QUERY
    14. 

  14. POSTHOOK: Input: default@src
    15. 

  15. POSTHOOK: Output: default@rcfiletablelazydecompress
    16. 

  16. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    17. 

  17. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    18. 

  18. PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
    19. 

  19. PREHOOK: type: QUERY
    20. 

  20. PREHOOK: Input: default@rcfiletablelazydecompress
    21. 

  21. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-26_308_5035766417306203353/10000
    22. 

  22. POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
    23. 

  23. POSTHOOK: type: QUERY
    24. 

  24. POSTHOOK: Input: default@rcfiletablelazydecompress
    25. 

  25. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-26_308_5035766417306203353/10000
    26. 

  26. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    27. 

  27. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    28. 

  28. 311	val_311
    29. 

  29. 409	val_409
    30. 

  30. 255	val_255
    31. 

  31. 278	val_278
    32. 

  32. 484	val_484
    33. 

  33. PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
    34. 

  34. PREHOOK: type: QUERY
    35. 

  35. PREHOOK: Input: default@rcfiletablelazydecompress
    36. 

  36. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-28_826_2664555248442666518/10000
    37. 

  37. POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
    38. 

  38. POSTHOOK: type: QUERY
    39. 

  39. POSTHOOK: Input: default@rcfiletablelazydecompress
    40. 

  40. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-28_826_2664555248442666518/10000
    41. 

  41. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    42. 

  42. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    43. 

  43. 311	val_311
    44. 

  44. 255	val_255
    45. 

  45. 278	val_278
    46. 

  46. PREHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
    47. 

  47. PREHOOK: type: QUERY
    48. 

  48. PREHOOK: Input: default@rcfiletablelazydecompress
    49. 

  49. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-31_347_4980542755724589562/10000
    50. 

  50. POSTHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
    51. 

  51. POSTHOOK: type: QUERY
    52. 

  52. POSTHOOK: Input: default@rcfiletablelazydecompress
    53. 

  53. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-31_347_4980542755724589562/10000
    54. 

  54. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    55. 

  55. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    56. 

  56. 255	1
    57. 

  57. 278	1
    58. 

  58. 311	1
    59. 

  59. 409	1
    60. 

  60. 484	1
    61. 

  61. PREHOOK: query: FROM src
    62. 

  62. INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
    63. 

  63. PREHOOK: type: QUERY
    64. 

  64. PREHOOK: Input: default@src
    65. 

  65. PREHOOK: Output: default@rcfiletablelazydecompress
    66. 

  66. POSTHOOK: query: FROM src
    67. 

  67. INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10
    68. 

  68. POSTHOOK: type: QUERY
    69. 

  69. POSTHOOK: Input: default@src
    70. 

  70. POSTHOOK: Output: default@rcfiletablelazydecompress
    71. 

  71. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    72. 

  72. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    73. 

  73. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    74. 

  74. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    75. 

  75. PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
    76. 

  76. PREHOOK: type: QUERY
    77. 

  77. PREHOOK: Input: default@rcfiletablelazydecompress
    78. 

  78. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-36_558_7043959496739147343/10000
    79. 

  79. POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238
    80. 

  80. POSTHOOK: type: QUERY
    81. 

  81. POSTHOOK: Input: default@rcfiletablelazydecompress
    82. 

  82. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-36_558_7043959496739147343/10000
    83. 

  83. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    84. 

  84. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    85. 

  85. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    86. 

  86. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    87. 

  87. 311	val_311
    88. 

  88. 409	val_409
    89. 

  89. 255	val_255
    90. 

  90. 278	val_278
    91. 

  91. 484	val_484
    92. 

  92. PREHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
    93. 

  93. PREHOOK: type: QUERY
    94. 

  94. PREHOOK: Input: default@rcfiletablelazydecompress
    95. 

  95. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-39_022_510504722430321903/10000
    96. 

  96. POSTHOOK: query: SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400
    97. 

  97. POSTHOOK: type: QUERY
    98. 

  98. POSTHOOK: Input: default@rcfiletablelazydecompress
    99. 

  99. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-39_022_510504722430321903/10000
    100. 

  100. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    101. 

  101. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    102. 

  102. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    103. 

  103. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    104. 

  104. 311	val_311
    105. 

  105. 255	val_255
    106. 

  106. 278	val_278
    107. 

  107. PREHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
    108. 

  108. PREHOOK: type: QUERY
    109. 

  109. PREHOOK: Input: default@rcfiletablelazydecompress
    110. 

  110. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-41_564_865533805813240026/10000
    111. 

  111. POSTHOOK: query: SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key
    112. 

  112. POSTHOOK: type: QUERY
    113. 

  113. POSTHOOK: Input: default@rcfiletablelazydecompress
    114. 

  114. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-48-41_564_865533805813240026/10000
    115. 

  115. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    116. 

  116. POSTHOOK: Lineage: rcfiletablelazydecompress.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    117. 

  117. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    118. 

  118. POSTHOOK: Lineage: rcfiletablelazydecompress.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    119. 

  119. 255	1
    120. 

  120. 278	1
    121. 

  121. 311	1
    122. 

  122. 409	1
    123. 

  123. 484	1
    124. 

  124.