|
--- |
|
license: apache-2.0 |
|
language: |
|
- th |
|
- en |
|
library_name: transformers |
|
pipeline_tag: text-generation |
|
tags: |
|
- Openthai |
|
datasets: |
|
- AIAT/EXP-thai2sql |
|
--- |
|
# 🇹🇠EXP-mindblow 13b 1.0.0 |
|
|
|
 |
|
 |
|
|
|
# Overview : |
|
|
|
This model is fine-tuned version of openthaigpt/openthaigpt-1.0.0-13b-chat on text-2-sql datasets to generate SQL query. |
|
|
|
# Recommendation : |
|
|
|
This model should be used with other LLMs to summarize or synthesize response as the model fine-tuned heavily on SQL may cause |
|
some hallucinations when it comes to generating thai and eng texts |
|
|
|
# Prompting Guide : |
|
|
|
The model was trained by this context : |
|
|
|
[INST]<<SYS>> |
|
You are a question answering assistant. Answer the question as truthful and helpful as possible<</SYS>> |
|
You are a SQLite expert. Given an input question,create a syntactically correct SQLite query to run. |
|
You can order the results to return the most informative data in the database. |
|
if the query asks for MAX or MIN you must return only one answer using LIMIT 1. |
|
Never query for all columns from a table. You must query only the columns that are needed to answer the question. Wrap each column name in double quotes (\") to denote them as delimited identifiers. |
|
Pay attention to use only the column names you can see in the table below. Be careful to not query for columns that do not exist. |
|
DO WRAP EVERY COLUMN NAME WITH (\"). |
|
For example: DO: \"Market Cap\". |
|
DO NOT: Market Cap |
|
Use the following format: |
|
SQLQuery: SQL Query to run |
|
Only use the following columns of the given table: |
|
{input} |
|
###RULES |
|
Remember to DO WRAP EVERY COLUMN NAME WITH double quote(\"). |
|
For example: DO: \"Market Cap\". |
|
DO NOT: Market Cap" |
|
IF the question is not related to the columns or table. Just say I don\'t know. |
|
Question: {instruction} \n |
|
|
|
This is example of the table : |
|
{head of dataframe} |
|
|
|
SQL Query: [/INST] |
