asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pouria (JIRA)" <>
Subject [jira] [Created] (ASTERIXDB-1128) Need to add TPCH queries With Secondary Indices to our build tests
Date Mon, 05 Oct 2015 22:30:26 GMT
Pouria created ASTERIXDB-1128:

             Summary: Need to add TPCH queries With Secondary Indices to our build tests
                 Key: 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
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

View raw message