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:[email protected]] 发送时间: 2016年8月17日 11:14 收件人: [email protected] 主题: 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
