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