asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yingyi Bu (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (ASTERIXDB-1128) Need to add TPCH queries With Secondary Indices to our build tests
Date Sun, 13 Mar 2016 07:16:33 GMT

     [ 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)

Mime
View raw message