我有這個查詢，我試圖在 HIVE 中運行：
select transaction_date, count(total_distinct) from (
SELECT transaction_date, concat(subid,'**', itemid) as total_distinct
FROM TBL_1
group by transaction_date, subid,itemid
) group by transaction_date
我想要做的是得到 subid 和 itemid 的獨特組合，但我需要每天的總數。當我運行上面的查詢時，我收到了這個錯誤：
Error while compiling statement: FAILED: ParseException line 6:2 cannot recognize input near 'group' 'by' 'TRANSACTION_DATE' in subquery source
不過，該查詢對我來說似乎是正確的。有沒有人遇到過這個錯誤？
uj5u.com熱心網友回復：
Hive 需要為子查詢設定別名，因此您需要為其指定一個名稱：
select transaction_date, count(total_distinct) from (
SELECT transaction_date, concat(subid,'**', itemid) as total_distinct
FROM TBL_1
group by transaction_date, subid,itemid
) dummy -- << note here
group by transaction_date
誠然，錯誤訊息遠沒有幫助。
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/424055.html