NYC Clojure Meetup Apr '14

Cascalog at Intent Media

Transcript

1. Cascalog at Intent Media Tuesday, April 15, 14
2. Overview • About • Why we use Cascalog • Query execution, Example queries • How we work with Cascalog • Alternatives Tuesday, April 15, 14
3. About Intent Media • Ad tech • 70 people, 35 engineers, 8 data team • Site optimization for e-commerce Tuesday, April 15, 14
4. Auction Advertiser Bid Est. Click Through Rate Est. Revenue Airline1 $10 3% $0.30 Airline2 $5 5% $0.25 Airline3 $8 10% $0.80 Airline4 $2 30% $0.60 Tuesday, April 15, 14
5. High Level Pipeline e.g. 1 0.5 0.8 0.1 0.2 0.3 0.4 -1 0.2 -0.5 2.5 -0.2 -0.3 -0.4 1 -0.2 0.5 0.5 -0.1 0.7 0.5 ... Tuesday, April 15, 14
6. IM & Hadoop • Hadoop • Pig • Cascalog Tuesday, April 15, 14
7. Pig: TupleVariance UDF Tuesday, April 15, 14
8. Cascalog Tuesday, April 15, 14
9. Operations Pipes Taps FileTap Hfs GlobHfs MultiSourceTap MultiSinkTap Schemes TextLine TextDelimited SequenceFile WritableSequenceFile Tuesday, April 15, 14
10. Word Count Tuesday, April 15, 14
11. Word Count, Cascalog Tuesday, April 15, 14
12. Word Count, Cascalog Generator Operation Aggregation Output Tap Tuesday, April 15, 14
13. Word Count, Cascalog Generator Operation Aggregation Output Tap Cascalog Predicates Tuesday, April 15, 14
14. Query Execution • Pre-Aggregation: Join generators, apply operators where possible • Aggregation: Fix outputs that we have already, aggregate the rest • Post-Aggregation: Apply remaining operators Tuesday, April 15, 14
15. Query Execution Tuesday, April 15, 14
16. Query Execution Pre-Aggregation (Generators) [["impression-1" "buy this product"] ["impression-2" "great deal"] ["impression-3" "cheap sale"] ["impression-4" "cheap sale"]] [["click-1" "impression-3" 0] ["click-2" "impression-2" 0] ["click-3" "impression-2" 100]] Tuesday, April 15, 14
17. Query Execution Pre-Aggregation (Join) [["impression-1 "buy this product" nil nil] ["impression-2" "great deal" "click-2" 0] ["impression-2" "great deal" "click-3" 100] ["impression-3" "cheap sale" "click-1" 0] ["impression-4" "cheap sale" nil nil]] Tuesday, April 15, 14
18. Query Execution Pre-Aggregation (Operations) [["impression-1 ["buy" "this" "product"] nil nil] ["impression-2" ["great" "deal"] "click-2" 0] ["impression-2" ["great" "deal"] "click-3" 100] ["impression-3" ["cheap" "sale"] "click-1" 0] ["impression-4" ["cheap" "sale"] nil nil]] Tuesday, April 15, 14
19. Query Execution Aggregation [["impression-1 ["buy" "this" "product"] 0] ["impression-2" ["great" "deal"] 100] ["impression-3" ["cheap" "sale"] 0] ["impression-4" ["cheap" "sale"] 0]] Tuesday, April 15, 14
20. Query Execution Post-Aggregation (Operations) [["impression-1 ["buy" "this" "product"] -1] ["impression-2" ["great" "deal"] 1] ["impression-3" ["cheap" "sale"] -1] ["impression-4" ["cheap" "sale"] -1]] Tuesday, April 15, 14
21. Built-In Filter Ops • first-n • limit • limit-rank • fixed-sample • fixed-sample-agg • re-parse Tuesday, April 15, 14
22. Built-In Agg Ops • avg • count/!count • distinct-count • max • min • sum Tuesday, April 15, 14
23. Built-In Higher Order Functions • all • any • comp • each • negate • partial Tuesday, April 15, 14
24. Custom Function Types • mapfn • mapcatfn • filterfn • bufferfn • aggregatefn Tuesday, April 15, 14
25. defparallelagg Move execution from the reducer to the combiners 1 2 3 5 8 11 1 2 3 5 8 11 Map Reduce (+ 1 2 3 5 8 11) Map Reduce (+ 6 24) Tuesday, April 15, 14
26. midje-cascalog • Macros for testing cascalog queries • Use produces function to check outputs Tuesday, April 15, 14
27. Examples • Feature variance • Linear regression Tuesday, April 15, 14
28. Workflow • On a sampled dataset: • Unit test the components • End-to-end test the workflow • Then, test on the cluster Tuesday, April 15, 14
29. Checkpoint Tuesday, April 15, 14
30. Checkpoint Tuesday, April 15, 14
31. Checkpoint Tuesday, April 15, 14
32. Other Hadoop Projects • Pigpen • Parkour Tuesday, April 15, 14
33. Other execution backends • Storm • Spark Tuesday, April 15, 14
34. Thanks Tuesday, April 15, 14