SQL 錯(cuò)誤 [1105] [HY000]: errCode = 2, detailMessage = select list expression not produced by aggregation output (missing from GROUP BY clause?): ......

今天查詢doris數(shù)據(jù)庫(kù)發(fā)現(xiàn)一直報(bào)錯(cuò)說(shuō)group by少了字段，于是記錄下

報(bào)錯(cuò)原因：select的字段重命名與表字段沖突，重新命名即可

例如：

假設(shè)actd表有字段id，如下會(huì)報(bào)錯(cuò)，修改第一行id 重命名為id1 和group by 后為id1修復(fù)

SELECT   max(id) id,
            trx_date,
            SUM(trx_cnt)                   AS trx_cnt,
        FROM
            actd
        GROUP BY
            id,
            acct_tp

修正：

SELECT   max(id) id1,
            trx_date,
            SUM(trx_cnt)                   AS trx_cnt,
        FROM
            actd
        GROUP BY
            id1,
            acct_tp

（記錄一下我的sql問(wèn)題）...