Any error/exception you got after 100 rows. Curious, it works for me. Best Regards, Kevin Xu
发件人: 乔彦克 [mailto:[email protected]] 发送时间: 2016年8月26日 12:55 收件人: [email protected]; [email protected] 抄送: Xu, Kai-Hua (Kevin) <[email protected]> 主题: 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) <[email protected]<mailto:[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]<mailto:[email protected]>] Sent: Friday, August 26, 2016 11:10 AM To: [email protected]<mailto:[email protected]>; [email protected]<mailto:[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
