PageRenderTime 36ms CodeModel.GetById 9ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: CREATE TABLE dest1(key INT, value STRING)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@dest1
    6. 

  6. PREHOOK: query: FROM (
    7. 

  7.   FROM src
    8. 

  8.   SELECT TRANSFORM(src.key, src.value)
    9. 

  9.          USING 'testgrep' AS (tkey, tvalue)
    10. 

  10.   CLUSTER BY tkey
    11. 

  11. ) tmap
    12. 

  12. INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
    13. 

  13. PREHOOK: type: QUERY
    14. 

  14. PREHOOK: Input: default@src
    15. 

  15. PREHOOK: Output: default@dest1
    16. 

  16. POSTHOOK: query: FROM (
    17. 

  17.   FROM src
    18. 

  18.   SELECT TRANSFORM(src.key, src.value)
    19. 

  19.          USING 'testgrep' AS (tkey, tvalue)
    20. 

  20.   CLUSTER BY tkey
    21. 

  21. ) tmap
    22. 

  22. INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
    23. 

  23. POSTHOOK: type: QUERY
    24. 

  24. POSTHOOK: Input: default@src
    25. 

  25. POSTHOOK: Output: default@dest1
    26. 

  26. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
    27. 

  27. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
    28. 

  28. PREHOOK: query: SELECT dest1.* FROM dest1
    29. 

  29. PREHOOK: type: QUERY
    30. 

  30. PREHOOK: Input: default@dest1
    31. 

  31. PREHOOK: Output: hdfs://localhost.localdomain:39190/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-52-59_555_6132352806731305883/-mr-10000
    32. 

  32. POSTHOOK: query: SELECT dest1.* FROM dest1
    33. 

  33. POSTHOOK: type: QUERY
    34. 

  34. POSTHOOK: Input: default@dest1
    35. 

  35. POSTHOOK: Output: hdfs://localhost.localdomain:39190/data/users/njain/hive_commit1/build/ql/scratchdir/hive_2011-02-03_10-52-59_555_6132352806731305883/-mr-10000
    36. 

  36. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
    37. 

  37. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
    38. 

  38. 10	val_10
    39. 

  39. 100	val_100
    40. 

  40. 100	val_100
    41. 

  41. 103	val_103
    42. 

  42. 103	val_103
    43. 

  43. 104	val_104
    44. 

  44. 104	val_104
    45. 

  45. 105	val_105
    46. 

  46. 310	val_310
    47. 

  47.