AWS Athena从GLUE爬网程序从S3输入csv创建的表中返回零记录 [英] AWS Athena Returning Zero Records from Tables Created from GLUE Crawler input csv from S3

问题描述

第一部分：

我尝试了胶搜寻器在s3中加载的虚拟csv上运行，它创建了一个表，但是当我尝试查看表时

I tried glue crawler to run on dummy csv loaded in s3 it created a table but when I try view table in athena and query it it shows Zero Records returned.

但是在雅典娜的ELB演示数据工作正常。

But the demo data of ELB in Athena works fine.

第二部分（场景：）

假设我有一个excel文件以及该文件中数据存储方式和格式的数据字典，我希望将数据转储到AWS Redshift中？什么是实现此目的的最佳方法？

Suppose I Have a excel file and data dictionary of how and what format data is stored in that file , I want that data to be dumped in AWS Redshift What would be best way to achieve this ?

推荐答案

我遇到了同样的问题。您需要为搜寻器提供文件夹路径而不是真实文件名，然后运行它。我尝试将文件夹名称提供给爬虫，并且它起作用了。希望这可以帮助。让我知道。谢谢，

I experienced the same issue. You need to give the folder path instead of the real file name to the crawler and run it. I tried with feeding folder name to the crawler and it worked. Hope this helps. Let me know. Thanks,

这篇关于AWS Athena从GLUE爬网程序从S3输入csv创建的表中返回零记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！