Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on PartiQL: One query language for all your data.
Below are the reasons given in the blog post and I am trying to compare them with Hive SQL + Spark
SQL compatibility - I need to check this as I am not a SQL expert, but Hive SQL seems compatible
First-class nested data - supported
Optional schema and query stability - supported
Minimal extensions - feels same goals in Hive SQL
Format independence - yes
Data store independence - yes.
There are no comments on this comment yet.
Below are the reasons given in the blog post and I am trying to compare them with Hive SQL + Spark
SQL compatibility - I need to check this as I am not a SQL expert, but Hive SQL seems compatible
First-class nested data - supported
Optional schema and query stability - supported
Minimal extensions - feels same goals in Hive SQL
Format independence - yes
Data store independence - yes.