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
