PageRenderTime 40ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: EXPLAIN
    2. 

  2. FROM src_thrift
    3. 

  3. SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
    4. 

  4. PREHOOK: type: QUERY
    5. 

  5. POSTHOOK: query: EXPLAIN
    6. 

  6. FROM src_thrift
    7. 

  7. SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
    8. 

  8. POSTHOOK: type: QUERY
    9. 

  9. ABSTRACT SYNTAX TREE:
    10. 

  10.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_9')) (TOK_SELEXPR (. (. (TOK_TABLE_OR_COL src_thrift) lintstring) myint)))))
    11. 

  11. 

  12. STAGE DEPENDENCIES:
    13. 

  13.   Stage-1 is a root stage
    14. 

  14.   Stage-0 is a root stage
    15. 

  15. 

  16. STAGE PLANS:
    17. 

  17.   Stage: Stage-1
    18. 

  18.     Map Reduce
    19. 

  19.       Alias -> Map Operator Tree:
    20. 

  20.         src_thrift 
    21. 

  21.           TableScan
    22. 

  22.             alias: src_thrift
    23. 

  23.             Select Operator
    24. 

  24.               expressions:
    25. 

  25.                     expr: mstringstring['key_9']
    26. 

  26.                     type: string
    27. 

  27.                     expr: lintstring.myint
    28. 

  28.                     type: array<int>
    29. 

  29.               outputColumnNames: _col0, _col1
    30. 

  30.               File Output Operator
    31. 

  31.                 compressed: false
    32. 

  32.                 GlobalTableId: 0
    33. 

  33.                 table:
    34. 

  34.                     input format: org.apache.hadoop.mapred.TextInputFormat
    35. 

  35.                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    36. 

  36. 

  37.   Stage: Stage-0
    38. 

  38.     Fetch Operator
    39. 

  39.       limit: -1
    40. 

  40. 

  41. 

  42. PREHOOK: query: FROM src_thrift
    43. 

  43. SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
    44. 

  44. PREHOOK: type: QUERY
    45. 

  45. PREHOOK: Input: default@src_thrift
    46. 

  46. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-57_326_2264158676212177633/-mr-10000
    47. 

  47. POSTHOOK: query: FROM src_thrift
    48. 

  48. SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
    49. 

  49. POSTHOOK: type: QUERY
    50. 

  50. POSTHOOK: Input: default@src_thrift
    51. 

  51. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-57_326_2264158676212177633/-mr-10000
    52. 

  52. NULL	[0]
    53. 

  53. NULL	[1]
    54. 

  54. NULL	[4]
    55. 

  55. NULL	[9]
    56. 

  56. NULL	[16]
    57. 

  57. NULL	[25]
    58. 

  58. NULL	[36]
    59. 

  59. NULL	[49]
    60. 

  60. NULL	[64]
    61. 

  61. value_9	[81]
    62. 

  62. NULL	null
    63. 

  63.