search

JBoRu / StructGPT

The code and data for "StructGPT: A general framework for Large Language Model to Reason on Structured Data"
Apache License 2.0
95 stars 39 forks source link

Evaluate for Spider - sqlite3.OperationalError: unable to open database file #13

Open gianfrancodemarco opened 9 months ago

gianfrancodemarco commented 9 months ago

Hello,

I'm trying to reproduce your results but I'm having trouble running evaluation scripts. In particular, if I run eval_spider_pred.sh or other Spider evaluation scripts I get the error:

Traceback (most recent call last):
  File "evaluate_for_spider.py", line 995, in <module>
    evaluate(path, db_dir, etype, kmaps, db_dir2)
  File "evaluate_for_spider.py", line 525, in evaluate
    schema = Schema(get_schema(db))
  File "/home/gianfranco/Desktop/uni/StructGPT/process_sql.py", line 88, in get_schema
    conn = sqlite3.connect(db)
sqlite3.OperationalError: unable to open database file

It seems that it is trying to open .sqlite files, but I can't find them. Could you provide them or how to build them?

Thanks

JBoRu commented 9 months ago

Hi, Thanks for your attention! I apologize for the late reply! You should download the .sqlite files from the official Spider website (https://yale-lily.github.io/spider).