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