If the computer is shut down due to power outage, the training results will be lost. #574
Unanswered
lokwingfai
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
OS: [Ubuntu]
Version: [22.04.4 LTS]
Python: [3.10.12]
Vanna: [2.8.0]
DataBase [Sql Server]
Ollama [mistrail:latest]
ChromaDB
:-After training, vanna answered perfectly.
//--{{ START
Question:
Please generate a SQL statement to retrieve daily sales for January 2023, including the columns : sales date, store code, style code, item description, total quantity, and total sales amount.
Answered:
SELECT
XF_ITEMSADM.XF_TXDATE AS SalesDate,
XF_ITEMSADM.XF_STORECODE AS StoreCode,
XF_ITEMSADM.XF_STYLE AS StyleCode,
XF_ITEMMAS.XF_DESCI AS ItemDescription,
SUM(XF_ITEMSADM.XF_QTY) AS TotalQuantity,
SUM(XF_ITEMSADM.XF_TTLSELPRICE) AS TotalSalesAmount
FROM
XF_ITEMSADM
INNER JOIN
XF_ITEMMAS ON XF_ITEMSADM.XF_STYLE = XF_ITEMMAS.XF_STYLE
WHERE
XF_ITEMSADM.XF_TXDATE BETWEEN '2023-01-01' AND '2023-01-31'
GROUP BY
XF_ITEMSADM.XF_TXDATE, XF_ITEMSADM.XF_STORECODE, XF_ITEMSADM.XF_STYLE, XF_ITEMMAS.XF_DESCI
//--}} END
:- After restarting the computer, I asked the same question and the answer seemed to be that the training results were lost.
//--{{ START
Question:
Please generate a SQL statement to retrieve daily sales for January 2023, including the columns : sales date, store code, style code, item description, total quantity, and total sales amount.
Answered:
SELECT
SalesDate,
StoreCode,
StyleCode,
ItemDescription,
SUM(Quantity) as TotalQuantity,
SUM(Amount) as TotalSalesAmount
FROM
XF_ITEMMVDM_QUE
WHERE
SalesDate >= '2023-01-01' AND
SalesDate <= '2023-01-31' AND
StoreCode IN ('XF_GROUP8', 'XF_GROUP9', 'XF_GROUP10', ..., 'XF_GROUP29') -- Add the store codes you want to include in the query
GROUP BY
SalesDate,
StoreCode,
StyleCode,
ItemDescription
//--}}
Can see that the training data still exists.
Unable to recover, need to start from scratch.
Has anyone experienced this before? Any solution?
Beta Was this translation helpful? Give feedback.
All reactions