You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2022/10/19 05:16:00 UTC

[jira] [Created] (IMPALA-11675) Use DATE types in TPC-H schema

Quanlong Huang created IMPALA-11675:
---------------------------------------

             Summary: Use DATE types in TPC-H schema
                 Key: IMPALA-11675
                 URL: https://issues.apache.org/jira/browse/IMPALA-11675
             Project: IMPALA
          Issue Type: Task
          Components: Infrastructure
            Reporter: Quanlong Huang


The TPC-H standard uses DATE type in some columns like o_orderdate, l_shipdate, l_commitdate, l_receiptdate:
https://www.tpc.org/tpc_documents_current_versions/pdf/tpc-h_v3.0.1.pdf

These columns are currently defined as string types in our tests. It'd be nice to use DATE type instead.

There is a discussion thread about swithing some date string columns to use DATE type:
https://lists.apache.org/thread/kpq5mz77zrkrrk3wydjr40j6rz58hh8g

CC [~gaborkaszab], [~csringhofer], [~laszlog]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)