I'm using the following code:
import connectorx as cx
cx_con = f"sqlite:C:\\Users\\X\\PycharmProjects\\Bot\\Trading Data\\{get_trading_database()}.db"
df = cx.read_sql(conn=cx_con,query=f"SELECT * FROM daily_quotes;"partition_on="quoteTimeInLong")
and getting the following error when I add the "partition_on" argument:
Traceback (most recent call last): File "C:\Users\X\PycharmProjects\Bot\main.py", line 1065, in cx_df_dict = read_symbol_data_from_db(query_type='cx').values() File "C:\Users\X\PycharmProjects\Bot\main.py", line 499, in read_symbol_data_from_db df = cx.read_sql(conn=cx_con, File "C:\Users\X\PycharmProjects\venv\lib\site-packages\connectorx\init.py", line 224, in read_sql result = _read_sql( TypeError: argument 'partition_query': Unable to convert key: num
The query works just fine if I omit partition_on, but from my understanding I can speed things up further if I add this argument.