Windows 10, Python 3.10
The result of this query should be a date but not here:
AVRO_FILE="C:/working/vendors/source20260312_1743.avro"
db = slothdb.connect()
df = db.sql(f"SELECT max(insertdate) as max_insert_date FROM READ_AVRO('{AVRO_FILE}')").fetchdf()
print(df.iloc[0])
Output:
insertdate
Name: 0, dtype: object
Windows 10, Python 3.10
The result of this query should be a date but not here:
AVRO_FILE="C:/working/vendors/source20260312_1743.avro"
db = slothdb.connect()
df = db.sql(f"SELECT max(insertdate) as max_insert_date FROM READ_AVRO('{AVRO_FILE}')").fetchdf()
print(df.iloc[0])
Output:
insertdate
Name: 0, dtype: object