Skip directly to the demo: 0:38
For more details see the Knowledge Center article with this video: https://aws.amazon.com/premiumsupport/knowledge-center/athena-hive-bad-data-error-csv/
Mohammedfahim shows you how to handle null values that are present in source CSV data when you query CSV data in Athena using OpenCSVSerde.
Publisher: Amazon Web Services
You can watch this video also at the source.