briefercloud / briefercloud/briefer

athena query fails when returning multiple columns with same name from query

Open
#64 0 comments 0 reactions 0 assignees View on GitHub
bug
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;`
![image](https://github.com/user-attachments/assets/26527df4-9cd5-4d19-81cd-8fcb6514e0b3)

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.