Thanks Henry, now the query works fine. Many thanks again. Henry Lin <[email protected]>于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:[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 >
