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) <[email protected]>于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:[email protected]]
> *Sent:* Friday, August 26, 2016 11:10 AM
> *To:* [email protected];
> [email protected]
> *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
>
>
>
