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

["Quanlong Huang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-11675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17629627#comment-17629627 ] 

Quanlong Huang commented on IMPALA-11675:
-----------------------------------------

Yeah, that would be nice.

Another motivation for this task is that we are currently lack of a large test table that has DATE columns. Most tests use functional_xxx.date_tbl but it contains only 22 rows. If we convert the TPCH lineitem table to use DATE columns, we can use it in DATE type testing.

> 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
>            Priority: Critical
>
> 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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org