aws-samples / aws-samples/query-structured-data-with-amazon-bedrock
Error calling table
- Dominant language
- TypeScript
- Stars
- 21
- Forks
- 7
- PR merge metrics
- No merged PRs in 30d
Description
My DB has a table called Riskitems. When I run a query to list all the tables in the DB, it does show `Riskitems` as a table.
when I run a query to show 5 elements from the `Riskitems` table, the translated SQL query is correct but it doesnt produce the result. The error says this:
```
01-09-2024 10:52:33 AM 2024-01-09T18:52:32.999Z ERROR 1 --- [nio-8080-exec-9] i.a.b.d.s.UserQueryExecutionService : Executing the query failed for bedrock result: BedrockResult{explanation=' This query performs a COUNT(*) on the Riskitems table, which will return the total number of records in that table. COUNT(*) counts all rows, regardless of whether they contain NULL values. ', query=' SELECT COUNT(*) FROM Riskitems; '}
01-09-2024 10:52:33 AM java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "riskitems" does not exist
```
The table name gets converted to lower case. Is there a way to fix this?
Contributor guide
Assessment
This issue has not been assessed yet.