我需要在宝藏数据中使用临时时间范围表来查询我的SQL查询:
CREATE TEMPORARY TABLE fakehours (Hour BIGINT); INSERT INTO Hour VALUES (0); INSERT INTO Hour VALUES (1); INSERT INTO Hour VALUES (2); INSERT INTO Hour VALUES (3); INSERT INTO Hour VALUES (4); INSERT INTO Hour VALUES (5); INSERT INTO Hour VALUES (6); INSERT INTO Hour VALUES (7); INSERT INTO Hour VALUES (8); INSERT INTO Hour VALUES (9); INSERT INTO Hour VALUES (10); INSERT INTO Hour VALUES (11); INSERT INTO Hour VALUES (12); INSERT INTO Hour VALUES (13); INSERT INTO Hour VALUES (14); INSERT INTO Hour VALUES (15); INSERT INTO Hour VALUES (16); INSERT INTO Hour VALUES (17); INSERT INTO Hour VALUES (18); INSERT INTO Hour VALUES (19); INSERT INTO Hour VALUES (20); INSERT INTO Hour VALUES (21); INSERT INTO Hour VALUES (22); INSERT INTO Hour VALUES (23);
我能在Presto这样做什么?