impala-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Ho (Code Review)" <>
Subject [Impala-ASF-CR] Loads all TPC-DS tables
Date Fri, 26 May 2017 01:32:38 GMT
Michael Ho has posted comments on this change.

Change subject: Loads all TPC-DS tables

Patch Set 7:

Commit Message:

PS7, Line 7: Loads all TPC-DS tables
> Jira?
There is only a downstream JIRA tracking this. I will file an upstream JIRA for it.
File testdata/bin/

PS7, Line 365:                                    impala_home = os.getenv("IMPALA_HOME"),
             :                                    hint = insert_hint)
> Please remove spaces around = as above.
File testdata/datasets/tpcds/tpcds_schema_template.sql:

PS7, Line 27: cc_rec_start_date         string
            : cc_rec_end_date           string
> Here and likely elsewhere, there are column type differences between the sp
The schema mostly matches what we use for nightly perf testing. I agree that we should probably
change some of these to timestamp but that it may require changing some existing table such
as date_dim so I didn't want to do it in this change.

Some other notable difference from the spec is that we use bigint for certain columns such
as ss_ticket_number as it may overflow a 32-bit integer when the scale gets large enough.

To view, visit
To unsubscribe, visit

Gerrit-MessageType: comment
Gerrit-Change-Id: Ic5277245fd20827c9c09ce5c1a7a37266ca476b9
Gerrit-PatchSet: 7
Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-Owner: Michael Ho <>
Gerrit-Reviewer: Dan Hecht <>
Gerrit-Reviewer: Greg Rahn <>
Gerrit-Reviewer: Michael Brown <>
Gerrit-Reviewer: Michael Ho <>
Gerrit-Reviewer: Mostafa Mokhtar <>
Gerrit-Reviewer: Tim Wood <>
Gerrit-HasComments: Yes

View raw message