此代碼給出錯誤
-- HADOOP IMPALA VISION 1
SELECT * FROM
(
SELECT
K.XID,
K.KAMPUS,
K.CIHAZTIPI,
K.CIHAZMODELI,
K.SISTEM,
K.CIHAZMARKASI,
K.SAHAEKIPMANKODU
FROM ODAK_STAGE.ENERGY_SAVING_KLIMA_UNPIVOT K
)
PIVOT
(
SUM(DEGER)
FOR DEGERTIPI
IN (
'sahaekipmankodu',
'Basinc',
)
)
ORDER BY DEGERTIPI
SQL 錯誤 [500051] [HY000]：[Cloudera]ImpalaJDBCDriver 錯誤處理查詢/陳述句。錯誤代碼：0，SQL 狀態：TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:ParseException: 第 14 行語法錯誤:?( ?^?遇到: (?預期：CROSS, FROM, FULL, GROUP, HAVING, INNER , JOIN, LEFT, LIMIT, OFFSET, ON, ORDER, RIGHT, STRAIGHT_JOIN, TABLESAMPLE, UNION, USING, WHERE, COMMA??引起：例外：語法錯誤?），查詢：SELECT * FROM?（? SELECT ? K. XID,? K.KAMPUS,? K.CIHAZTIPI,? K.CIHAZMODELI,? K.SISTEM,? K.CIHAZMARKASI,? K.SAHAEKIPMANKODU? FROM ODAK_STAGE.ENERGY_SAVING_KLIMA_UNPIVOT K?)?PIVOT ?( ? SUM(DEGER) ? FOR DEGERTIPI? IN ( ? 'sahaekipmankodu',? 'Basinc', ? ) ?)?按 DEGERTIPI 排序。
uj5u.com熱心網友回復：
您不能按照 6.1 檔案，PIVOT 不是當前功能。
https://www.cloudera.com/documentation/enterprise/6/6.1/topics/impala_reserved_words.html
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/449256.html
上一篇：如何在xamarin上實作Handle、JniIdentityHashCode、PeerReference、JniPeerMembers、JniManagedPeerState