PageRenderTime 44ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: create table sc as select * 
    2. 

  2. from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
    3. 

  3.       union all 
    4. 

  4.       select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
    5. 

  5.       union all 
    6. 

  6.       select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
    7. 

  7. PREHOOK: type: CREATETABLE_AS_SELECT
    8. 

  8. PREHOOK: Input: default@src
    9. 

  9. POSTHOOK: query: create table sc as select * 
    10. 

  10. from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
    11. 

  11.       union all 
    12. 

  12.       select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
    13. 

  13.       union all 
    14. 

  14.       select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
    15. 

  15. POSTHOOK: type: CREATETABLE_AS_SELECT
    16. 

  16. POSTHOOK: Input: default@src
    17. 

  17. POSTHOOK: Output: default@sc
    18. 

  18. PREHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
    19. 

  19. PREHOOK: type: CREATETABLE
    20. 

  20. POSTHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
    21. 

  21. POSTHOOK: type: CREATETABLE
    22. 

  22. POSTHOOK: Output: default@sc_part
    23. 

  23. PREHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
    24. 

  24. PREHOOK: type: QUERY
    25. 

  25. PREHOOK: Input: default@sc
    26. 

  26. PREHOOK: Output: default@sc_part
    27. 

  27. POSTHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
    28. 

  28. POSTHOOK: type: QUERY
    29. 

  29. POSTHOOK: Input: default@sc
    30. 

  30. POSTHOOK: Output: default@sc_part@ts=2011-01-11+14%3A18%3A26
    31. 

  31. POSTHOOK: Output: default@sc_part@ts=2011-01-11+15%3A18%3A26
    32. 

  32. POSTHOOK: Output: default@sc_part@ts=2011-01-11+16%3A18%3A26
    33. 

  33. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    34. 

  34. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    35. 

  35. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    36. 

  36. PREHOOK: query: show partitions sc_part
    37. 

  37. PREHOOK: type: SHOWPARTITIONS
    38. 

  38. POSTHOOK: query: show partitions sc_part
    39. 

  39. POSTHOOK: type: SHOWPARTITIONS
    40. 

  40. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    41. 

  41. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    42. 

  42. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    43. 

  43. ts=2011-01-11+14%3A18%3A26
    44. 

  44. ts=2011-01-11+15%3A18%3A26
    45. 

  45. ts=2011-01-11+16%3A18%3A26
    46. 

  46. PREHOOK: query: select count(*) from sc_part where ts is not null
    47. 

  47. PREHOOK: type: QUERY
    48. 

  48. PREHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
    49. 

  49. PREHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
    50. 

  50. PREHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
    51. 

  51. PREHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-08_667_3825187877309649250/-mr-10000
    52. 

  52. POSTHOOK: query: select count(*) from sc_part where ts is not null
    53. 

  53. POSTHOOK: type: QUERY
    54. 

  54. POSTHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
    55. 

  55. POSTHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
    56. 

  56. POSTHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
    57. 

  57. POSTHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-08_667_3825187877309649250/-mr-10000
    58. 

  58. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    59. 

  59. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    60. 

  60. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    61. 

  61. 3
    62. 

  62. PREHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
    63. 

  63. PREHOOK: type: QUERY
    64. 

  64. PREHOOK: Input: default@sc
    65. 

  65. PREHOOK: Output: default@sc_part
    66. 

  66. POSTHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
    67. 

  67. POSTHOOK: type: QUERY
    68. 

  68. POSTHOOK: Input: default@sc
    69. 

  69. POSTHOOK: Output: default@sc_part@ts=2011-01-11+14%3A18%3A26
    70. 

  70. POSTHOOK: Output: default@sc_part@ts=2011-01-11+15%3A18%3A26
    71. 

  71. POSTHOOK: Output: default@sc_part@ts=2011-01-11+16%3A18%3A26
    72. 

  72. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    73. 

  73. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    74. 

  74. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    75. 

  75. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    76. 

  76. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    77. 

  77. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    78. 

  78. PREHOOK: query: show partitions sc_part
    79. 

  79. PREHOOK: type: SHOWPARTITIONS
    80. 

  80. POSTHOOK: query: show partitions sc_part
    81. 

  81. POSTHOOK: type: SHOWPARTITIONS
    82. 

  82. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    83. 

  83. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    84. 

  84. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    85. 

  85. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    86. 

  86. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    87. 

  87. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    88. 

  88. ts=2011-01-11+14%3A18%3A26
    89. 

  89. ts=2011-01-11+15%3A18%3A26
    90. 

  90. ts=2011-01-11+16%3A18%3A26
    91. 

  91. PREHOOK: query: select count(*) from sc_part where ts is not null
    92. 

  92. PREHOOK: type: QUERY
    93. 

  93. PREHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
    94. 

  94. PREHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
    95. 

  95. PREHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
    96. 

  96. PREHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-17_403_2722288816258097447/-mr-10000
    97. 

  97. POSTHOOK: query: select count(*) from sc_part where ts is not null
    98. 

  98. POSTHOOK: type: QUERY
    99. 

  99. POSTHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
    100. 

  100. POSTHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
    101. 

  101. POSTHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
    102. 

  102. POSTHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-17_403_2722288816258097447/-mr-10000
    103. 

  103. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    104. 

  104. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    105. 

  105. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    106. 

  106. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    107. 

  107. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    108. 

  108. POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
    109. 

  109. 3
    110. 

  110.