RichardErkhov/NickyNicky_-_gemma-1.1-2b-it_text_to_sql_format_chatML_V1-gguf
Quantization made by Richard Erkhov.
gemma-1.1-2b-ittexttosqlformatchatMLV1 - GGUF
- Model creator: https://huggingface.co/NickyNicky/
- Original model: https://huggingface.co/NickyNicky/gemma-1.1-2b-ittexttosqlformatchatMLV1/
Original model description: --- library_name: transformers license: apache-2.0 datasets:
- gretelai/synthetictextto_sql
- NickyNicky/synthetictexttosqlformatchatMLgemma language:
- en
widget:
- text: | <bos><startofturn>system You are a helpful AI assistant. you are a sql expert who responds in json format.<endofturn> <startofturn>user ## prompt: What is the total gold production by 'Site B' in the 'production' table?
## sql context: CREATE TABLE production (id INT, site VARCHAR(50), year INT, goldproduction INT, silverproduction INT);<endofturn> <startofturn>model ---
<p align="center"> <img src="https://cdn-uploads.huggingface.co/production/uploads/641b435ba5f876fe30c5ae0a/Fy2GvAheKCnd3Jj3TbrPG.png" alt="" style="width: 95%; max-height: 750px;"> </p>
Metrics.
TrainOutput(global_step=2509,
training_loss=0.2509715025906736,
metrics={'train_runtime': 22783.0743,
'train_samples_per_second': 8.81,
'train_steps_per_second': 0.11,
'total_flos': 1.820581902144553e+18,
'train_loss': 0.2509715025906736,
'epoch': 2.01
}
)Take dataset.
gretelai/synthetic_text_to_sqlDataset format gemma fine tune.
NickyNicky/synthetic_text_to_sql_format_chatML_gemmacolab examples and Gradio.
https://colab.research.google.com/drive/1-0PsRAqTum2UuvsXb9JtXxLISIUWd8zv?usp=sharinggradio colab.
<p align="center"> <img src="https://cdn-uploads.huggingface.co/production/uploads/641b435ba5f876fe30c5ae0a/X2rf3Z7jJ2WUI7LANw4IH.png" alt="" style="width: 95%; max-height: 750px;"> </p>
$ train
<p align="center"> <img src="https://cdn-uploads.huggingface.co/production/uploads/641b435ba5f876fe30c5ae0a/tLhUyV2uW44-Cf0vwXFbd.png" alt="" style="width: 95%; max-height: 750px;"> </p>
