gap-text2sql icon indicating copy to clipboard operation
gap-text2sql copied to clipboard

Query formed for total irrelevant input string

Open Mohdwajtech opened this issue 4 years ago • 3 comments

Hi, I was trying this on a dummy database attached with couple of tables. I observed that for a totally irrelevant input text it still outputs a query. Can we have a confidence score too along with the query in the response so that we can look into the confidence value and decide how relevant it is. Attached a screenshot of the issue too sqlprblm

Mohdwajtech avatar Jun 22 '21 07:06 Mohdwajtech

How you managed to run this notebook @Mohdwajtech, i unable to run it every time i face some errors.

Pls Help!

alan-ai-learner avatar Jul 26 '21 10:07 alan-ai-learner

There is a score field in the inference output such as ie_dirs/bart_run_1_true_1-step41000.infer. This score might be helpful for helping you to identify low-confidence prediction.

Impavidity avatar Aug 23 '21 02:08 Impavidity

@Impavidity Thanks for your response. It helps. One more question I had. In case when I am running this on my own database, it is giving me error while I am adding more than 16 tables. The error I have shared below in the picture. Could you help me with this?

text2sql_error

Mohdwajtech avatar Aug 30 '21 08:08 Mohdwajtech