Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

允许用户使用bucket 地址 #1868

Open
allwefantasy opened this issue Oct 24, 2022 · 0 comments
Open

允许用户使用bucket 地址 #1868

allwefantasy opened this issue Oct 24, 2022 · 0 comments

Comments

@allwefantasy
Copy link
Contributor

allwefantasy commented Oct 24, 2022

如果启动配置:

-spark.mlsql.path.schemas="s3a,oss"

那么用户可以直接使用如下语法,系统不会自动添加主目录

-- 连接和注册
load FS.``
where
`fs.oss.impl`="org.apache.hadoop.fs.aliyun.oss.AliyunOSSFileSystem"
and `fs.oss.accessKeyId`="xxxx"
and `fs.oss.accessKeySecret`="xxxx"
and `fs.oss.endpoint`="oss-cn-hangzhou.aliyuncs.com"
as output;

-- 现在可以正常使用 bucket 地址了
load csv.`oss://xxxxxx/tmp/tables/table1` where header="true" 
as output;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant