[
https://issues.apache.org/jira/browse/ASTERIXDB-1128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yingyi Bu resolved ASTERIXDB-1128.
----------------------------------
Resolution: Fixed
> 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)
