clickhouse 实现序号自增
1.说明
clickhouse的主键不会自增,具体看官网
2.实现序号自增SQL
with a as (select rowNumberInAllBlocks() ID ,VIN from order )
SELECT a.ID , * FROM order b JOIN a ON a.VIN = b.VIN
说明:表名 order 设置的自增字段是ID
clickhouse 实现序号自增
1.说明
clickhouse的主键不会自增,具体看官网
2.实现序号自增SQL
with a as (select rowNumberInAllBlocks() ID ,VIN from order )
SELECT a.ID , * FROM order b JOIN a ON a.VIN = b.VIN
说明:表名 order 设置的自增字段是ID