Sinaptik-AI / pandas-ai

Chat with your database (SQL, CSV, pandas, polars, mongodb, noSQL, etc). PandasAI makes data analysis conversational using LLMs (GPT 3.5 / 4, Anthropic, VertexAI) and RAG.
https://pandas-ai.com
Other
11.69k stars 1.08k forks source link

(cx_Oracle.DatabaseError) ORA-00904: "RAND": invalid identifier #1160

Closed eaandersen closed 1 month ago

eaandersen commented 1 month ago

System Info

OS version: Microsoft Windows 11 Pro, 10.0.22631 Build 22631 Python version: 3.10.4 pandas-ai version: 2.0.42

🐛 Describe the bug

Unfortunately, I was not able to get your answers, because of the following error:

(cx_Oracle.DatabaseError) ORA-00904: "RAND": invalid identifier [SQL: SELECT * FROM TABLE ORDER BY RAND() ASC FETCH FIRST 3 ROWS ONLY] (Background on this error at: https://sqlalche.me/e/20/4xp6)