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

[Qifan Chen (JIRA)]

Qifan Chen created TRAFODION-1468:
-------------------------------------

             Summary: 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


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)