phoneix常用命令

建表：

CREATE TABLE GPS2("id" BIGINT PRIMARY KEY,"data"."mmsi" VARCHAR,"data"."lon" DOUBLE,"data"."lat" DOUBLE,"data"."sog" DOUBLE,"data"."cog" DOUBLE,"data"."time" BIGINT);

建二级索引：

CREATE INDEX IDX_GPS2_MMSI_TIME ON GPS2("data"."mmsi","data"."time" DESC) include("data"."lon","data"."lat","data"."sog","data"."cog");