You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by 乔彦克 <qy...@gmail.com> on 2016/08/26 03:09:52 UTC
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
答复: select * from tbl; just return hundreds lines while tbl has millions
Posted by "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
答复: select * from tbl; just return hundreds lines while tbl has millions
Posted by "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
Re: select * from tbl; just return hundreds lines while tbl has millions
Posted by 乔彦克 <qy...@gmail.com>.
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]
> *Sent:* Friday, August 26, 2016 11:10 AM
> *To:* user@trafodion.incubator.apache.org;
> dev@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
>
>
>
Re: select * from tbl; just return hundreds lines while tbl has millions
Posted by 乔彦克 <qy...@gmail.com>.
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]
> *Sent:* Friday, August 26, 2016 11:10 AM
> *To:* user@trafodion.incubator.apache.org;
> dev@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
>
>
>
RE: select * from tbl; just return hundreds lines while tbl has
millions
Posted by "Xu, Kai-Hua (Kevin)" <ka...@esgyn.cn>.
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]
Sent: Friday, August 26, 2016 11:10 AM
To: user@trafodion.incubator.apache.org; dev@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
RE: select * from tbl; just return hundreds lines while tbl has
millions
Posted by "Xu, Kai-Hua (Kevin)" <ka...@esgyn.cn>.
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]
Sent: Friday, August 26, 2016 11:10 AM
To: user@trafodion.incubator.apache.org; dev@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