hudi sql

DROP TABLE IF EXISTS hudi;
CREATE TABLE hudi(ts BIGINT, uuid VARCHAR(40) PRIMARY KEY NOT ENFORCED, rider VARCHAR(20), driver VARCHAR(20), event VARCHAR(255), fare DOUBLE, process BIGINT, city VARCHAR(20)) PARTITIONED BY (`city`) WITH ('connector' = 'hudi', 'path' = 'hdfs://10.7.215.57:9000/flink/hudi', 'table.type' = 'MERGE_ON_READ');
INSERT INTO hudi VALUES (1,'334e26e9-8355-45cc-97c6-c31daf0df330','rider-A','driver-K','2024-06-16 14:27:49',19.10,1718519269029,'北京'), (2,'e96c4396-3fad-413a-a942-4cb36106d721','rider-C','driver-M','2024-06-16 14:27:49',27.70 ,1718519269029,'上海'), (3,'9909a8b1-2d15-4d3d-8ec9-efc48c536a00','rider-D','driver-L','2024-06-16 14:27:49',33.90 ,1718519209029,'苏州'), (4,'1dced545-862b-4ceb-8b43-d2a568f6616b','rider-E','driver-O','2024-06-16 14:27:49',93.50,1718512269029,'南京'), (5,'e3cf430c-889d-4015-bc98-59bdce1e530c','rider-F','driver-P','2024-06-16 14:27:49',34.15,1718516269029,'广州'), (6,'7a84095f-737f-40bc-b62f-6b69664712d2','rider-G','driver-Q','2024-06-16 14:27:49',43.40 ,1718519269029,'深圳'), (7,'3eeb61f7-c2b0-4636-99bd-5d7a5a1d2c04','rider-I','driver-S','2024-06-16 14:27:49',41.06 ,1718512265029,'天津'), (8,'c8abbe79-8d89-47ea-b4ce-4d224bae5bfa','rider-J','driver-T','2024-06-16 14:27:49',17.85,171851369029,'石家庄');