我有一个大表需要卸载到S3,并用year and month
对其进行分区,以实现以下文件夹结构。
bucket_name/folder_name/year/month/
截至目前,我正在这样做:
unload ( 'select *,extract(year from question_asked_at) as year,extract(month from question_asked_at) as month from schema_name.table_name'
to 's3://bucket_name/folder_name/'
iam_role <iam_role>
partition by (year,month);
结果是:
bucket_name/folder_name/year=2001/month=01/
,
bucket_name/folder_name/year=2001/month=02/
分区工作正常,但是我需要删除year=
和month=
前缀,有什么建议吗?