BIRD Support

[JaviS-Rei]

Hello,
Is there a version available that supports the BIRD dataset? I noticed that there is support for BIRD in the code, but I am not sure if the fewshot folder needs to be regenerated on the BIRD training set (processor.py) or just use it without regeneration?

[Nisha03-wd]

Decomposition for Enhancing Attention: Improving LLM-based Text-to-SQL through Workflow Paradigm can u plz give how to run the i did all but i m not able to access database. Will you plz help me

[FlyingFeather]

Thank you very much for your attention to our work. The fewshot file for 'bird' is not using the current results in the repository. Recently, we have supplemented experiments on the bird dataset, but the relevant code has not been updated yet. It is expected to be updated within the next two weeks. Best regards

[FlyingFeather]

Decomposition for Enhancing Attention: Improving LLM-based Text-to-SQL through Workflow Paradigm can u plz give how to run the i did all but i m not able to access database. Will you plz help me

Could you please be more specific? Are you unable to connect to the database with SQLite? You might want to check if the file exists and if the dependent environment is fully installed.

[Nisha03-wd]

Downloaded the data set from the Spider website and i made the data folder and uplode the dataset but i get the error that PS C:\Users\91862\OneDrive\Desktop\Text To Sql\DEA-SQL> python evaluation/test-suite-sql-eval/evaluation.py --gold "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/evaluation/gold_files/spider_dev_gold.sql" --pred "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/outputs/spider/dea-sql.txt" --db "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/data/spider/database/example.db" --print_file_name "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/outputs/spider/spider-dea-sql.txt" --table "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/data/spider/tables.json" --etype exec 0 Traceback (most recent call last): File "C:\Users\91862\OneDrive\Desktop\Text To Sql\DEA-SQL\evaluation\test-suite-sql-eval\evaluation.py", line 1013, in <module> evaluate(args.gold, args.pred, args.db, args.etype, kmaps, args.plug_value, File "C:\Users\91862\OneDrive\Desktop\Text To Sql\DEA-SQL\evaluation\test-suite-sql-eval\evaluation.py", line 593, in evaluate schema = Schema(get_schema(db)) File "C:\Users\91862\OneDrive\Desktop\Text To Sql\DEA-SQL\evaluation\test-suite-sql-eval\process_sql.py", line 88, in get_schema conn = sqlite3.connect(db) sqlite3.OperationalError: unable to open database file Can You please tell me how to run this like the line of code beacause i use this "python evaluation/test-suite-sql-eval/evaluation.py --gold "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/evaluation/gold_files/spider_dev_gold.sql" --pred "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/outputs/spider/dea-sql.txt" --db "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/data/spider/database/example.db" --print_file_name "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/outputs/spider/spider-dea-sql.txt" --table "C:/Users/91862/OneDrive/Desktop/Text To Sql/DEA-SQL/data/spider/tables.json" --etype exec " Which i get from chtgpt

…

On Sun, 14 Jul 2024 at 14:12, Feather ***@***.***> wrote: Decomposition for Enhancing Attention: Improving LLM-based Text-to-SQL through Workflow Paradigm can u plz give how to run the i did all but i m not able to access database. Will you plz help me Could you please be more specific? Are you unable to connect to the database with SQLite? You might want to check if the file exists and if the dependent environment is fully installed. — Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5LQHBO7SI5UPAR72FWVWLTZMI2WRAVCNFSM6AAAAABKUY35WOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMRXGI3DONZVGA> . You are receiving this because you commented.Message ID: ***@***.***>

[JaviS-Rei]

Thank you very much for your attention to our work. The fewshot file for 'bird' is not using the current results in the repository. Recently, we have supplemented experiments on the bird dataset, but the relevant code has not been updated yet. It is expected to be updated within the next two weeks. Best regards

Thanks for reply. Waiting for bird version and after that this issue will be close.

[downeykking]

Decomposition for Enhancing Attention: Improving LLM-based Text-to-SQL through Workflow Paradigm can u plz give how to run the i did all but i m not able to access database. Will you plz help me

Hello, thank you for attention to our work! We have updated a more detailed environment setup in README.md. You can re-install the environment by following the instructions in setup steps. Then run
python evaluation/test-suite-sql-eval/evaluation.py --gold "evaluation/gold_files/spider_dev_gold.sql" --pred "outputs/spider/dea-sql.txt" --db ./data/spider/database --print_file_name "outputs/spider/spider-dea-sql.txt" --table './data/spider/tables.json' --etype exec and check whether you can get result like this:

Hope this could help you.

[JaviS-Rei]

It has been two weeks since our last communication, and there is any progress on opening BIRD related data and code? They are extremely beneficial to our ongoing research, and potentially help our work to contribute to the SE and DB community.
Thank you for your time and consideration.

[FlyingFeather]

It has been two weeks since our last communication, and there is any progress on opening BIRD related data and code? They are extremely beneficial to our ongoing research, and potentially help our work to contribute to the SE and DB community. Thank you for your time and consideration.

Thank you very much for your interest in our work. Because we are currently intensively conducting a new research work related to the bird data set, it is expected that the update of this code will be postponed. Once updated, we will contact you about this issue and hope to be able to help you by then.

In addition, the fewshot file you mentioned earlier is not used in the bird data set. As explained in the article, it is not a core module and the effect is not significant in GPT-3.5.

[2514387775]

Project Name: China Urban Bird Dataset

Project Description: We are compiling a dataset of birdwatching records from citizens across various cities in China for scientific research related to bird conservation. We welcome data sources from any channel, including but not limited to structured species distribution databases, citizen science projects, social media data, and historical literature data.

Data Requirements Details: The data sources we need should at least include species name, geographic information (precise coordinates or specific locations), and observation dates. It would be best if the data also included specific information such as the species' Latin name, Chinese name, and English name. We require data sources that are within the scope of China and at the urban scale.

Contribution Guidelines: We hope for submissions in Excel or CSV format, and other table formats compatible with the Windows system are also acceptable. We prefer data to be shared under a free license agreement, but we also support acquiring data through compensated purchase arrangements.

Contact Information: Please submit to the email address 2514387775@qq.com.