aws-cloudformation - AWS Glue+Athena 跳过标题行

Question

截至January 19, 2018 updates , Athena 可以跳过文件的标题行，

Support for ignoring headers. You can use the skip.header.line.count property when defining tables, to allow Athena to ignore headers.

我使用AWS Glue in Cloudformation管理我的 Athena 表。使用Glue Table Input ，我如何告诉 Athena 跳过标题行？

Answer 1

基于 AWS::Glue::Table 的完整模板 here ，进行更改，

Resources:
  ...
  MyGlueTable:
    ...
    Properties:
      ...
      TableInput:
        ...
        StorageDescriptor:
          ...
          SerdeInfo:
            Parameters: { "separatorChar" : "," }

至，

            Parameters:
              separatorChar : ","
              "skip.header.line.count" : 1

成功了。