002.clickhouse-ck导出csv文件

 clickhouse-client --host=xx.xxx.xx.xx --user=xxxxxxx --password=xxxxxxx -m -d 库名 --query " 
 select 
b.member_no ,b.phone_number 
from 
(
SELECT entity_id   
FROM  memberxxxxxxxxxxxx
WHERE  id = 1234
) a 
join  
(
  select member_no ,phone_number 
  from 
  dws_xxxxxxxxxx
 group by  member_no ,phone_number )  b 
on a.entity_id = b.member_no
FORMAT CSV
" > /root/xxxxtest/xxxxx.csv