[jira] [Resolved] (TRAFODION-1468) MDAM plan is not chosen

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

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

Qifan Chen resolved TRAFODION-1468.
-----------------------------------
    Resolution: Fixed

A pull request was initiated 8/30/2015. 

> MDAM plan is not chosen 
> ------------------------
>
>                 Key: TRAFODION-1468
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1468
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Qifan Chen
>            Assignee: Qifan Chen
>              Labels: performance
>
> The query is as follows. 
> select "cliente_CIC", "tipoMovimiento", sum("monto") from T where ("cliente_CIC" = '000003566661') and "fechaOrigen" between cast('2013-12-01' as timestamp(6)) and cast('2013-12-31' as timestamp(6)) group by 1, 2 order by 1, 2;
> Part of the DDL looks like:
> create table T
> (... ...
> , PRIMARY KEY
>   (
>    "cliente_CIC"
> ,  "operacion_identificacionOperacion"
> ,  "fechaOrigen"
> ,  "nemonico"
> ,  "claveUnicaRegistroJNL"
>    )
> )
>   SALT USING 16 PARTITIONS ON
>   (
>    "cliente_CIC"
> ,  "operacion_identificacionOperacion"
>    )
>   DIVISION BY
>   (
>     date_part('YEARMONTH', "fechaOrigen")
>   )
> And stats are available for all leading key column groups. 



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