[
https://issues.apache.org/jira/browse/ASTERIXDB-1128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15192174#comment-15192174
]
ASF subversion and git services commented on ASTERIXDB-1128:
------------------------------------------------------------
Commit fb431ffea6200d0c68e7331186d019c1ecbd568c in incubator-asterixdb's branch
refs/heads/master from [~buyingyi]
[ https://git-wip-us.apache.org/repos/asf?p=incubator-asterixdb.git;h=fb431ff ]
ASTERIXDB-1128: add TPC-H queries with secondary indices into build tests.
Change-Id: I4237ca17d5e334959a320ed92fcdccf51cc4856d
Reviewed-on: https://asterix-gerrit.ics.uci.edu/704
Tested-by: Jenkins <[email protected]>
Reviewed-by: Till Westmann <[email protected]>
> Need to add TPCH queries With Secondary Indices to our build tests
> ------------------------------------------------------------------
>
> Key: ASTERIXDB-1128
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1128
> Project: Apache AsterixDB
> Issue Type: Test
> Components: Test Framework
> Reporter: Pouria
> Assignee: Yingyi Bu
>
> TPCH queries has been part of our tests for a while, but on a schema with no
> secondary index.
> As the TPCH benchmark description lets users use secondary indices, we have
> recently switched to running these queries with secondary indices. This has
> revealed some issues (such as issue ASTERIXDB-1127); hence it makes sense to
> add running these queries both with and without secondary indices in our
> (build) tests.
> Here is the set of secondary indices for the TPCH schema:
> create index customer_fk_nation on Customer (c_nationkey);
> create index lineitem_shipdateIx on LineItem (l_shipdate);
> create index lineitem_receiptdateIx on LineItem (l_receiptdate);
> create index lineitem_fk_orders on LineItem (l_orderkey);
> create index lineitem_fk_part on LineItem (l_partkey);
> create index lineitem_fk_supplier on LineItem (l_suppkey);
> create index nation_fk_region on Nation(n_regionkey);
> create index partsupp_fk_part on Partsupp (ps_partkey);
> create index partsupp_fk_supplier on Partsupp (ps_suppkey);
> create index orders_fk_customer on Orders (o_custkey);
> create index orders_orderdateIx on Orders (o_orderdate);
> create index supplier_fk_nation on Supplier (s_nationkey);
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
