/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: CREATE TABLE kafka (contents STRING)
- PREHOOK: type: CREATETABLE
- POSTHOOK: query: CREATE TABLE kafka (contents STRING)
- POSTHOOK: type: CREATETABLE
- POSTHOOK: Output: default@kafka
- PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
- PREHOOK: type: LOAD
- PREHOOK: Output: default@kafka
- POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
- POSTHOOK: type: LOAD
- POSTHOOK: Output: default@kafka
- PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
- PREHOOK: type: QUERY
- PREHOOK: Input: default@kafka
- PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-48_288_5632959439216928755/-mr-10000
- POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@kafka
- POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-48_288_5632959439216928755/-mr-10000
- [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]
- PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
- PREHOOK: type: QUERY
- PREHOOK: Input: default@kafka
- PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-51_425_7596742202423993299/-mr-10000
- POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@kafka
- POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-51_425_7596742202423993299/-mr-10000
- [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]
- PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
- PREHOOK: type: QUERY
- PREHOOK: Input: default@kafka
- PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-54_498_1141616962882375479/-mr-10000
- POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@kafka
- POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-54_498_1141616962882375479/-mr-10000
- [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]
- PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
- PREHOOK: type: QUERY
- PREHOOK: Input: default@kafka
- PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-58_347_4459903181683954594/-mr-10000
- POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@kafka
- POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-58_347_4459903181683954594/-mr-10000
- [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]
- PREHOOK: query: DROP TABLE kafka
- PREHOOK: type: DROPTABLE
- PREHOOK: Input: default@kafka
- PREHOOK: Output: default@kafka
- POSTHOOK: query: DROP TABLE kafka
- POSTHOOK: type: DROPTABLE
- POSTHOOK: Input: default@kafka
- POSTHOOK: Output: default@kafka