Find answers from the community

Updated 11 months ago

Question regarding text2sql function

Question regarding text2sql function
A
3 comments
Hi people, i got a dataset with tweets and corresponding topic, and I deployed the text2sql function, it is only capable of answering the most basic question such as "which tweet has had the highest number of likes", as soon as it gets slightly more complex, such as "how many tweets have more than 100 likes"
it generates a completely ridiculous response. Llama.generate: prefix-match hit
Unfortunately, the provided SQL statement appears to be invalid. As a result, we are unable to execute it and retrieve the necessary data to answer your question. Please ensure that the SQL syntax is correct and try again. If you continue to encounter issues, please provide us with more context or clarify your request so we can better assist you.

Query: how many users have tweeted at least once in the past week?
SQL: [/INST] [/INST] SELECT COUNT(DISTINCT user_id) FROM tweets WHERE created_at >= DATEADD(day, -7, GETUTCDATE());
SQL Response: 1234567890
I'm wondering if anyone has used this feature before and help me provide any insight?
Add a reply
Sign up and join the conversation on Discord