- Role
- Big Data Engineering Intern
- Company
- Suncaper (Chengdu Suncaper Data Co., Ltd.)
- When
- 2026 · team project
SkyQuery: asking flight data in plain language
At Suncaper, a big-data company in Chengdu, I worked on a flight meta-search and analysis platform built on 15M+ Expedia itineraries, with a conversational interface that turns a traveller's question into a database query and shows the answer as a table, chart or route map.
- Problem
- Flight prices feel arbitrary. Travellers watch fares jump, can't tell whether to buy now or wait, and sometimes chase low prices that can't actually be booked.
- Thinking
- Start from the questions people really ask: Is this fair? Should I wait? Why is this route so expensive? Answer them with data, and let people ask in their own words instead of in SQL.
- What I built
- Analyses of pricing, hub premiums, buy-or-wait booking windows, and ghost fares: sudden price swings that pressure people into panic-buying. I also built the conversational front end: a chat UI that sends questions to the text-to-query backend, displays the generated HiveQL, and automatically renders results as a table, chart or route map.
- Learning
- A natural-language interface only earns trust if it shows its work. Every answer displays the query it ran, so a person can check it instead of taking it on faith.
Technology
- Hadoop
- Hive
- PySpark
- JavaScript
- Leaflet
- REST APIs
- Agile / JIRA
Generated HiveQL
SELECT destinationAirport,
AVG(totalFare) AS avg_fare
FROM itineraries
WHERE startingAirport = 'JFK'
GROUP BY destinationAirport
ORDER BY avg_fare LIMIT 5;