How do I handle null values in source CSV data when I query data in Athena using OpenCSVSerde?

How do I handle null values in source CSV data when I query data in Athena using OpenCSVSerde?

Published on Jan 13, 2021

Skip directly to the demo: 0:38 For more details see the Knowledge Center article with this video: ...

Video preview

AWS re:Invent 2020: How FINRA operates PB-scale analytics on data lakes with Amazon Athena

Video preview

How do I handle null values in source CSV data when I query data in Athena using OpenCSVSerde?

Video preview

Monitoring Amazon Athena Queries using Amazon CloudWatch

2021

Translate, analyze, and redact text fields using SQL queries in Amazon Athena

Translate, analyze, and redact text fields using SQL queries in Amazon Athena

When I query an Amazon Athena table that has defined partitions, zero records are returned

When I query an Amazon Athena table that has defined partitions, zero records are returned

AWS re:Invent 2020: How FINRA operates PB-scale analytics on data lakes with Amazon Athena

AWS re:Invent 2020: How FINRA operates PB-scale analytics on data lakes with Amazon Athena

How do I handle null values in source CSV data when I query data in Athena using OpenCSVSerde?

How do I handle null values in source CSV data when I query data in Athena using OpenCSVSerde?

Monitoring Amazon Athena Queries using Amazon CloudWatch

Monitoring Amazon Athena Queries using Amazon CloudWatch

Detect Botnets using Amazon Athena and Amazon SageMaker

Detect Botnets using Amazon Athena and Amazon SageMaker

Orchestrate Amazon Athena Queries using AWS Step Functions

Orchestrate Amazon Athena Queries using AWS Step Functions

Analyze Cost and Usage Reports using Amazon Athena

Analyze Cost and Usage Reports using Amazon Athena

Query Apache Hudi Datasets using Amazon Athena

Query Apache Hudi Datasets using Amazon Athena

Predict Customer Churn using Amazon Athena and Amazon SageMaker

Predict Customer Churn using Amazon Athena and Amazon SageMaker

Cross Account Catalog Access using Amazon Athena and AWS Lake Formation

Cross Account Catalog Access using Amazon Athena and AWS Lake Formation

Create Dashboards on Tableau using Amazon Athena

Create Dashboards on Tableau using Amazon Athena

Analyze Results of Federated Query in Amazon Athena in Amazon QuickSight

Analyze Results of Federated Query in Amazon Athena in Amazon QuickSight

Speed up Amazon Athena Queries using Partition Projection

Speed up Amazon Athena Queries using Partition Projection

Introducing User Defined Functions (UDFs) in Amazon Athena

Introducing User Defined Functions (UDFs) in Amazon Athena

Est. 2016, Copr. 0x4447™ LLC.

|

Terms of Service