- Le plus récent
- Le plus de votes
- La plupart des commentaires
Athena suggests to use lower case for table names and table column names. Please refer below link
https://docs.aws.amazon.com/athena/latest/ug/tables-databases-columns-names.html
Hello,
I noticed that in location parameter for Create Table you have provided backet name only (LOCATION 's3://nameofbucket/'). Make sure that this bucket only consist csv data with schema provided in table DDL. I am suspecting this backet consist other folders and files due to which Athena generated emplty results. Please check this location again and if ithis bucket consist other folder and files, then move the csv file to different prefix and in location provide s3 location till prefix which consist csv files with mentioned schema.
After creating table you need to add partitions
MSCK REPAIR TABLE <tablename>
;
Contenus pertinents
- demandé il y a un an
- demandé il y a 9 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
I changed it to lowercase, still outputs an empty table..