Support Questions
Find answers, ask questions, and share your expertise

AWS Athena regex pattern for log

AWS Athena regex pattern for log

New Contributor

30-03-2020<tab>INFO<tab>tasks.py/22<tab>Info message
31-03-2020<tab>ERROR<tab>tasks.py/22<tab>Error message

My logs come as shown above to S3 bucket I want to query them using Athena, but whatever regex I give it doesn't match. It requires certain Hive DDL something? Can someone help me put here