PageRenderTime 48ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: create table insert1(key int, value string) stored as textfile
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table insert1(key int, value string) stored as textfile
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@insert1
    6. 

  6. PREHOOK: query: create table insert2(key int, value string) stored as textfile
    7. 

  7. PREHOOK: type: CREATETABLE
    8. 

  8. POSTHOOK: query: create table insert2(key int, value string) stored as textfile
    9. 

  9. POSTHOOK: type: CREATETABLE
    10. 

  10. POSTHOOK: Output: default@insert2
    11. 

  11. PREHOOK: query: insert overwrite table insert1 select a.key, a.value from insert2 a WHERE (a.key=-1)
    12. 

  12. PREHOOK: type: QUERY
    13. 

  13. PREHOOK: Input: default@insert2
    14. 

  14. PREHOOK: Output: default@insert1
    15. 

  15. POSTHOOK: query: insert overwrite table insert1 select a.key, a.value from insert2 a WHERE (a.key=-1)
    16. 

  16. POSTHOOK: type: QUERY
    17. 

  17. POSTHOOK: Input: default@insert2
    18. 

  18. POSTHOOK: Output: default@insert1
    19. 

  19. POSTHOOK: Lineage: insert1.key SIMPLE [(insert2)a.FieldSchema(name:key, type:int, comment:null), ]
    20. 

  20. POSTHOOK: Lineage: insert1.value SIMPLE [(insert2)a.FieldSchema(name:value, type:string, comment:null), ]
    21. 

  21.