Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2027

hbase_aggr not selected as plan for a full select count(*) query

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Invalid
    • None
    • None
    • None
    • None

    Description

      when do a
      select count from tbl;
      query, it should push down the aggregation to hbase coprocessor, but seems not.

      to reproduce:
      CREATE TABLE T113B
      (
      UNIQ INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
      SERIALIZED
      , C100K INT DEFAULT NULL NOT SERIALIZED
      , C10K INT DEFAULT NULL NOT SERIALIZED
      , C1K INT DEFAULT NULL NOT SERIALIZED
      , C100 INT DEFAULT NULL NOT SERIALIZED
      , C10 INT DEFAULT NULL NOT SERIALIZED
      , C1 INT DEFAULT NULL NOT SERIALIZED
      , primary key(uniq)
      )
      – STORE BY (UNIQ ASC)
      SALT USING 16 PARTITIONS
      ATTRIBUTES ALIGNED FORMAT
      ;

      upsert using load into t113b select
      0 + (100000 * x100000) + (10000 * x10000) + (1000 * x1000) +
      (100 * x100) + (10 * x10) +( 1 * x1),
      0 + (10000 * x10000) + (1000 * x1000) + (100 * x100) +
      (10 * x10) +( 1 * x1),
      0 + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
      0 + (100 * x100) + (10 * x10) + (1 * x1),
      0 + (10 * x10) + (1 * x1),
      0 + (1 * x1),
      0
      from (values(0)) t
      transpose 0,1,2,3,4,5,6,7,8,9 as x100000
      transpose 0,1,2,3,4,5,6,7,8,9 as x10000
      transpose 0,1,2,3,4,5,6,7,8,9 as x1000
      transpose 0,1,2,3,4,5,6,7,8,9 as x100
      transpose 0,1,2,3,4,5,6,7,8,9 as x10
      transpose 0,1,2,3,4,5,6,7,8,9 as x1
      transpose 0,1,2,3,4,5,6,7,8,9 as x0;

      update statistics for table t113b on every column;

      explain options 'f' select count from t113b;

      Attachments

        Activity

          People

            ovis_poly liu ming
            ovis_poly liu ming
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: