Kumar Sambhav Jain
03/22/2026, 4:50 AMselect * from JDBC_catalog_table plv where plv.column_id in (select column_id from starrocks_table where starrocks_table_column = '2025-05-05');
JDBC_catalog_table is table in SqlServer which I am accessing in Starrocks through JDBC catalog. This table is huge. I am trying to ingest this table in Starrocks in small batches.
In the Query plan, I can see that Starrocks is not adding where condition based on the plv.column_id column resulting in full table scan of the huge table in SqlServer.
How to ensure that predicate pushdown happens everytime an external JDBC catalog table is involved ?
Thanks