[
https://issues.apache.org/jira/browse/TRAFODION-1468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14726431#comment-14726431
]
ASF GitHub Bot commented on TRAFODION-1468:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/70
> 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)
