HIVE_UNKNOWN_ERROR: Path is not absolute: s3://<S3 path that points to cloudfront logs bucket>

Issue while querying the cloudfront logs using Athena. All the resources are being created successfully when I run a basic sql query to fetch last 100 logs it fails with below error. verified the schema looks good.

HIVE_UNKNOWN_ERROR: Path is not absolute: s3://<S3 path that points to cloudfront logs bucket>

Note: The cloudfront logs files are directly storing in s3://<S3 path that points to cloudfront logs bucket> it doesn't have any folder within it.