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: [email protected]
For additional commands, e-mail: [email protected]
