Find answers from the community

Home
Members
harsha8976
h
harsha8976
Offline, last seen 3 months ago
Joined September 25, 2024
Hi All, I am building a tool which refers the active alarms from SQL database and using SQLAutoVectorQueryEngine for it. Using llama3 with Ollama as LLM. The system was ableto get desired results from databse with right query . However it prints other things which are not expecte with time out exception following are detials of the
_
Enter a question: How many alarms in tel aviv
Querying SQL database: Given the context of translating a natural language query into a SQL query, this option would be most relevant to retrieving the number of alarms in Tel Aviv by querying the alarm_history table.
SQL query: SELECT COUNT() FROM alarm_history WHERE alarmLocation = 'Tel Aviv';SQL response: Based on the SQL response [(4,)], I would synthesize a response to the input question "How many alarms in Tel Aviv" as follows:"There have been 4 alarms in Tel Aviv."Transformed query given SQL response: Based on the original question and the provided SQL query and response, here's my attempt at coming up with a more specific question that needs to be answered:Original question: How many alarms in tel avivSQL query: SELECT COUNT() FROM alarmhistory WHERE alarmLocation = 'Tel Aviv';SQL response: There have been 4 alarms in Tel Aviv.New question: What were the types of alarms or emergency situations that triggered these 4 alarms in Tel Aviv?__
The exception time out also occurring
2 comments
L