opensearch-project / opensearch-project/sql-odbc
[BUG]Aggregate functions in PowerBI fail
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 10
- Forks
- 25
- PR merge metrics
- No merged PRs in 30d
Description
Describe the bug
Visualizations with Minimum, Maximum, Standard deviation, Variance, or Median options selected fail to load.
To Reproduce
Steps to reproduce the behavior:
- Start PowerBI
- Connect to OpenSearch
- Drag a numerical column into the workspace
- Select one of the aggregate functions listed above
- See visualization error in the workspace
Expected behavior
The result should be have the expected value of the corresponding aggregate function.
Screenshots
Additional context
Using OpenSearch version 1.2.0
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the failure in PowerBI with OpenSearch 1.2.0 through the ODBC driver, following the listed aggregation steps. No source files or tests are named, so trace the driver path handling Minimum, Maximum, standard deviation, variance, and median. Done means each listed function loads in the visualization and returns its expected value.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100