示例脚本如下:
ids = ["024bafec-0adc-4e51-bffe-793085c0559e", "018b8110-ca1b-4f1e-97b2-0363c8ed49ae", "0164480b-11a8-4312-91e0-c96f9faac95c"] result = select * from loadTable('dfs://GZB_TSDB', 'data') where time between 2021.01.01T00:00:00.000 : 2021.01.01T00:10:00.000, id in ids iif(result.size() <= 100, result, result[sort rand(0..(result.size()-1),100)]) // rand会出现重复选择情况 iif(result.size() <= 100, result, result[sort(take(shuffle(0..(result.size()-1)),100), false)])