You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/06/13 07:28:05 UTC
[GitHub] [incubator-doris] hf200012 opened a new issue #3857: Create V2 format table, import data, all BE down
hf200012 opened a new issue #3857:
URL: https://github.com/apache/incubator-doris/issues/3857
**Describe the bug**
Create V2 format table, import data, all BE down
**To Reproduce**
1.Change FE setting
SET GLOBAL default_rowset_type = beta;
2.create table
Change setting
create table selllist(
rq date,
mkt varchar(20),
hyid varchar(20),
hyno varchar(20),
hylb varchar(20),
hyxb varchar(20),
hynl varchar(20),
hyzy varchar(20),
hysr varchar(20),
hyxl varchar(20),
hyr varchar(20),
hyf varchar(20),
hym varchar(20),
sc varchar(20),
bm varchar(20),
gz varchar(20),
dl varchar(20),
zl varchar(20),
xl varchar(20),
ppid varchar(20),
supid varchar(20),
gdid varchar(20),
invno varchar(20)
)
DUPLICATE KEY(rq,mkt,hyid)
PARTITION BY RANGE(rq) (
PARTITION P_201801 VALUES LESS THAN ("2018-02-01"),
PARTITION P_201802 VALUES LESS THAN ("2018-03-01"),
PARTITION P_201803 VALUES LESS THAN ("2018-04-01"),
PARTITION P_201804 VALUES LESS THAN ("2018-05-01"),
PARTITION P_201805 VALUES LESS THAN ("2018-06-01"),
PARTITION P_201806 VALUES LESS THAN ("2018-07-01"),
PARTITION P_201807 VALUES LESS THAN ("2018-08-01"),
PARTITION P_201808 VALUES LESS THAN ("2018-09-01"),
PARTITION P_201809 VALUES LESS THAN ("2018-10-01"),
PARTITION P_201810 VALUES LESS THAN ("2018-11-01"),
PARTITION P_201811 VALUES LESS THAN ("2018-12-01"),
PARTITION P_201812 VALUES LESS THAN ("2019-01-01")
)
DISTRIBUTED BY HASH(mkt) BUCKETS 70
PROPERTIES(
"replication_num" = "1"
);
ALTER TABLE dr_selllist_gd SET ("storage_format" = "v2");
3.import data
curl --location-trusted -u root -T /data02/csv/2018.csv http://192.168.1.130:8030/api/retail/dr_selllist_gd/_load?label=table1_2018-01-01_test\&column_separator=%2c
4.result
the import data is successful, all BEs are down
BE cannot start, only delete data, then restart
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] hf200012 closed issue #3857: Create V2 format table, import data, all BE down
Posted by GitBox <gi...@apache.org>.
hf200012 closed issue #3857:
URL: https://github.com/apache/incubator-doris/issues/3857
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] hf200012 closed issue #3857: Create V2 format table, import data, all BE down
Posted by GitBox <gi...@apache.org>.
hf200012 closed issue #3857:
URL: https://github.com/apache/incubator-doris/issues/3857
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org