PageRenderTime 21ms CodeModel.GetById 15ms app.highlight 1ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 55 lines | 55 code | 0 blank | 0 comment | 0 complexity | 83a58922590bcd5c6f0953d61f5a683d MD5 | raw file
 1PREHOOK: query: CREATE TABLE kafka (contents STRING)
 2PREHOOK: type: CREATETABLE
 3POSTHOOK: query: CREATE TABLE kafka (contents STRING)
 4POSTHOOK: type: CREATETABLE
 5POSTHOOK: Output: default@kafka
 6PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
 7PREHOOK: type: LOAD
 8PREHOOK: Output: default@kafka
 9POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
10POSTHOOK: type: LOAD
11POSTHOOK: Output: default@kafka
12PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
13PREHOOK: type: QUERY
14PREHOOK: Input: default@kafka
15PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-48_288_5632959439216928755/-mr-10000
16POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
17POSTHOOK: type: QUERY
18POSTHOOK: Input: default@kafka
19POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-48_288_5632959439216928755/-mr-10000
20[23.0,20.0,18.0,17.0,17.0,16.0,16.0,16.0,16.0,15.0,14.0,13.0,12.0,12.0,12.0,11.0,11.0,11.0,10.0,10.0,10.0,10.0,10.0,10.0,9.0,9.0,9.0,8.0,8.0,8.0,8.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0]
21PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
22PREHOOK: type: QUERY
23PREHOOK: Input: default@kafka
24PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-51_425_7596742202423993299/-mr-10000
25POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
26POSTHOOK: type: QUERY
27POSTHOOK: Input: default@kafka
28POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-51_425_7596742202423993299/-mr-10000
29[7.0,6.0,6.0,6.0,6.0,5.0,5.0,5.0,5.0,5.0,5.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0]
30PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
31PREHOOK: type: QUERY
32PREHOOK: Input: default@kafka
33PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-54_498_1141616962882375479/-mr-10000
34POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
35POSTHOOK: type: QUERY
36POSTHOOK: Input: default@kafka
37POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-54_498_1141616962882375479/-mr-10000
38[5.0,4.0,4.0,4.0,4.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0]
39PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
40PREHOOK: type: QUERY
41PREHOOK: Input: default@kafka
42PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-58_347_4459903181683954594/-mr-10000
43POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
44POSTHOOK: type: QUERY
45POSTHOOK: Input: default@kafka
46POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-58_347_4459903181683954594/-mr-10000
47[4.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0]
48PREHOOK: query: DROP TABLE kafka
49PREHOOK: type: DROPTABLE
50PREHOOK: Input: default@kafka
51PREHOOK: Output: default@kafka
52POSTHOOK: query: DROP TABLE kafka
53POSTHOOK: type: DROPTABLE
54POSTHOOK: Input: default@kafka
55POSTHOOK: Output: default@kafka