Big.sql 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. /* syntax version 1 */
  2. SELECT YQL::@@(block '(
  3. (let times16 (lambda '(x) (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x (Concat x x)))))))))))))))))
  4. (let s2_8 (Apply times16 (String '"1000000000000007")))
  5. (let s2_12 (Apply times16 s2_8))
  6. (let s2_16 (Apply times16 s2_12))
  7. (let s2_20 (Apply times16 s2_16))
  8. (let s2_24 (Apply times16 s2_20))
  9. (let s2_12_1 (Concat s2_12 (String '"762")))
  10. (let vt (VariantType (TupleType (DataType 'Int32) (DataType 'String))))
  11. (let inputRows (AsList
  12. (Variant s2_24 '1 vt)
  13. (Variant s2_8 '1 vt)
  14. (Variant s2_12 '1 vt)
  15. (Variant s2_12_1 '1 vt)
  16. (Variant s2_16 '1 vt)
  17. (Variant s2_8 '1 vt)
  18. (Variant s2_12_1 '1 vt)
  19. (Variant s2_24 '1 vt)
  20. (Variant s2_12_1 '1 vt)
  21. (Variant s2_24 '1 vt)
  22. (Variant s2_24 '1 vt)
  23. (Variant s2_12_1 '1 vt)
  24. (Variant s2_12_1 '1 vt)
  25. (Variant s2_24 '1 vt)
  26. (Variant s2_12_1 '1 vt)
  27. (Variant s2_12_1 '1 vt)
  28. (Variant s2_16 '1 vt)
  29. ))
  30. (let udf (Udf '"Streaming.Process"))
  31. (let pr (lambda '(x) (block '(
  32. (let res (AsStruct '('Data x)))
  33. (return res)
  34. ))))
  35. (let tr1 (lambda '(x) (block '(
  36. (let y (OrderedMap x pr))
  37. (return (Apply udf y (String '"cat"))))
  38. )))
  39. (let hugeResult (Switch (Iterator inputRows (DependsOn (String 'A))) '1 '('1) tr1))
  40. (let md5Udf (Udf '"Digest.Md5Hex"))
  41. (let shortResult (OrderedMap hugeResult (lambda '(x) (Apply md5Udf (Member x 'Data)))))
  42. (return (Collect shortResult))
  43. ))@@;