[jira] [Updated] (ASTERIXDB-1128) Need to add TPCH queries With Secondary Indices to our build tests

["Pouria (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pouria updated ASTERIXDB-1128:
------------------------------
    Description: 
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 nation_fk_region on Nation(n_regionkey);
create index supplier_fk_nation on Supplier (s_nationkey);
create index partsupp_fk_part on Partsupp (ps_partkey);
create index partsupp_fk_supplier on Partsupp (ps_suppkey);
create index customer_fk_nation on Customer (c_nationkey);
create index orders_fk_customer on Orders (o_custkey);
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 orders_orderdateIx on Orders (o_orderdate);
create index lineitem_shipdateIx on LineItem (l_shipdate);
create index lineitem_receiptdateIx on LineItem (l_receiptdate);


  was:
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 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 nation_fk_region on Nation(n_regionkey);
create index supplier_fk_nation on Supplier (s_nationkey);
create index partsupp_fk_part on Partsupp (ps_partkey);
create index partsupp_fk_supplier on Partsupp (ps_suppkey);
create index customer_fk_nation on Customer (c_nationkey);
create index orders_fk_customer on Orders (o_custkey);
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 orders_orderdateIx on Orders (o_orderdate);
create index lineitem_shipdateIx on LineItem (l_shipdate);
create index lineitem_receiptdateIx on LineItem (l_receiptdate);



> 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
>
> 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 nation_fk_region on Nation(n_regionkey);
> create index supplier_fk_nation on Supplier (s_nationkey);
> create index partsupp_fk_part on Partsupp (ps_partkey);
> create index partsupp_fk_supplier on Partsupp (ps_suppkey);
> create index customer_fk_nation on Customer (c_nationkey);
> create index orders_fk_customer on Orders (o_custkey);
> 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 orders_orderdateIx on Orders (o_orderdate);
> create index lineitem_shipdateIx on LineItem (l_shipdate);
> create index lineitem_receiptdateIx on LineItem (l_receiptdate);



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)