Doris DBA：修订间差异
跳到导航
跳到搜索
（→用户） |
无编辑摘要 |
||
| 第7行： | 第7行： | ||
-- set property for 'bi' 'max_user_connections' = '200'; | -- set property for 'bi' 'max_user_connections' = '200'; | ||
show property for 'bi' like '%max_user_connections%'; | show property for 'bi' like '%max_user_connections%'; | ||
==== 导出文件 ==== | |||
# fe.conf | |||
enable_outfile_to_local=true | |||
# set enable_parallel_outfile = false; | |||
# false=多个节点随机，true=多个节点多份全量 | |||
SELECT identity_code, | |||
cast(identity_info as string) identity_info | |||
FROM bi.ti_f_identity | |||
where part = 3 | |||
limit 30000000 | |||
INTO OUTFILE "file:///tmp/result000_" | |||
[[分类:Develop]] | [[分类:Develop]] | ||
[[分类:DB]] | [[分类:DB]] | ||
[[分类:Doris]] | [[分类:Doris]] | ||
2023年12月19日 (二) 09:12的版本
用户
create user bi identified by 'password';
-- set password for bi = password('abcd1234');
grant all on bidb to bi;
连接数
-- set property for 'bi' 'max_user_connections' = '200'; show property for 'bi' like '%max_user_connections%';
导出文件
# fe.conf enable_outfile_to_local=true
# set enable_parallel_outfile = false;
# false=多个节点随机，true=多个节点多份全量
SELECT identity_code,
cast(identity_info as string) identity_info
FROM bi.ti_f_identity
where part = 3
limit 30000000
INTO OUTFILE "file:///tmp/result000_"