PartiQL: One query language for all your data
aws.amazon.com
PartiQL: One query language for all your data
1–10 of 88 posts
Re: PartiQL: One query language for all your data
#2'SQL’s ORDER BY orders the output data. Similarly, the PartiQL ORDER BY is responsible for turning its input bag into an array.'
That is the most important thing for my uses. I deal mostly in time series data, SQL windowing queries are too slow. Turning the set into an array to allow indexing and support easy time series queries is enough for me the use it.
Re: PartiQL: One query language for all your data
#3 PartiQL> SELECT * FROM [1,2,3]
|
==='
>
---
OK! (86 ms)
Re: PartiQL: One query language for all your data
#4PartiQL> SELECT * FROM [1,2,3] | ===' > --- OK! (86 ms) Jeez. 86ms for this query on this data set? Hope that's not representative of the general performance!
This is on the JVM so the JIT's optimizations probably haven't kicked in yet.
Re: PartiQL: One query language for all your data
#5Anyone know how this compares to Presto and zetasql?
Re: PartiQL: One query language for all your data
#6I wonder how this deals with nested parquet data, and whether it's able to optimise on the things parquet provides.
Re: PartiQL: One query language for all your data
#7Interesting that they opted for a relational rather than a categorical one; the latter is proving to be more flexible [0].
Re: PartiQL: One query language for all your data
#8I wonder how this deals with nested parquet data, and whether it's able to optimise on the things parquet provides.
It would be possible to integrate parquet data with PartiQL.
Here is an example of integrating PartiQL with CSV files. https://github.com/partiql/partiql-lang-kotlin/blob/master/e.... Integrating with Parquet would of course be more complex then that.
Re: PartiQL: One query language for all your data
#9Anyone know how this compares to Presto and zetasql?
Presto 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.
Re: PartiQL: One query language for all your data
#10Interesting that they opted for a relational rather than a categorical one; the latter is proving to be more flexible [0]. [0] https://www.categoricaldata.net/
Interesting project. Thanks for sharing.