1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | <code><code><code><code> "user.sqls": [ { "sql": "select key,TUMBLE_START(rowtime, INTERVAL '4' SECOND),target,sum(sum_sar),max(max_sar),count(cnt_sar) from result1 GROUP BY key,target,TUMBLE(rowtime, INTERVAL '4' SECOND)", "attribute.name": "key,start_time,target,sum_sar,max_sar,cnt_sar", "attribute.type": "STRING,SQL_TIMESTAMP,STRING,DOUBLE,DOUBLE,LONG", "result.table.name": "result2", "result.eventtime.colnum": "2", "result.eventtime.coltype": "TIMESTAMP", "result.attribute.name": "key,start_time,target,sum_sar,max_sar,cnt_sar", "result.attribute.type": "STRING,SQL_TIMESTAMP,STRING,DOUBLE,DOUBLE,LONG", }, { "sql": "select key,TUMBLE_START(rowtime, INTERVAL '8' SECOND),target,sum(sum_sar),max(max_sar),count(cnt_sar) from result2 GROUP BY key,target,TUMBLE(rowtime, INTERVAL '8' SECOND)", "attribute.name": "key,start_time,target,sum_sar,max_sar,cnt_sar", "result.table.name": "result3", "result.eventtime.colnum": "2", "result.eventtime.coltype": "TIMESTAMP", "result.attribute.name": "key,start_time,target,sum_sar,max_sar,cnt_sar", "result.attribute.type": "STRING,SQL_TIMESTAMP,STRING,DOUBLE,DOUBLE,LONG", } </code></code></code></code> |