Predicate Push down on external JDBC catalog table...
# questions-and-troubleshooting
k
Predicate Push down on external JDBC catalog table Consider following SQL for reference
Copy code
select * 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