PageRenderTime 41ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

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

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

  1. PREHOOK: query: create table abc(strct struct<a:int, b:string, c:string>)
    2. 

  2. row format delimited
    3. 

  3.   fields terminated by '\t'
    4. 

  4.   collection items terminated by '\001'
    5. 

  5. PREHOOK: type: CREATETABLE
    6. 

  6. POSTHOOK: query: create table abc(strct struct<a:int, b:string, c:string>)
    7. 

  7. row format delimited
    8. 

  8.   fields terminated by '\t'
    9. 

  9.   collection items terminated by '\001'
    10. 

  10. POSTHOOK: type: CREATETABLE
    11. 

  11. POSTHOOK: Output: default@abc
    12. 

  12. PREHOOK: query: load data local inpath '../data/files/kv1.txt'
    13. 

  13. overwrite into table abc
    14. 

  14. PREHOOK: type: LOAD
    15. 

  15. PREHOOK: Output: default@abc
    16. 

  16. POSTHOOK: query: load data local inpath '../data/files/kv1.txt'
    17. 

  17. overwrite into table abc
    18. 

  18. POSTHOOK: type: LOAD
    19. 

  19. POSTHOOK: Output: default@abc
    20. 

  20. PREHOOK: query: SELECT strct, strct.a, strct.b FROM abc LIMIT 10
    21. 

  21. PREHOOK: type: QUERY
    22. 

  22. PREHOOK: Input: default@abc
    23. 

  23. PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-50-45_028_3620501678715037894/-mr-10000
    24. 

  24. POSTHOOK: query: SELECT strct, strct.a, strct.b FROM abc LIMIT 10
    25. 

  25. POSTHOOK: type: QUERY
    26. 

  26. POSTHOOK: Input: default@abc
    27. 

  27. POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-50-45_028_3620501678715037894/-mr-10000
    28. 

  28. {"a":238,"b":"val_238","c":null}	238	val_238
    29. 

  29. {"a":86,"b":"val_86","c":null}	86	val_86
    30. 

  30. {"a":311,"b":"val_311","c":null}	311	val_311
    31. 

  31. {"a":27,"b":"val_27","c":null}	27	val_27
    32. 

  32. {"a":165,"b":"val_165","c":null}	165	val_165
    33. 

  33. {"a":409,"b":"val_409","c":null}	409	val_409
    34. 

  34. {"a":255,"b":"val_255","c":null}	255	val_255
    35. 

  35. {"a":278,"b":"val_278","c":null}	278	val_278
    36. 

  36. {"a":98,"b":"val_98","c":null}	98	val_98
    37. 

  37. {"a":484,"b":"val_484","c":null}	484	val_484
    38. 

  38.