Error in creating an external table in Athena: Watch out for hyphens!
Blog iconknowledge capsule
Jul 17
The following CREATE statement was issued in AWS Athena's Query Editor to create an external table for CloudFront access log acquisition.CREATE EXTERNAL TABLE IF NOT EXISTS cf_log ( request_date string, request_time string, x_edge_location string, sc_bytes int, client_ip string, cs_method string, cs_host string, cs_uri_stem string, sc_status string, cs_referer string, user_agent string, uri_query string, cookie string, x_edge_result_type string, x_edge_request_id string, x_host_header st...

knowledge capsule

Written by
knowledge capsule

aim for developer's magic bullet

Subscribe

2025 Paragraph Technologies Inc

PopularTrendingPrivacyTermsHome
Search...Ctrl+K

knowledge capsule

Subscribe