PageRenderTime 42ms CodeModel.GetById 18ms RepoModel.GetById 0ms 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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE kafka (contents STRING)
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE kafka (contents STRING)
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@kafka
  6. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
  7. PREHOOK: type: LOAD
  8. PREHOOK: Output: default@kafka
  9. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/text-en.txt' INTO TABLE kafka
  10. POSTHOOK: type: LOAD
  11. POSTHOOK: Output: default@kafka
  12. PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
  13. PREHOOK: type: QUERY
  14. PREHOOK: Input: default@kafka
  15. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-48_288_5632959439216928755/-mr-10000
  16. POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000).estfrequency FROM kafka
  17. POSTHOOK: type: QUERY
  18. POSTHOOK: Input: default@kafka
  19. POSTHOOK: 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]
  21. PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
  22. PREHOOK: type: QUERY
  23. PREHOOK: Input: default@kafka
  24. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-51_425_7596742202423993299/-mr-10000
  25. POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000).estfrequency FROM kafka
  26. POSTHOOK: type: QUERY
  27. POSTHOOK: Input: default@kafka
  28. POSTHOOK: 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]
  30. PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
  31. PREHOOK: type: QUERY
  32. PREHOOK: Input: default@kafka
  33. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-54_498_1141616962882375479/-mr-10000
  34. POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000).estfrequency FROM kafka
  35. POSTHOOK: type: QUERY
  36. POSTHOOK: Input: default@kafka
  37. POSTHOOK: 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]
  39. PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
  40. PREHOOK: type: QUERY
  41. PREHOOK: Input: default@kafka
  42. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-58_347_4459903181683954594/-mr-10000
  43. POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000).estfrequency FROM kafka
  44. POSTHOOK: type: QUERY
  45. POSTHOOK: Input: default@kafka
  46. POSTHOOK: 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]
  48. PREHOOK: query: DROP TABLE kafka
  49. PREHOOK: type: DROPTABLE
  50. PREHOOK: Input: default@kafka
  51. PREHOOK: Output: default@kafka
  52. POSTHOOK: query: DROP TABLE kafka
  53. POSTHOOK: type: DROPTABLE
  54. POSTHOOK: Input: default@kafka
  55. POSTHOOK: Output: default@kafka