search

vectorengine / vectorsql

VectorSQL is a free analytics DBMS for IoT & Big Data, compatible with ClickHouse.
https://github.com/vectorengine/vectordb
Apache License 2.0
285 stars 53 forks source link

[feature] implement WITH (Common Table Expressions) #37

Open BohuTANG opened 4 years ago

BohuTANG commented 4 years ago

Summary

MySQL 8.0 CTE:

WITH
  cte1 AS (SELECT a, b FROM table1),
  cte2 AS (SELECT c, d FROM table2)
SELECT b, d FROM cte1 JOIN cte2
WHERE cte1.a = cte2.c;

https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions

tlightsky commented 4 years ago

this feature is cool, will vecotrsql have the same storage fromat as clickhouse btw?

BohuTANG commented 4 years ago

this feature is cool, will vecotrsql have the same storage fromat as clickhouse btw?

Yes, it is preferred.