Simple.sql 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116
  1. /* syntax version 1 */
  2. SELECT YQL::@@(block '(
  3. (let inputRows (AsList
  4. (AsStruct '('Data (String '"Input line #13")))
  5. (AsStruct '('Data (String '"Input line #35")))
  6. (AsStruct '('Data (String '"Input line #76")))
  7. (AsStruct '('Data (String '"Input line #70")))
  8. (AsStruct '('Data (String '"Input line #9")))
  9. (AsStruct '('Data (String '"Input line #63")))
  10. (AsStruct '('Data (String '"Input line #53")))
  11. (AsStruct '('Data (String '"Input line #89")))
  12. (AsStruct '('Data (String '"Input line #31")))
  13. (AsStruct '('Data (String '"Input line #4")))
  14. (AsStruct '('Data (String '"Input line #65")))
  15. (AsStruct '('Data (String '"Input line #64")))
  16. (AsStruct '('Data (String '"Input line #37")))
  17. (AsStruct '('Data (String '"Input line #79")))
  18. (AsStruct '('Data (String '"Input line #51")))
  19. (AsStruct '('Data (String '"Input line #59")))
  20. (AsStruct '('Data (String '"Input line #67")))
  21. (AsStruct '('Data (String '"Input line #98")))
  22. (AsStruct '('Data (String '"Input line #94")))
  23. (AsStruct '('Data (String '"Input line #55")))
  24. (AsStruct '('Data (String '"Input line #80")))
  25. (AsStruct '('Data (String '"Input line #96")))
  26. (AsStruct '('Data (String '"Input line #27")))
  27. (AsStruct '('Data (String '"Input line #29")))
  28. (AsStruct '('Data (String '"Input line #84")))
  29. (AsStruct '('Data (String '"Input line #77")))
  30. (AsStruct '('Data (String '"Input line #19")))
  31. (AsStruct '('Data (String '"Input line #22")))
  32. (AsStruct '('Data (String '"Input line #21")))
  33. (AsStruct '('Data (String '"Input line #49")))
  34. (AsStruct '('Data (String '"Input line #93")))
  35. (AsStruct '('Data (String '"Input line #61")))
  36. (AsStruct '('Data (String '"Input line #71")))
  37. (AsStruct '('Data (String '"Input line #15")))
  38. (AsStruct '('Data (String '"Input line #92")))
  39. (AsStruct '('Data (String '"Input line #50")))
  40. (AsStruct '('Data (String '"Input line #14")))
  41. (AsStruct '('Data (String '"Input line #99")))
  42. (AsStruct '('Data (String '"Input line #57")))
  43. (AsStruct '('Data (String '"Input line #10")))
  44. (AsStruct '('Data (String '"Input line #73")))
  45. (AsStruct '('Data (String '"Input line #54")))
  46. (AsStruct '('Data (String '"Input line #43")))
  47. (AsStruct '('Data (String '"Input line #17")))
  48. (AsStruct '('Data (String '"Input line #34")))
  49. (AsStruct '('Data (String '"Input line #36")))
  50. (AsStruct '('Data (String '"Input line #45")))
  51. (AsStruct '('Data (String '"Input line #30")))
  52. (AsStruct '('Data (String '"Input line #72")))
  53. (AsStruct '('Data (String '"Input line #90")))
  54. (AsStruct '('Data (String '"Input line #47")))
  55. (AsStruct '('Data (String '"Input line #86")))
  56. (AsStruct '('Data (String '"Input line #56")))
  57. (AsStruct '('Data (String '"Input line #38")))
  58. (AsStruct '('Data (String '"Input line #52")))
  59. (AsStruct '('Data (String '"Input line #42")))
  60. (AsStruct '('Data (String '"Input line #1")))
  61. (AsStruct '('Data (String '"Input line #82")))
  62. (AsStruct '('Data (String '"Input line #48")))
  63. (AsStruct '('Data (String '"Input line #75")))
  64. (AsStruct '('Data (String '"Input line #40")))
  65. (AsStruct '('Data (String '"Input line #85")))
  66. (AsStruct '('Data (String '"Input line #58")))
  67. (AsStruct '('Data (String '"Input line #33")))
  68. (AsStruct '('Data (String '"Input line #12")))
  69. (AsStruct '('Data (String '"Input line #46")))
  70. (AsStruct '('Data (String '"Input line #8")))
  71. (AsStruct '('Data (String '"Input line #44")))
  72. (AsStruct '('Data (String '"Input line #18")))
  73. (AsStruct '('Data (String '"Input line #25")))
  74. (AsStruct '('Data (String '"Input line #11")))
  75. (AsStruct '('Data (String '"Input line #2")))
  76. (AsStruct '('Data (String '"Input line #5")))
  77. (AsStruct '('Data (String '"Input line #3")))
  78. (AsStruct '('Data (String '"Input line #23")))
  79. (AsStruct '('Data (String '"Input line #20")))
  80. (AsStruct '('Data (String '"Input line #83")))
  81. (AsStruct '('Data (String '"Input line #6")))
  82. (AsStruct '('Data (String '"Input line #78")))
  83. (AsStruct '('Data (String '"Input line #95")))
  84. (AsStruct '('Data (String '"Input line #0")))
  85. (AsStruct '('Data (String '"Input line #16")))
  86. (AsStruct '('Data (String '"Input line #88")))
  87. (AsStruct '('Data (String '"Input line #28")))
  88. (AsStruct '('Data (String '"Input line #81")))
  89. (AsStruct '('Data (String '"Input line #60")))
  90. (AsStruct '('Data (String '"Input line #41")))
  91. (AsStruct '('Data (String '"Input line #24")))
  92. (AsStruct '('Data (String '"Input line #87")))
  93. (AsStruct '('Data (String '"Input line #26")))
  94. (AsStruct '('Data (String '"Input line #97")))
  95. (AsStruct '('Data (String '"Input line #91")))
  96. (AsStruct '('Data (String '"Input line #66")))
  97. (AsStruct '('Data (String '"Input line #69")))
  98. (AsStruct '('Data (String '"Input line #74")))
  99. (AsStruct '('Data (String '"Input line #7")))
  100. (AsStruct '('Data (String '"Input line #68")))
  101. (AsStruct '('Data (String '"Input line #39")))
  102. (AsStruct '('Data (String '"Input line #32")))
  103. (AsStruct '('Data (String '"Input line #62")))
  104. ))
  105. (let udf (Udf '"Streaming.Process"))
  106. (let args1 (AsList (String '"[123679]")))
  107. (let res1 (Apply udf (Iterator inputRows) (String '"grep") args1))
  108. (let args2 (AsList (String '"4")))
  109. (let res2 (Apply udf res1 (String '"grep") args2))
  110. (let res3 (Apply udf res2 (String '"head")))
  111. (return (Collect res3))
  112. ))@@;