[SPARK-10667] Add 86 Runnable TPCDS Queries into spark-sql-perf

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.4.1, 1.5.0
• Fix Version/s: 1.4.1, 1.5.0
• Component/s: SQL, Tests
• Labels: spark spark-sql-perf sql

Environment

RHEL 7.1, Spark 1.5.0 and 1.4.1

• Assignee: Unassigned
• Reporter: JESSE CHEN
• Created: 17/Sep/15 17:17
• Updated: 17/Sep/15 19:25
• Resolved: 17/Sep/15 19:12

Description

The IBM Spark Technology Center has made 86 (out of 99 TPCDS business queries) to run successfully on Spark 1.4.1 and 1.5.0. The existing spark-sql-perf test kit (on github from databricks) has a small subset of these. Could we add all the following queries into the kit so the community can learn/leverage?

query01
query02
query03
query04
query05
query07
query08
query09
query11
query12
query13
query15
query16
query17
query20
query21
query22
query24a
query24b
query25
query26
query27
query28
query29
query30
query31
query32
query33
query34
query36
query37
query38
query39a
query39b
query40
query42
query43
query45
query46
query47
query48
query49
query50
query51
query52
query53
query56
query57
query58
query59
query60
query61
query62
query63
query66
query67
query68
query69
query72
query73
query74
query75
query76
query77
query78
query79
query80
query81
query82
query83
query84
query85
query86
query87
query88
query89
query90
query91
query92
query93
query94
query95
query96
query97
query98
query99

Please contact me for the working queries.
Jesse Chen
[e-mail]