[
https://issues.apache.org/jira/browse/SPARK-11873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Armbrust updated SPARK-11873:
-------------------------------------
Issue Type: Improvement (was: Bug)
> Regression for TPC-DS query 63 when used with decimal datatype and windows
> function
> -----------------------------------------------------------------------------------
>
> Key: SPARK-11873
> URL: https://issues.apache.org/jira/browse/SPARK-11873
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 1.5.0
> Reporter: Dileep Kumar
> Labels: perfomance
> Attachments: 63.1.1, 63.1.5, 63.decimal_schema,
> 63.decimal_schema_windows_function, 63.double_schema, 98.1.1, 98.1.5,
> decimal_schema.sql, double_schema.sql
>
>
> When running the TPC-DS based queries for benchmarking spark found that query
> 63 (after making it similar to original query) show different behavior
> compared to other queries eg. q98 which has similar function.
> Here are performance numbers(execution time in seconds):
> 1.1 Baseline 1.5 1.5 + Decimal
> q63 27 26 38
> q98 18 26 24
> As you can see q63 is showing regression compared to similar query. I am
> attaching the both version of queries and affected schemas. When adding the
> windows function back this is the only query seem to be slower than 1.1 in
> 1.5.
> I have attached the both version of schema and queries.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
