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

["Xu, Kai-Hua (Kevin)" <ka...@esgyn.cn>]

Any error/exception you got after 100 rows. Curious, it works for me.

Best Regards,
Kevin Xu

发件人: 乔彦克 [mailto:qyanke@gmail.com]
发送时间: 2016年8月26日 12:55
收件人: user@trafodion.incubator.apache.org; dev@trafodion.incubator.apache.org
抄送: Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>
主题: Re: select * from tbl; just return hundreds lines while tbl has millions

This is the test code:


Class.forName(driverClass);
long starTime = System.currentTimeMillis();
conn = DriverManager.getConnection(url, userName, pwd);
String sql = "select ckId from visit";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
int i = 0;
String ckid = "";
while (rs.next()){
    ckid = rs.getString("ckid");
    i++;
    if (i % 100 == 0) System.out.println(i);
}
System.out.println("ckId nums: " + i);
ps.close();
conn.close();

Xu, Kai-Hua (Kevin) <ka...@esgyn.cn>>于2016年8月26日周五 下午12:20写道：
Hi Qiao,

Could you share your JDBC code? Let me see what kinds of API you were using.

Best Regards,
Kevin Xu

From: 乔彦克 [mailto:qyanke@gmail.com<ma...@gmail.com>]
Sent: Friday, August 26, 2016 11:10 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>; dev@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: 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