- 新しい順
- 投票が多い順
- コメントが多い順
Hello,
Based on the information provided. I can suggest the following:
-
Make sure you are following best practices for using Athena with AWS Glue, especially check that your Database, table, column names are lowercase letters, numbers, and the underscore character. [1]
-
Please make sure that to use a partitioned table, the data must be partitioned and the partitioned data might be in either of the following formats [2]:
-
Hive style format(Example: s3://doc-example-bucket/example-folder/year=2021/month=01/day=01/my_file.csv)
-
Non-Hive style format(Example: s3://doc-example-bucket/example-folder/2021/01/01/my_file.csv)
According to the information provided, I am assuming that you are using HIVE style partitioning. Kindly make sure that the partition format is correct.
- Please take time to read this article, especially the sections for “Double slash in LOCATION path” and “Hive hidden files” can be useful in your case [3].
Hope this information helps you. If you are still unable to resolve your problem. I kindly request you to raise a support case with AWS Athena support engineering team with Athena query id/ids and Region for detailed troubleshooting.
Thanks!
References:
[1] Best practices: https://docs.aws.amazon.com/athena/latest/ug/glue-best-practices.html
[2] How can I create and use partitioned tables in Amazon Athena? : https://aws.amazon.com/premiumsupport/knowledge-center/athena-create-use-partitioned-tables/
[3] Why do I get zero records when I query my Amazon Athena table?: https://repost.aws/knowledge-center/athena-empty-results#
関連するコンテンツ
- AWS公式更新しました 3年前
- AWS公式更新しました 3年前