sqllama-V0 / res3.txt
matt-tries-dl's picture
trained v3
8965eb9
/home/matt/hf/sqllama-V0/.venv/lib/python3.7/site-packages/bitsandbytes/cuda_setup/main.py:136: UserWarning: /opt/conda did not contain libcudart.so as expected! Searching further paths...
warn(msg)
The tokenizer class you load from this checkpoint is not the same type as the class this function is called from. It may result in unexpected tokenization.
The tokenizer class you load from this checkpoint is 'LLaMATokenizer'.
The class this function is called from is 'LlamaTokenizer'.
===================================BUG REPORT===================================
Welcome to bitsandbytes. For bug reports, please submit your error trace to: https://github.com/TimDettmers/bitsandbytes/issues
================================================================================
CUDA SETUP: CUDA runtime path found: /usr/local/cuda/lib64/libcudart.so
CUDA SETUP: Highest compute capability among GPUs detected: 7.5
CUDA SETUP: Detected CUDA version 113
CUDA SETUP: Loading binary /home/matt/hf/sqllama-V0/.venv/lib/python3.7/site-packages/bitsandbytes/libbitsandbytes_cuda113.so...
Output exceeds the size limit. Open the full output data in a text editor
table: 2-16050349-13
columns: Rank,Name,Team,Games,Points
Q: What is Games, when Points is less than 340, and when Rank is greater than 3?
A: SELECT Games FROM 2-16050349-13 WHERE Points < 340 AND Rank > 3
END
table: 1-28962227-1
columns: Series,Premiere,Finale,Runners-up,Winner
Q: What is the date of the finale where Holly Bell was runner-up?
A: SELECT Finale FROM 1-28962227-1 WHERE Runners-up = 'Holly Bell'
END
table: 2-10652530-2
columns: Week,Date,Opponent,Result,Stadium,Record,Attendance
Q: What was the Browns record after they played the game at the Paul Brown stadium?
A: SELECT Record FROM 2-10652530-2 WHERE Stadium = 'paul brown stadium'
END
table: 2-18379129-4
columns: play,author,company,base,country
Q: Who is the author of the Play Electra?
...
Q: What is 02-03, when School Year is % Learning In Latvian?
A: SELECT 02-03 FROM 2-16158579-1 WHERE School year = '% learning in latvian'
END
True
92
0
count 56355.000000
mean 101.219519
std 21.740325
min 63.000000
25% 87.500000
50% 97.000000
75% 109.000000
max 461.000000
32084
[500/500 7:38:36, Epoch 1/2]
Step Training Loss
1 2.748800
2 2.723800
3 2.737600
4 2.707100
5 2.692800
6 2.720700
7 2.681400
8 2.736400
9 2.701800
10 2.711700
11 2.685800
12 2.684300
13 2.686300
14 2.698800
15 2.659300
16 2.688900
17 2.661800
18 2.677700
19 2.647100
20 2.679800
21 2.652000
22 2.628900
23 2.656100
24 2.669100
25 2.667800
26 2.636300
27 2.616800
28 2.630600
29 2.621000
30 2.602000
31 2.607900
32 2.635800
33 2.594600
34 2.604400
35 2.618900
36 2.563400
37 2.589200
38 2.552100
39 2.583600
40 2.554500
41 2.557400
42 2.536700
43 2.535000
44 2.557900
45 2.530100
46 2.527900
47 2.510100
48 2.539100
49 2.500100
50 2.536200
51 2.487100
52 2.521700
53 2.532600
54 2.494500
55 2.468900
56 2.468700
57 2.474300
58 2.480900
59 2.442800
60 2.472800
61 2.452900
62 2.452000
63 2.443100
64 2.446700
65 2.415100
66 2.376300
67 2.411500
68 2.403900
69 2.383800
70 2.427800
71 2.419400
72 2.371900
73 2.364400
74 2.360000
75 2.337600
76 2.332800
77 2.315700
78 2.344200
79 2.331700
80 2.303100
81 2.324700
82 2.285900
83 2.268000
84 2.260600
85 2.286100
86 2.233600
87 2.266200
88 2.217000
89 2.249300
90 2.239000
91 2.221900
92 2.223300
93 2.179500
94 2.204400
95 2.193200
96 2.163800
97 2.158200
98 2.127700
99 2.141400
100 2.121400
101 2.115500
102 2.125200
103 2.140100
104 2.118400
105 2.110400
106 2.097300
107 2.071400
108 2.083400
109 2.090200
110 2.078200
111 2.061100
112 2.047500
113 2.006100
114 2.023800
115 2.014000
116 2.008800
117 1.988800
118 1.984900
119 1.971000
120 1.924100
121 1.953100
122 1.957800
123 1.952500
124 1.890400
125 1.915900
126 1.901100
127 1.879900
128 1.834100
129 1.855900
130 1.853800
131 1.869200
132 1.821400
133 1.835100
134 1.817700
135 1.785800
136 1.764000
137 1.796800
138 1.751100
139 1.756500
140 1.789900
141 1.773100
142 1.729200
143 1.700200
144 1.721200
145 1.690600
146 1.687700
147 1.743500
148 1.690000
149 1.687200
150 1.663000
151 1.648600
152 1.667100
153 1.665600
154 1.647000
155 1.629500
156 1.620800
157 1.616400
158 1.658500
159 1.593900
160 1.604300
161 1.621200
162 1.607900
163 1.591100
164 1.598100
165 1.579700
166 1.545500
167 1.582100
168 1.568300
169 1.557900
170 1.561300
171 1.521800
172 1.542500
173 1.502300
174 1.513900
175 1.501500
176 1.551200
177 1.495600
178 1.504000
179 1.512500
180 1.488200
181 1.492200
182 1.494300
183 1.494800
184 1.446100
185 1.514700
186 1.450900
187 1.476900
188 1.447100
189 1.490800
190 1.433200
191 1.438100
192 1.410500
193 1.422600
194 1.405500
195 1.439400
196 1.448100
197 1.410200
198 1.403800
199 1.464400
200 1.417700
201 1.419500
202 1.419400
203 1.387700
204 1.400400
205 1.404700
206 1.398400
207 1.358000
208 1.359600
209 1.367700
210 1.358600
211 1.369200
212 1.373700
213 1.395100
214 1.360800
215 1.343900
216 1.330300
217 1.328800
218 1.369900
219 1.346300
220 1.379700
221 1.326000
222 1.334600
223 1.339100
224 1.349200
225 1.324800
226 1.303600
227 1.299900
228 1.338800
229 1.331800
230 1.351400
231 1.314200
232 1.293600
233 1.322100
234 1.295800
235 1.302500
236 1.338900
237 1.308900
238 1.290100
239 1.323300
240 1.270500
241 1.246300
242 1.303900
243 1.324800
244 1.216000
245 1.303500
246 1.304900
247 1.273300
248 1.278300
249 1.252000
250 1.283400
251 1.271600
252 1.300300
253 1.265800
254 1.249200
255 1.252600
256 1.265500
257 1.228600
258 1.257300
259 1.288900
260 1.257200
261 1.243700
262 1.272100
263 1.252000
264 1.264900
265 1.268800
266 1.256000
267 1.230200
268 1.231700
269 1.243400
270 1.285200
271 1.225500
272 1.217900
273 1.209200
274 1.224200
275 1.226400
276 1.261500
277 1.223900
278 1.244000
279 1.226600
280 1.235000
281 1.213400
282 1.177600
283 1.218100
284 1.231900
285 1.200900
286 1.223400
287 1.235100
288 1.232500
289 1.230100
290 1.225900
291 1.182700
292 1.237100
293 1.201000
294 1.213000
295 1.205500
296 1.181900
297 1.198300
298 1.195200
299 1.215000
300 1.195500
301 1.186100
302 1.174900
303 1.184400
304 1.207100
305 1.181100
306 1.195300
307 1.189000
308 1.180200
309 1.167200
310 1.206700
311 1.203600
312 1.186600
313 1.224100
314 1.180000
315 1.186600
316 1.150700
317 1.165700
318 1.178100
319 1.148300
320 1.153600
321 1.189200
322 1.182100
323 1.183800
324 1.202900
325 1.196600
326 1.200800
327 1.153100
328 1.212400
329 1.167300
330 1.188300
331 1.179300
332 1.211400
333 1.169900
334 1.179300
335 1.153300
336 1.188900
337 1.179200
338 1.217300
339 1.169700
340 1.177700
341 1.197300
342 1.177800
343 1.169700
344 1.186800
345 1.180000
346 1.193400
347 1.171900
348 1.190000
349 1.160900
350 1.170800
351 1.166900
352 1.183200
353 1.118200
354 1.185900
355 1.157800
356 1.160200
357 1.184200
358 1.172100
359 1.143800
360 1.178000
361 1.157900
362 1.151700
363 1.196600
364 1.181800
365 1.195600
366 1.165000
367 1.157300
368 1.165200
369 1.167700
370 1.184900
371 1.168400
372 1.150500
373 1.152900
374 1.158900
375 1.143900
376 1.157200
377 1.146800
378 1.142600
379 1.140600
380 1.142400
381 1.114100
382 1.169700
383 1.142500
384 1.176000
385 1.160600
386 1.164700
387 1.124000
388 1.134500
389 1.185500
390 1.154300
391 1.125500
392 1.174400
393 1.132800
394 1.145200
395 1.129800
396 1.140600
397 1.126000
398 1.182800
399 1.127800
400 1.155000
401 1.134600
402 1.155900
403 1.150400
404 1.141700
405 1.131500
406 1.169600
407 1.170500
408 1.129100
409 1.151700
410 1.168200
411 1.109100
412 1.129700
413 1.143900
414 1.157300
415 1.128900
416 1.171500
417 1.141600
418 1.157700
419 1.137000
420 1.154000
421 1.167300
422 1.137400
423 1.121500
424 1.128500
425 1.130300
426 1.162100
427 1.155100
428 1.145300
429 1.121000
430 1.182200
431 1.157000
432 1.162300
433 1.135200
434 1.141300
435 1.151700
436 1.148000
437 1.132500
438 1.163000
439 1.116300
440 1.142000
441 1.091700
442 1.141500
443 1.154900
444 1.120400
445 1.173700
446 1.138300
447 1.135600
448 1.138800
449 1.126800
450 1.129400
451 1.146300
452 1.104200
453 1.163500
454 1.169300
455 1.147100
456 1.157100
457 1.122100
458 1.121900
459 1.150500
460 1.115700
461 1.121100
462 1.123400
463 1.097500
464 1.103800
465 1.167700
466 1.130000
467 1.164500
468 1.127200
469 1.133800
470 1.132700
471 1.122800
472 1.159500
473 1.122900
474 1.105000
475 1.145700
476 1.086400
477 1.112600
478 1.139300
479 1.135000
480 1.135200
481 1.117500
482 1.102300
483 1.147700
484 1.119200
485 1.125800
486 1.135400
487 1.149500
488 1.099400
489 1.153900
490 1.122700
491 1.089400
492 1.167200
493 1.151300
494 1.131400
495 1.131400
496 1.145200
497 1.125700
498 1.119300
499 1.128600
500 1.121000
/home/matt/hf/sqllama-V0/.venv/lib/python3.7/site-packages/transformers/generation/utils.py:1220: UserWarning: You have modified the pretrained model configuration to control generation. This is a deprecated strategy to control generation and will be removed soon, in a future version. Please use a generation configuration file (see https://huggingface.co/docs/transformers/main_classes/text_generation)
"You have modified the pretrained model configuration to control generation. This is a"
/home/matt/hf/sqllama-V0/.venv/lib/python3.7/site-packages/torch/utils/checkpoint.py:31: UserWarning: None of the inputs have requires_grad=True. Gradients will be None
warnings.warn("None of the inputs have requires_grad=True. Gradients will be None")
Output exceeds the size limit. Open the full output data in a text editor
from model
<unk>table: 2-11561331-17
columns: Name,Actual version,System,Platform,License
Q: Which System's Name is Steem, and has a Freeware License?
A: SELECT Name FROM 2-11561331-17 WHERE License = 'Freeware' AND System = 'Steem'
END
\end{code}
expected answer
SELECT System FROM 2-11561331-17 WHERE License = 'freeware' AND Name = 'steem'
END
from model
<unk>table: 1-18847736-2
columns: Game,Date,Opponent,Result,Dolphins points,Opponents,Record,Attendance
Q: What is the date when the opponent is the New England Patriots?
A: SELECT Date FROM 1-18847736-2 WHERE Opponent = 'New England Patriots'
END
\end
expected answer
SELECT Date FROM 1-18847736-2 WHERE Opponent = 'New England Patriots'
END
...
expected answer
SELECT Manufacturer FROM 1-17801022-1 WHERE Date = 'November 2'
END