PageRenderTime 22ms CodeModel.GetById 20ms app.highlight 0ms RepoModel.GetById 1ms 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
 1PREHOOK: query: create table abc(strct struct<a:int, b:string, c:string>)
 2row format delimited
 3  fields terminated by '\t'
 4  collection items terminated by '\001'
 5PREHOOK: type: CREATETABLE
 6POSTHOOK: query: create table abc(strct struct<a:int, b:string, c:string>)
 7row format delimited
 8  fields terminated by '\t'
 9  collection items terminated by '\001'
10POSTHOOK: type: CREATETABLE
11POSTHOOK: Output: default@abc
12PREHOOK: query: load data local inpath '../data/files/kv1.txt'
13overwrite into table abc
14PREHOOK: type: LOAD
15PREHOOK: Output: default@abc
16POSTHOOK: query: load data local inpath '../data/files/kv1.txt'
17overwrite into table abc
18POSTHOOK: type: LOAD
19POSTHOOK: Output: default@abc
20PREHOOK: query: SELECT strct, strct.a, strct.b FROM abc LIMIT 10
21PREHOOK: type: QUERY
22PREHOOK: Input: default@abc
23PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-50-45_028_3620501678715037894/-mr-10000
24POSTHOOK: query: SELECT strct, strct.a, strct.b FROM abc LIMIT 10
25POSTHOOK: type: QUERY
26POSTHOOK: Input: default@abc
27POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-50-45_028_3620501678715037894/-mr-10000
28{"a":238,"b":"val_238","c":null}	238	val_238
29{"a":86,"b":"val_86","c":null}	86	val_86
30{"a":311,"b":"val_311","c":null}	311	val_311
31{"a":27,"b":"val_27","c":null}	27	val_27
32{"a":165,"b":"val_165","c":null}	165	val_165
33{"a":409,"b":"val_409","c":null}	409	val_409
34{"a":255,"b":"val_255","c":null}	255	val_255
35{"a":278,"b":"val_278","c":null}	278	val_278
36{"a":98,"b":"val_98","c":null}	98	val_98
37{"a":484,"b":"val_484","c":null}	484	val_484