Streamline TPC-H data and query generation

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Won't Fix
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      There have been a few comments on the design suggesting improvements to the process for generating MQL queries/data using the TPC-H dbgen and qgen tools. These include:

      • Modifying dbgen/qgen to generate CSVs instead of |-separated files (note that some strings in the data contain commas)
      • Modifying dbgen/qgen to generate SQL queries for portgres or mysql instead
      • Converting date fields from strings to ISODates in the csv files before importing them into mongod using mongoimport

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Alya Berciu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: