空木头的副本到舞台

发布于 2025-02-07 16:29:45 字数 428 浏览 1 评论 0原文

我有一个以下复制命令，在该命令中，我会从查询返回的行中生成一个镶木材。我也通过某个专栏进行了分区。如果查询返回0行，我需要在舞台上复制一个空镶木（带有列标头但没有数据的木板）。

我正在从一个过程中进行此操作，并且查询作为参数传递。意味着查询不是固定的，因此使用联合（正如我在某些帖子上阅读的那样）不是一个选择。

copy into @<stageName>/baseFolder/  from (
    <a query that returns 0 rows>) 
    partition by (col1 || '/' || CAST(col2 as INT)) 
        FILE_FORMAT = <fileformat> HEADER=true  DETAILED_OUTPUT=true

有什么建议吗？

原文

I have a below copy command, where i generate a parquet out of the rows returned by a query. I also partition by some column. I am have requirement to copy an empty parquet(a parquet with column header but no data) on stage in case the query returns 0 rows.

I am doing this from inside a procedure and the query is passed as a parameter to it. Means the query is not fixed, thus using a union(as I have read on some post) is not an option.

copy into @<stageName>/baseFolder/  from (
    <a query that returns 0 rows>) 
    partition by (col1 || '/' || CAST(col2 as INT)) 
        FILE_FORMAT = <fileformat> HEADER=true  DETAILED_OUTPUT=true

Any suggestions?

分享到QQ

分享到微博