select * from tbl; just return hundreds lines while tbl has millions

[乔彦克]

Hi, all,
    I load millions lines to trafodion table(tbl) and want to get some from
tbl. But when I execute the query below:

          "select * from tbl"
     It just returned hundreds of lines either through the shell or the
jdbc driver.
   My question is that how can I get the whole data(may be ten thousand
lines) I need.
Below is my table ddl:
SQL>showddl event;


CREATE TABLE TRAFODION.SEABASE.EVENT
  (
    V_DATE                           TIMESTAMP(6) NO DEFAULT NOT NULL NOT
      DROPPABLE NOT SERIALIZED
  , SID                              VARCHAR(16) CHARACTER SET ISO88591
COLLATE
      DEFAULT DEFAULT _ISO88591'' NOT NULL NOT DROPPABLE SERIALIZED
  , UID                              VARCHAR(16) CHARACTER SET ISO88591
COLLATE
      DEFAULT DEFAULT _ISO88591'' NOT NULL NOT DROPPABLE SERIALIZED
  , VID                              INT UNSIGNED NO DEFAULT NOT NULL NOT
      DROPPABLE SERIALIZED
  , IDX                              SMALLINT NO DEFAULT NOT NULL NOT
DROPPABLE
      SERIALIZED
  , CREATED_AT                       INT UNSIGNED NO DEFAULT NOT NULL NOT
      DROPPABLE SERIALIZED
  , P_ID                             LARGEINT NO DEFAULT NOT NULL NOT
DROPPABLE
      SERIALIZED
  , CATEGORY                         VARCHAR(255 CHARS) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , E_ACTION                         VARCHAR(255 CHARS) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , LABEL                            VARCHAR(255 CHARS) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , E_VALUE                          INT NO DEFAULT NOT NULL NOT DROPPABLE
      SERIALIZED
  , IS_BOUNCED                       SMALLINT DEFAULT 0 NOT NULL NOT
DROPPABLE
      SERIALIZED
  , PRIMARY KEY (SID ASC, V_DATE DESC, UID ASC, VID ASC, IDX ASC)
  )
  SALT USING 4 PARTITIONS
       ON (SID)
  DIVISION BY (DATE_TRUNC('DAY',V_DATE)
     NAMED AS ("_DIVISION_1_"))
  HBASE_OPTIONS
  (
    DATA_BLOCK_ENCODING = 'FAST_DIFF',
    COMPRESSION = 'GZ',
    MEMSTORE_FLUSH_SIZE = '1073741824'
  )
;
Thanks,
Qiao