Show HN: Use natural language to query and visualize 400M tweets

by tmostakon 2/22/2024, 4:41 PMwith 3 comments

We've been working hard for the last year on building HeavyIQ, an LLM-powered plugin to the GPU-accelerated HeavyDB database, that allows users to ask natural language questions and get SQL, visualizations, and natural language answers back. The LLM itself is fine-tuned on tens of thousands of question and answer pairs, with a major focus around building the model’s proficiency at performing spatial and temporal joins.

You can try it for yourself on this live demo of 400M tweets and a handful of other datasets of interest: https://demo-heavyiq.heavy.ai/us_tweets/sql-notebook

For more info on the model and capabilities please read our blog: https://www.heavy.ai/blog/heavyiq-conversational-analytics

by patdwilsonon 2/22/2024, 5:32 PM

My favorite question is "Show the percentage of tweets mentioning "y'all" or "yall" per state." Thank you, Louisiana :)

by sdrg822on 2/22/2024, 5:07 PM

Congrats on the launch!