Hugging Face's logo

singhjagpreet
/
text_to_sql

Text2Text Generation
Transformers
TensorBoard
Safetensors
trl
sft
Generated from Trainer
Inference Endpoints
Model card Files Metrics Community
text_to_sql
File size: 2,733 Bytes 
03a588f
2201671
 
 
 
 
 
 
 
 
 
bd6dcef
 
 
 
 
cd4484d
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
03a588f
cd4484d
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
03a588f
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
 
---
license: other
library_name: transformers
tags:
- trl
- sft
- generated_from_trainer
base_model: google/gemma-2b
model-index:
- name: gemma-2b_text_to_sql
  results: []
inference:
  parameters:
    do_sample: false
    max_length: 200
widget:
- text: >-
    CREATE TABLE stadium (
        stadium_id number,
        location text,
        name text,
        capacity number,
    )


    -- Using valid SQLite, answer the following questions for the tables
    provided above.


    -- how many stadiums in total?


    SELECT
  example_title: Number stadiums
- text: >-
    CREATE TABLE work_orders ( ID NUMBER, CREATED_AT TEXT, COST FLOAT,
    INVOICE_AMOUNT FLOAT, IS_DUE BOOLEAN, IS_OPEN BOOLEAN, IS_OVERDUE BOOLEAN,
    COUNTRY_NAME TEXT, )


    -- Using valid SQLite, answer the following questions for the tables
    provided above.


    -- how many work orders are open?


    SELECT
  example_title: Open work orders
- text: >-
    CREATE TABLE stadium ( stadium_id number, location text, name text, capacity
    number, highest number, lowest number, average number )


    CREATE TABLE singer ( singer_id number, name text, country text, song_name
    text, song_release_year text, age number, is_male others )


    CREATE TABLE concert ( concert_id number, concert_name text, theme text,
    stadium_id text, year text )


    CREATE TABLE singer_in_concert ( concert_id number, singer_id text )


    -- Using valid SQLite, answer the following questions for the tables
    provided above.


    -- What is the maximum, the average, and the minimum capacity of stadiums ?


    SELECT
  example_title: Stadium capacity
pipeline_tag: text2text-generation
---
<!-- This model card has been generated automatically according to the information the Trainer had access to. You
should probably proofread and complete it, then remove this comment. -->

# text_to_sql

This model is a fine-tuned version of [google/gemma-2b](https://huggingface.co/google/gemma-2b) on an unknown dataset.

## Model description

More information needed

## Intended uses & limitations

More information needed

## Training and evaluation data

More information needed

## Training procedure

### Training hyperparameters

The following hyperparameters were used during training:
- learning_rate: 0.0002
- train_batch_size: 4
- eval_batch_size: 8
- seed: 42
- gradient_accumulation_steps: 4
- total_train_batch_size: 16
- optimizer: Adam with betas=(0.9,0.999) and epsilon=1e-08
- lr_scheduler_type: linear
- lr_scheduler_warmup_steps: 2
- training_steps: 25
- mixed_precision_training: Native AMP

### Training results



### Framework versions

- PEFT 0.8.2
- Transformers 4.38.0
- Pytorch 2.2.1+cu121
- Datasets 2.17.0
- Tokenizers 0.15.2