briefercloud / briefercloud/briefer
athena query fails when returning multiple columns with same name from query
- Dominant language
- TypeScript
- Stars
- 4.3k
- Forks
- 290
- PR merge metrics
- No merged PRs in 30d
Description
This is very easy to reproduce.
1. Create a Athena Data Source, it does not need to connect, you can use any dummy values for the form.
2. Create a SQL Block, select the Athena Data Source and type this query: `SELECT 'value_1' AS col_x, 'value_2' AS col_x;`

Contributor guide
No contributing guide indexed for this repository
Research direction
Reproduce the failure by creating an Athena Data Source, opening a SQL Block, and running SELECT 'value_1' AS col_x, 'value_2' AS col_x. Then trace the Athena query result handling for duplicate column names. Done means the SQL Block no longer fails when the query returns multiple columns with the same name.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws, sql, typescript
- Domain
- data
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100