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
