相交N宽度_桶

我试着从带扣的柱上取子集,然后取交点。

我也对串联过滤持开放态度。

下面的代码报告col1不存在-无论如何不确定它是正确的方法。

WITH ranges AS (
    SELECT 
    min(col1) AS c1min, 
    max(col1) AS c1max,
    min(col2) AS c2min,
    max(col2) AS c2max
    FROM csv_test
),
f1 AS (
    SELECT width_bucket(col1,c1min,c1max,12) AS b1
    FROM csv_test, ranges 
    ORDER BY b1 ASC
),
f2 AS (
    SELECT width_bucket(col2,c2min,c2max,12) AS b2
    FROM csv_test, ranges 
    ORDER BY b2 ASC
)
SELECT b1, b2, c3, c4, c18
FROM csv_test
WHERE 
b1 BETWEEN 0 AND 5
AND
b2 BETWEEN 3 AND 7;