Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Empty databases #14

Closed
nweir127 opened this issue Dec 11, 2018 · 3 comments
Closed

Empty databases #14

nweir127 opened this issue Dec 11, 2018 · 3 comments

Comments

@nweir127
Copy link

Hello, it seems that a number of the sqlite3 files provided are completely unpopulated. Is this by design? It doesn't seem to be based on the train/dev/test split.

Example empty datasets:
geo
car_1
wta_1

@nweir127
Copy link
Author

nweir127 commented Dec 11, 2018

On a similar note, the geo schema is missing a primary key and foreign key for the lake table (line 43715). There are also errors in the formula_1 schema. Could you verify that each of the schemas provided in tables.json is correct?

@taoyds
Copy link
Owner

taoyds commented Dec 17, 2018

Hi,

Thanks! We updated the following 7 sqlite files in database/ dir (these SQLite files were created based on several files. ) Please download spider data from the official website again.
car_1,
wine_1,
student_1,
csu_1,
inn_1,
flight_2,
formula_1

For the databases below, since they are traditional datasets created by others and do not have real database published online. Therefore, we only provide their schemas.

geo
yelp
scholar
restaurants
Advising
imdb
academic

@taoyds
Copy link
Owner

taoyds commented Dec 17, 2018

For the schema issue, all schemas in tables.json were extracted from the databases. You can send me your specific findings via email if you found some serous problems. We will update them together via the next release.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants