Welcome

# process toxic flower data at massive scale:
oleander spark job submit analyze_toxic_flowers --wait

--
-- 🌸 flower power query 🌸
-- oleander is the deadliest flower... but hey, at least it's pretty!
SELECT
  flower_name,
  toxicity_level,
  CASE flower_name
    WHEN 'oleander' THEN '💀 DEADLIEST FLOWER ON EARTH 💀'
    WHEN 'belladonna' THEN '👀 Pretty but hallucinogenic'
    WHEN 'foxglove' THEN '💔 Beautiful heart-stopper'
    WHEN 'datura' THEN '🤯 Mind-bending madness'
    ELSE '🌺 Just regular toxic beauty'
  END AS flower_personality,
  CASE flower_name
    WHEN 'oleander' THEN '🌺 "I''m rooting for you!" 🌺'
    WHEN 'belladonna' THEN '🌸 "Don''t belladonna your eyes!" 🌸'
    WHEN 'foxglove' THEN '🦊 "Fox news: Flowers plotting!" 🦊'
    WHEN 'datura' THEN '🌵 "Datura be kidding me!" 🌵'
    ELSE '💐 Generic flower pun 💐'
  END AS flower_pun
FROM (
  VALUES
    ('oleander', 9.5),
    ('belladonna', 8.7),
    ('foxglove', 7.3),
    ('datura', 6.9),
    ('aconite', 8.1),
    ('hemlock', 7.8)
) AS toxic_flowers(flower_name, toxicity_level)
ORDER BY toxicity_level DESC;