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/17 03:14:14 UTC
WARNING[6008] Statistics for column were not available
Hi, team,
Recently I was test my data in the docker trafodion, I create the table and
follow the page '
https://cwiki.apache.org/confluence/display/TRAFODION/Use+an+existing+sample+table+for+UPDATE+STATISTICS'
to create the sample table to update Statistics, but I always encounter the
follow problem, sometimes HBase regionserver will get crashed when make
these queries.
Anyone can help me?
error message:
*'' SQL>select * from EVENT_NEW where v_date=date '2016-07-21' limit 100;*
**** WARNING[6008] Statistics for column (V_DATE) from table
TRAFODION.SEABASE.EVENT_NEW were not available. As a result, the access
path chosen might not be the best possible. [2016-08-17 02:53:05]*
*--- 0 row(s) selected.''*
my create table sql:
"CREATE TABLE EVENT_new (
v_date date NOT NULL,
sid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
uid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
vid int unsigned NOT NULL ,
created_at int unsigned NOT NULL ,
p_id bigint NOT NULL ,
category varchar(255) CHARACTER SET UTF8 NOT NULL,
e_action varchar(255) CHARACTER SET UTF8 NOT NULL,
label varchar(255) CHARACTER SET UTF8 NOT NULL,
e_value int NOT NULL,
is_bounced tinyint NOT NULL DEFAULT 0
)HBASE_OPTIONS( COMPRESSION='GZ');
create index event_index on event_new (v_date, sid, uid,vid);"
Any reply is appreciated, thanks.
Qiao Yanke
Re: WARNING[6008] Statistics for column were not available
Posted by 乔彦克 <qy...@gmail.com>.
Thanks Henry, now the query works fine. Many thanks again.
Henry Lin <he...@139.com>于2016年8月17日周三 上午11:33写道：
> Hi ,
>
>
>
> Pls. create table and update statistics as below:
>
>
>
> CREATE TABLE EVENT_new (
>
> v_date date NOT NULL,
>
> sid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
>
> uid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
>
> vid int unsigned NOT NULL ,
>
> created_at int unsigned NOT NULL ,
>
> p_id bigint NOT NULL ,
>
> category varchar(255) CHARACTER SET UTF8 NOT NULL,
>
> e_action varchar(255) CHARACTER SET UTF8 NOT NULL,
>
> label varchar(255) CHARACTER SET UTF8 NOT NULL,
>
> e_value int NOT NULL,
>
> is_bounced tinyint NOT NULL DEFAULT 0
>
> )
>
> HBASE_OPTIONS
>
> (
>
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
>
> COMPRESSION = 'SNAPPY',
>
> MEMSTORE_FLUSH_SIZE = '1073741824'
>
> );
>
>
>
> create index event_index on event_new (v_date, sid, uid,vid);
>
>
>
> update statistics for table event_new on every column sample;
>
>
>
> Best regards,
>
> Henry
>
>
>
> *发件人:* 乔彦克 [mailto:qyanke@gmail.com]
> *发送时间:* 2016年8月17日 11:14
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* WARNING[6008] Statistics for column were not available
>
>
>
> Hi, team,
>
> Recently I was test my data in the docker trafodion, I create the table
> and follow the page '
> https://cwiki.apache.org/confluence/display/TRAFODION/Use+an+existing+sample+table+for+UPDATE+STATISTICS'
> to create the sample table to update Statistics, but I always encounter the
> follow problem, sometimes HBase regionserver will get crashed when make
> these queries.
>
> Anyone can help me?
>
>
>
> error message:
>
> *'' SQL>select * from EVENT_NEW where v_date=date '2016-07-21' limit 100;*
>
>
>
> **** WARNING[6008] Statistics for column (V_DATE) from table
> TRAFODION.SEABASE.EVENT_NEW were not available. As a result, the access
> path chosen might not be the best possible. [2016-08-17 02:53:05]*
>
> *--- 0 row(s) selected.''*
>
>
>
> my create table sql:
>
> "CREATE TABLE EVENT_new (
>
> v_date date NOT NULL,
>
> sid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
>
> uid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
>
> vid int unsigned NOT NULL ,
>
> created_at int unsigned NOT NULL ,
>
> p_id bigint NOT NULL ,
>
> category varchar(255) CHARACTER SET UTF8 NOT NULL,
>
> e_action varchar(255) CHARACTER SET UTF8 NOT NULL,
>
> label varchar(255) CHARACTER SET UTF8 NOT NULL,
>
> e_value int NOT NULL,
>
> is_bounced tinyint NOT NULL DEFAULT 0
>
> )HBASE_OPTIONS( COMPRESSION='GZ');
>
>
>
> create index event_index on event_new (v_date, sid, uid,vid);"
>
>
>
> Any reply is appreciated, thanks.
>
> Qiao Yanke
>
答复: WARNING[6008] Statistics for column were not available
Posted by Henry Lin <he...@139.com>.
Hi ,
Pls. create table and update statistics as below:
CREATE TABLE EVENT_new (
v_date date NOT NULL,
sid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
uid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
vid int unsigned NOT NULL ,
created_at int unsigned NOT NULL ,
p_id bigint NOT NULL ,
category varchar(255) CHARACTER SET UTF8 NOT NULL,
e_action varchar(255) CHARACTER SET UTF8 NOT NULL,
label varchar(255) CHARACTER SET UTF8 NOT NULL,
e_value int NOT NULL,
is_bounced tinyint NOT NULL DEFAULT 0
)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'SNAPPY',
MEMSTORE_FLUSH_SIZE = '1073741824'
);
create index event_index on event_new (v_date, sid, uid,vid);
update statistics for table event_new on every column sample;
Best regards,
Henry
发件人: 乔彦克 [mailto:qyanke@gmail.com]
发送时间: 2016年8月17日 11:14
收件人: user@trafodion.incubator.apache.org
主题: WARNING[6008] Statistics for column were not available
Hi, team,
Recently I was test my data in the docker trafodion, I create the table and follow the page 'https://cwiki.apache.org/confluence/display/TRAFODION/Use+an+existing+sample+table+for+UPDATE+STATISTICS' to create the sample table to update Statistics, but I always encounter the follow problem, sometimes HBase regionserver will get crashed when make these queries.
Anyone can help me?
error message:
'' SQL>select * from EVENT_NEW where v_date=date '2016-07-21' limit 100;
*** WARNING[6008] Statistics for column (V_DATE) from table TRAFODION.SEABASE.EVENT_NEW were not available. As a result, the access path chosen might not be the best possible. [2016-08-17 02:53:05]
--- 0 row(s) selected.''
my create table sql:
"CREATE TABLE EVENT_new (
v_date date NOT NULL,
sid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
uid varchar(255) CHARACTER SET UTF8 NOT NULL DEFAULT '',
vid int unsigned NOT NULL ,
created_at int unsigned NOT NULL ,
p_id bigint NOT NULL ,
category varchar(255) CHARACTER SET UTF8 NOT NULL,
e_action varchar(255) CHARACTER SET UTF8 NOT NULL,
label varchar(255) CHARACTER SET UTF8 NOT NULL,
e_value int NOT NULL,
is_bounced tinyint NOT NULL DEFAULT 0
)HBASE_OPTIONS( COMPRESSION='GZ');
create index event_index on event_new (v_date, sid, uid,vid);"
Any reply is appreciated, thanks.
Qiao Yanke