我正在使用此查詢，但它回傳列號而不是計數count(bedroom_count)：
select
states,
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10
from
(
select
states,
bedroom_count
from
hive_metastore.property_db_dev.datatree_assessor_silver
) PIVOT (
count(bedroom_count) FOR bedroom_count IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
)
ORDER BY
states;
uj5u.com熱心網友回復：
您需要使用反引號來轉義列名，否則 Spark 會將它們解釋為查詢中的整數文字：
SELECT states, `0`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`, `10`
FROM (
SELECT states,
bedroom_count
FROM hive_metastore.property_db_dev.datatree_assessor_silver
)
PIVOT (
count(bedroom_count) FOR bedroom_count IN (0,1,2,3,4,5,6,7,8,9,10)
)
ORDER BY states;
或者select *，如果您想要所有透視列，則只需使用：
SELECT *
-- ...
ORDER BY states;
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/421900.html
標籤：