AWS Athena Glue troubleshooting

 

1	a. Caused by: com.amazonaws.services.glue.util.NonFatalException: Error opening file: b. java.io.FileNotFoundException: No such file or directory File is present but still getting the above errors	The issue is with S3 permissions
2	can not be resolved against partition columns: []	Load partitions of the table
3	Caused by: org.apache.spark.sql.glue.util.ChoiceTypeException: Inconsistent data type results in choice type:	Check all the values against datatype. 0 value is not allowed if the datatype is double