Doris DBA

用户

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_"