QQShu1 created SPARK-20068: ------------------------------ Summary: Twenty-two column coalesce has pool performance when codegen is open Key: SPARK-20068 URL: https://issues.apache.org/jira/browse/SPARK-20068 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 1.5.0 Reporter: QQShu1
when the coalesce has Twenty-one column the select performance is well, but the Twenty-two column coalesce the select performance is pool. I use the 22 column coalesce select commend is that : SELECT SUM(COALESCE(col1,0)) AS CUSTOM1, SUM(COALESCE(col2,0)) AS CUSTOM2, SUM(COALESCE(col3,0)) AS CUSTOM3, SUM(COALESCE(col4,0)) AS CUSTOM4, SUM(COALESCE(col5,0)) AS CUSTOM5, SUM(COALESCE(col6,0)) AS CUSTOM6, SUM(COALESCE(col7,0)) AS CUSTOM7, SUM(COALESCE(col8,0)) AS CUSTOM8, SUM(COALESCE(col9,0)) AS CUSTOM9, SUM(COALESCE(col10,0)) AS CUSTOM10, SUM(COALESCE(col11,0)) AS CUSTOM11, SUM(COALESCE(col12,0)) AS CUSTOM12, SUM(COALESCE(col13,0)) AS CUSTOM13, SUM(COALESCE(col14,0)) AS CUSTOM14, SUM(COALESCE(col15,0)) AS CUSTOM15, SUM(COALESCE(col16,0)) AS CUSTOM16, SUM(COALESCE(col17,0)) AS CUSTOM17, SUM(COALESCE(col18,0)) AS CUSTOM18, SUM(COALESCE(col19,0)) AS CUSTOM19, SUM(COALESCE(col20,0)) AS CUSTOM20, SUM(COALESCE(col21,0)) AS CUSTOM21, SUM(COALESCE(col22,0)) AS CUSTOM22 FROM txt_table ; the 21 column select commend it that: SELECT SUM(COALESCE(col1,0)) AS CUSTOM1, SUM(COALESCE(col2,0)) AS CUSTOM2, SUM(COALESCE(col3,0)) AS CUSTOM3, SUM(COALESCE(col4,0)) AS CUSTOM4, SUM(COALESCE(col5,0)) AS CUSTOM5, SUM(COALESCE(col6,0)) AS CUSTOM6, SUM(COALESCE(col7,0)) AS CUSTOM7, SUM(COALESCE(col8,0)) AS CUSTOM8, SUM(COALESCE(col9,0)) AS CUSTOM9, SUM(COALESCE(col10,0)) AS CUSTOM10, SUM(COALESCE(col11,0)) AS CUSTOM11, SUM(COALESCE(col12,0)) AS CUSTOM12, SUM(COALESCE(col13,0)) AS CUSTOM13, SUM(COALESCE(col14,0)) AS CUSTOM14, SUM(COALESCE(col15,0)) AS CUSTOM15, SUM(COALESCE(col16,0)) AS CUSTOM16, SUM(COALESCE(col17,0)) AS CUSTOM17, SUM(COALESCE(col18,0)) AS CUSTOM18, SUM(COALESCE(col19,0)) AS CUSTOM19, SUM(COALESCE(col20,0)) AS CUSTOM20, SUM(COALESCE(col21,0)) AS CUSTOM21 FROM txt_table ; -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org