Hey guys,
I’ve identified strange behavior on a SQL Server connection. When I use some string function, Dremio doesn’t send that function to the source. Ex.:
This query:
SELECT MAX(COL_TEXT)
FROM TABLE
WHERE DATE = ‘2021-12-23’
Result in the same function in JDBC SQL.
This query:
SELECT MAX(LENGTH(COL_TEXT))
FROM TABLE
WHERE DATE = ‘2021-12-23’
Results in:
SELECT COL_TEXT
FROM TABLE
WHERE DATE = ‘2021-12-23’
Unfortunately my table has over 200 million rows for a date causing slowing results.