feat: copy from FTP and secured FTP source

[ClSlaid]

I hereby agree to the terms of the CLA available at: https://databend.rs/dev/policies/cla/

Summary

Summary about this PR

Fixes #7660

Guide

• Build databend with storage-ftp feature enabled:

cargo build --bin databend-query --features=storage-ftp

• connect to query with your favorite SQL client

mycli -p3307 -uroot

• copy from FTP, need to be secure

COPY INTO books FROM 'ftp://my_ftp.example:114/books.csv' CONNECTION=(SECURE='true' USERNAME='me' PASSWORD='pwd example') FILE_FORMAT=(TYPE='CSV');

in the future, copy with FTPS scheme should be supported. waiting for a new version of opendal.

COPY INTO books FROM 'ftps://my_ftp.example:514/books.csv' CONNECTION=(USERNAME='me' PASSWORD='pwd example') FILE_FORMAT=(TYPE='CSV');

Signed-off-by: ClSlaid [email protected]

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

1 Ignored Deployment

Name	Status	Preview	Updated
databend	⬜️ Ignored (Inspect)		Sep 26, 2022 at 10:21AM (UTC)

[ClSlaid]

wait for #7897 to merge first.

[Xuanwo]

wait for #7897 to merge first.

Done, go ahead!

[Xuanwo]

Nice PR, let's merge!