3 ms·
Anyone know how this compares to Presto and zetasql?
by zellyn 7y ago
Anyone know how this compares to Presto and zetasql?
- manigandham 7y agoPresto is a distributed query engine that can run queries across different datasources. It accepts a basic ANSI SQL syntax. ZetaSQL is a custom SQL dialect, along with parser and analyzer, that Google uses for products like BigQuery and Spanner. PartiQL is a new query language extended from SQL to work with various non-relational data sources and schemaless data formats in a more natural and idiomatic way.
- dlurton 7y agoOne big difference is native support for nested data that's built right into the syntax of the language. Most other SQL implementations allow support for nested data through functions which have non-intuitive syntax.
- cmollis 7y agoWe generally build views to unnest the arrays, maps, and structs and query from them (or build other tables from the views in hive) but something like this is certainly a bit easier
- cwyers 7y agoI also am trying to figure out how this stacks up against Apache Drill.
- manigandham 7y agoIt's just a language, not a query engine. You can add PartiQL to Drill and Presto so that they can support a richer querying syntax over the unstructured/schemaless data sources they handle.