Question:
Does Okera support the "LIMIT" predicate push down?
Answer:
Okera supports LIMIT
on JDBC data sources. This improves the preview of data from JDBC data sources where the data is limited to 100 by default from the Okera Web UI.
If the intent is to scan one partition, we recommend using the WHERE predicate. ODAS supports partition pruning, based on the filter. For example: where year=2017, month='Mar', we would hit only that partition.
Okera also supports the LAST (n) PARTITION clause. For more information about partition pruning, refer to the documentation here. The LAST PARTITION clause is described here.
Comments
0 comments
Please sign in to leave a comment.