ibis-project / ibis-birdbrain

portable Python ML-powered data bot
https://ibis-project.github.io/ibis-birdbrain/
Apache License 2.0
23 stars 4 forks source link

bug: retry SQL query doesn't work #13

Closed lostmygithubaccount closed 9 months ago

lostmygithubaccount commented 9 months ago

end up w/ something like this: content="The function 'query_tables' encountered an error: cannot access local variable 'res' where it is not associated with a value\n\nThe payload you provided was: {'question': 'Join title ratings and title basics tables on tconst column'}\n\nYou can try to fix the error and call the function again.",

experienced by myself and @ianmcook

in this case, was trying a join -- should fix the retry logic in general, and should consider techniques for making joins more accurate (separate function, constrain to two tables?)

lostmygithubaccount commented 9 months ago

doesn't really matter this will get redone