This task is about an error I am receiving when attempting to run a query using Superset's sqllab.
Note: I thought #product-infrastructure-data and Product-Analytics might be good people to make aware of this issue, although if there are other/different people who should be notified, please edit the tags accordingly.
Behavior
- Visit: https://superset.wikimedia.org/superset/sqllab
- Set the Database field to: presto_analytics_hive
- Set the Schema field to event
- Paste in the following query
SELECT event.save_failure_type, event.save_failure_message, count(*) as count from editattemptstep where event.integration='discussiontools' and event.action='saveFailure' group by event.save_failure_type, event.save_failure_message order by count desc
- Click RUN
Actual
- ❗️Notice the following error in the Results tab: presto error: Failed to list directory: hdfs://analytics-hadoop/wmf/data/event/EditAttemptStep/year=2021/month=1/day=9/hour=8
Expected
- ✅Query executes; data is returned in the Results tab
Meta
- Superset User Name: ppel
- Role: [Alpha]
- Email associated with account: ppelberg@wikimedia.org