aws-samples / aws-samples/query-structured-data-with-amazon-bedrock

Error calling table

Open
#5 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.