Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-10667

Add 86 Runnable TPCDS Queries into spark-sql-perf

    Details

    • 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
    • Environment:

      RHEL 7.1, Spark 1.5.0 and 1.4.1

      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
      jfchen@us.ibm.com

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jfchen@us.ibm.com JESSE CHEN
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 336h
                336h
                Remaining:
                Remaining Estimate - 336h
                336h
                Logged:
                Time Spent - Not Specified
                Not Specified