...
Plain FROM | Simple COUNT | Simple WHERE | Primary key lookup | Groups and aggregates | |
---|---|---|---|---|---|
CSV | Streaming | Greedy when exact. Native when approximated. | Client-side | No PK | Greedy |
JDBC | Streaming | Native (all variants) | Native | Native | Native |
Excel | Streaming XLSX Greedy XLS | Native | Client-side | No PK | Greedy |
POJO | In memory | Native | Client-side | No PK | Greedy |
CouchDB | Streaming | Native | Native | Native | Greedy |
MongoDB | Streaming | Native | Native | Native | Greedy |
ElasticSearch | Paged | Native | Native | Native | Greedy |
HBase | Streaming | Native | Client-side | Native | Greedy |
Cassandra | Paged | Native | Client-side | Native | Greedy |
Amazon DynamoDB | Paged | Native | Client-side | Native | Greedy |
JSON | Streaming | Greedy | Client-side | No PK | Greedy |
XML | Streaming SAX In-memory DOM | Greedy | Client-side | Greedy | Greedy |
Salesforce.com | Paged | Native | Native | Native | Greedy |
SugarCRM | Paged | Native | Native | Greedy | Greedy |