CODEWITHSUNDEEP
pythonsqldata-scienceanalyticsdremio
Moinak Dey
Moinak Dey

Reputation: 1

How to fix a data fetching function in python using sql query?

I have developed a function which uses parametrized sql based on user input to fetch records. However, I am facing a type mismatch problem in the where clause of the query. please help me fix it. Start_Date and End_Date are string stype whereas record_date is datetime64[ns]. The Error is stating the the comparison between record_date and start_date and end_date has a type mismatch.

Upvotes: 0

Views: 74

Answers (1)

Alex Merced
Alex Merced

Reputation: 150

I noticed you tagged Dremio, Dremio doesn't support parameterized queries at the moment (up to version 24), but that should eventually be supported.

Upvotes: 0

Related Questions