Contents Menu Expand Light mode Dark mode Auto light/dark mode
learn_aws 0.1.1 documentation
Logo
learn_aws 0.1.1 documentation
  • About Amazon Web Service
    • Amazon Web Service Overview
  • Analytics Root
    • Athena Root
      • Amazon Athena Overview
      • Creating a Table from Query Result (CTAS)
      • Creating Database and Table
      • Creating a Table from Query Result (CTAS)
      • Serde Reference
      • Running Query
      • Security
      • Workload Management (WLM)
      • AWS Athena SQL Examples
        • AWS Athena SQL - flattening nested arrays
      • Athena Best Practice
        • Athena in Python
        • Optimize Athena Performance and Cost
        • Write Athena Query Results in Parquet, Avro, ORC, JSON formats
      • Amazon Athena Case Study
        • Case Study - Athena Workload Management for Agriculture Internet of Things Company
    • Clean Rooms Root
      • AWS Clean Rooms
    • CloudSearch Root
    • Data Exchange Root
      • What is AWS Data Exchange
    • Data Pipeline Root
    • DataZone Root
    • EMR Root
    • FinSpace Root
    • Glue DataBrew Root
    • Glue Elastic Views Root
    • Glue Root
      • Glue Crawler With Different DataLake
    • Kinesis Data Analytics Root
    • Kinesis Data Firehose Root
    • Kinesis Data Streams Root
      • Amazon Kinesis Data Streams Overview
      • Amazon Kinesis Data Streams - Terminology and Concepts
      • Amazon Kinesis Data Streams - Capacity Mode
      • Amazon Kinesis Data Streams - Resharding a Stream
      • Amazon Kinesis Data Streams - Resharding a Stream
      • Amazon Kinesis Data Streams - Writing to Data Stream
      • Amazon Kinesis Data Streams - Reading from Data Stream
      • Amazon Kinesis Data Streams - Kinesis Producer Library KPL
      • Amazon Kinesis Data Streams - Kinesis Consumer Library KCL
      • Amazon Kinesis Data Streams - Best Practices
        • Amazon Kinesis Data Streams - Handle Slow Consumer
        • Amazon Kinesis Data Streams - Kinesis vs Kafka
        • Amazon Kinesis Data Streams - Record Ordering
        • Producer and Consumer Library For Stream Processing
    • Kinesis Root
    • Kinesis Video Streams Root
    • Lake Formation Root
    • Managed Streaming for Apache Kafka Root
      • Disaster Recovery in Kafka
    • OpenSearch Service Root
      • Amazon OpenSearch Overview
      • OpenSearch SME Support
      • Amazon OpenSearch Cluster Version
        • OpenSearch Cluster Security
        • Sizing OpenSearch Cluster
        • Manging Index
        • Scaling OpenSearch Cluster
      • Amazon OpenSearch Serverless Version
        • AWS OpenSearch Serverless Overview
        • Connect to OpenSearch Serverless using Python
      • OpenSearch Docs
        • OpenSearch Query DSL
      • Use OpenSearch Container Image For Local Development Version
      • Amazon OpenSearch Service Case Study
        • Case Study - OpenSearch Cluster and Collection Management in Enterprise
    • QuickSight Root
    • Redshift Root
      • Amazon Redshift Overview
        • Redshift Quotas and Limits
      • Redshift Provisioned Cluster Mode Management
        • What is Redshift Provisioned Cluster
        • Create Redshift Cluster
        • Connect to Redshift Cluster
        • Manage Redshift Cluster - User and User Group
        • Manage Redshift Cluster - Backup Restore and Snapshot
        • Manage Redshift Cluster - Resizing a Cluster
        • Manage Redshift Cluster - Workload Management WLM
        • Manage Redshift Cluster - Usage Limit
        • Manage Redshift Cluster - VPC Endpoint
        • Redshift Security - Data Protection
        • Redshift Security - IAM Access Management
        • Redshift Security - Logging and Monitoring
        • Redshift Security - Security Compliance Validation
        • Redshift Cluster Cost and Pricing
      • Redshift Serverless Management
        • What is Redshift Serverless
        • IAM in Redshift Serverless
        • Migrating a provisioned cluster to Redshift Serverless
        • Data Sharing in Redshift Serverless
        • Manage Usage Limits Query Limits and Other Administrative Tasks
      • Redshift Database Developer
        • Redshift Important Concepts
        • Designing Table
        • Load Data From S3 to Redshift
        • Unloading Data from Redshift
        • Best practice for loading data
        • Use datetime types for date columns
        • AWS Redshift User Management
        • AWS Redshift Analyze Tables
        • AWS Redshift Vacuuming Tables
        • Querying data with federated queries in Redshift
        • Query External Data Using Redshift Spectrum
      • Amazon Redshift Case Study
        • Case Study - Analytics as a Service App Using Multi Tenant Redshift
      • Amazon Redshift Code Recipe
        • Connect To Redshift in Python
        • Redshift Data API
        • Learn Redshift in Notebook
  • Application Integration Root
    • API Gateway Root
    • AppFlow Root
    • AppSync Root
    • Console Mobile Application Root
    • EventBridge Root
    • Express Workflows Root
    • MQ Root
    • Managed Workflows for Apache Airflow Root
      • Amazon MWAA - Quick Start
      • Airflow Common Patterns
      • Amazon MWAA - Manage Environment
    • Simple Notification Service Root
    • Simple Queue Service Root
    • Step Functions Root
      • What is Workflow Orchestration
      • AWS Step Functions - Overview
      • AWS Step Functions - Quick Start
      • AWS Step Functions - Pricing
      • AWS Step Functions - Limits and Quota
      • AWS Step Functions - How Step Functions Works
      • AWS Step Functions - Working with other AWS Services
      • Step Functions Code Recipe
        • AWS Step Function - Job Poller Pattern
        • AWS Step Functions - Convert Async to Sync Call
        • AWS Step Functions - Wait for a Callback with the Task Token
        • AWS Step Functions - Work with Lambda and Glue
        • AWS Step Functions - Lambda Function Input Output Parameter
        • AWS Step Functions - Distributed Map Example
        • AWS CDK - StepFunctions Task
      • Step Functions Case Study
        • Migrate from Airflow to StepFunction for a Supply Chain Company
        • Write a Case Study Using ChatGPT
  • Blockchain Root
    • Managed Blockchain Root
    • Quantum Ledger Database Root
  • Business Applications Root
    • Alexa For Business Root
    • Chime Root
    • Chime SDK Root
    • Connect Root
    • Honeycode Root
    • Pinpoint APIs Root
    • Pinpoint Root
    • Simple Email Service Root
    • Supply Chain Root
    • Wickr Root
    • WorkDocs Root
    • WorkDocs SDK Root
    • WorkMail Root
  • Cloud Financial Management Root
    • Application Cost Profiler Root
    • Billing Conductor Root
    • Budgets Root
    • Cost Explorer Root
    • Cost and Usage Report Root
    • Reserved Instance Reporting Root
    • Savings Plans Root
  • Compute Root
    • App Runner Root
    • Batch Root
    • Bottlerocket Root
    • Compute Optimizer Root
    • EC2 Auto Scaling Root
    • EC2 Image Builder Root
    • EC2 Root
    • Elastic Beanstalk Root
    • Elastic Fabric Adapter Root
    • Genomics CLI Root
    • Lambda Root
      • Build Lambda Layer in Container
      • Deploy Lambda and Configure Event Mapping with AWS CDK
      • Deploy Lambda with AWS CDK
      • Deploy Lambda with Container Image
      • Lambda Function URL
    • Lightsail Root
    • Lightsail for Research Root
    • Local Zones Root
    • NICE DCV Root
    • NICE EnginFrame Root
    • Nitro Enclaves Root
    • Outposts family Root
    • Outposts rack Root
    • Outposts servers Root
    • Parallel Cluster Root
    • Serverless Application Repository Root
    • SimSpace Weaver Root
    • Thinkbox Deadline Root
    • Thinkbox Frost Root
    • Thinkbox Krakatoa Root
    • Thinkbox Sequoia Root
    • Thinkbox Stoke Root
    • Thinkbox XMesh Root
    • VMware Cloud on AWS Root
    • Wavelength Root
  • Containers Root
    • Elastic Container Registry Root
      • What is ECR
      • AWS ECR Core Concepts
      • AWS ECR Push and Pull Private Image
      • Clean Up Old Image Tag
    • ECS Anywhere Root
    • EKS Anywhere Root
    • EKS Cloud Root
    • EKS Distro Root
    • Elastic Container Service Root
    • Elastic Kubernetes Service Root
    • Fargate Root
    • Red Hat OpenShift Service on AWS Root
  • Customer Enablement Root
    • Activate Root
    • IQ Root
    • Managed Services Root
    • Professional Services Root
    • Support Root
    • Training Certification Root
    • re:Post Root
  • Database Root
    • Aurora Root
    • Database Migration Service Root
    • DocumentDB Root
    • DynamoDB Root
      • Amazon DynamoDB Overview
        • What is DynamoDB
        • How to Learn Amazon DynamoDB
        • DynamoDB Pricing
        • DynamoDB Partition Key Sort Key
        • Dynamodb Index
      • DynamoDB Deep Dive
        • DynamoDB Backups
        • Dynamodb Transaction
        • Dynamodb Architecture
      • DynamoDB Developer Guide
        • Storage Large Item in DynamoDB
        • Pynamodb Quick Start
        • Sparse Indexes in DynamoDB
        • GSI Sharding in DynamoDB
        • Optimistic Locking In DynamoDB
        • DynamoDB Time to Live (TTL)
      • DynamoDB Solutions
        • Dynamodb Solution - Authentication and Authorization
        • Dynamodb Solution - Exponential Backoff
        • DynamoDB - Incremental Export
        • Status Tracking
      • DynamoDB Case Study
        • Case Study - Real-time inventory management for a large e-commerce platform
    • ElastiCache Root
    • Keyspaces Root
    • MemoryDB for Redis Root
    • Neptune Root
    • RDS Root
      • Snapshot Technique
    • RDS on VMware Root
    • Timestream Root
  • Developer Tools Root
    • Application Composer Root
    • Cloud Control API Root
    • Cloud Development Kit Root
      • AWS CDK - Overview
      • AWS CDK - CDK vs CloudFormation
    • Cloud9 Root
    • CloudShell Root
    • CodeArtifact Root
      • CodeArtifact Overview
      • CodeArtifact Advance
      • AWS CodeArtifact with Python
    • CodeBuild Root
    • CodeCatalyst Root
    • CodeCommit Root
    • CodeDeploy Root
    • CodePipeline Root
    • CodeStar Root
    • Command Line Interface Root
      • AWS CLI Tutorial
      • boto3 Credential Deep Dive
    • Corretto Root
    • Tools and SDKs Root
    • X Ray Root
  • End User Computing Root
    • AppStream Root
    • WorkLink Root
    • WorkSpaces Family Root
  • Front End Web Mobile Root
    • Amplify Root
    • Device Farm Root
    • Location Service Root
  • Games Root
    • GameKit Root
    • GameLift Root
    • GameSparks Root
    • Open 3D Engine Root
  • General Root
    • AWS Marketplace Root
      • Saas Products Marketplace Metering and Entitlement Service APIs
  • Internet of Things Root
    • FreeRTOS Root
    • IoT 1 Click Root
    • IoT Analytics Root
    • IoT Button Root
    • IoT Core Root
    • IoT Device Defender Root
    • IoT Device Management Root
    • IoT EduKit Root
    • IoT Events Root
    • IoT ExpressLink Root
    • IoT FleetWise Root
    • IoT Greengrass Root
    • IoT RoboRunner Root
    • IoT SiteWise Root
    • IoT Things Graph Root
    • IoT TwinMaker Root
  • Machine Learning Root
    • Apache MXNet on AWS Root
    • Augmented AI A2I Root
    • Bedrock Root
      • Amazon Bedrock Overview
      • Explore Amazon Bedrock Console
      • Knowledge Base For Amazon Bedrock
      • Agent for Amazon Bedrock
      • Prompt Engineering
      • Prompt Engineering In Enterprise
    • CodeGuru Root
    • CodeWhisperer Root
    • Comprehend Medical Root
    • Comprehend Root
    • Deep Learning AMIs Root
    • Deep Learning Containers Root
    • DeepComposer Root
    • DeepLens Root
    • DeepRacer Root
    • DevOps Guru Root
    • Elastic Inference Root
    • Forecast Root
    • Fraud Detector Root
    • HealthLake Root
    • Kendra Root
    • Lex Root
    • Lookout for Equipment Root
    • Lookout for Metrics Root
    • Lookout for Vision Root
    • Monitron Root
    • Neuron Root
    • Omics Root
    • Panorama Root
    • Personalize Root
    • Polly Root
    • Rekognition Root
    • SageMaker Ground Truth Root
    • SageMaker Root
      • ML Model Management System Architect
      • ML Model Monitoring System Architect
      • Mlflow Root
      • Amazon SageMaker Model Registry
    • SageMaker Studio Lab Root
    • TensorFlow on AWS Root
    • Textract Root
      • Should I Segment Big PDF Before Document Analysis
    • TorchServe Root
    • Transcribe Root
    • Translate Root
  • Management Governance Root
    • AppConfig Root
    • Application Auto Scaling Root
    • Auto Scaling Root
    • Backint Agent Root
    • Chatbot Root
    • CloudFormation Root
      • AWS CloudFormation Custom Resources
      • CloudFormation Case Study
        • Delivery MicroService Solution to Paid Customer via CloudFormation
        • 如何在 AWS Marketplace 上卖软件
      • CloudFormation Public Facing Template
    • CloudTrail Root
    • CloudWatch Root
      • Amazon CloudWatch Overview
      • Working with log groups and log streams
      • Analyzing log data with CloudWatch Logs Insights
      • Use Amazon CloudWatch metrics
      • Use Amazon CloudWatch Alarms
      • Use Amazon CloudWatch Dashboards
      • Amazon CloudWatch Case Study
    • Config Root
    • Control Tower Root
    • Distro for OpenTelemetry Root
    • Fault Injection Simulator Root
    • Health Dashboard Root
    • Launch Wizard Root
    • License Manager Root
    • Managed Grafana Root
    • Managed Service for Prometheus Root
    • Management Console Root
    • OpsWorks Root
    • Organizations Root
      • AWS Organizations Overview
      • AWS Organizations User Guide
      • Organizing Your AWS Environment Using Multiple Accounts
      • Multi Accounts Management Runbook
      • AWS Organization Case Study
    • Proton Root
    • Resilience Hub Root
    • Resource Explorer Root
    • Service Catalog Root
    • Service Management Connector Root
    • Systems Manager Root
      • AWS Systems Manager Node Management
        • Run Remote Command on EC2 via SSM
      • AWS Systems Manager Parameter Store
      • AWS Systems Manager Tools
        • Run Remote Command on Ec2 Ultimate Solution
    • Telco Network Builder Root
    • Trusted Advisor Root
    • Well Architected Tool Root
  • Media Services Root
    • Elastic Transcoder Root
    • Elemental Appliances & Software Root
    • Elemental Conductor Root
    • Elemental Delta Root
    • Elemental Link Root
    • Elemental Live Root
    • Elemental MediaConnect Root
    • Elemental MediaConvert Root
    • Elemental MediaLive Root
    • Elemental MediaPackage Root
    • Elemental MediaStore Root
    • Elemental MediaTailor Root
    • Elemental Server Root
    • Interactive Video Service Root
    • Kinesis Video Streams Root
    • Nimble Studio Root
  • Migration Transfer Root
    • Application Discovery Service Root
    • Application Migration Service Root
    • DataSync Root
    • Mainframe Modernization Root
    • Migration Evaluator Root
    • Migration Hub Root
    • Transfer Family Root
  • Networking Content Delivery Root
    • App Mesh Root
    • Client VPN Root
    • Cloud Map Root
    • Cloud WAN Root
    • CloudFront Root
    • Direct Connect Root
    • Elastic Load Balancing Root
    • Global Accelerator Root
    • Private 5G Root
    • PrivateLink Root
    • Route 53 Root
    • Site to Site VPN Root
    • Transit Gateway Root
    • VPC Lattice Root
    • Verified Access Root
    • Virtual Private Cloud Root
  • Quantum Technologies Root
    • Braket Root
  • Robotics Root
    • RoboMaker Root
  • Satellite Root
    • Ground Station Root
  • Security Identity Compliance Root
    • Artifact Root
    • Audit Manager Root
    • Certificate Manager Root
    • Cloud Directory Root
    • CloudHSM Root
    • Cognito Root
      • Amazon Cognito Overview
    • Detective Root
    • Directory Service Root
    • Firewall Manager Root
    • GuardDuty Root
    • IAM Identity Center Root
    • Identity and Access Management / IAM Root
      • Amazon IAM Overview
      • Amazon IAM Concepts
      • Amazon IAM Security best practices and use cases
        • Why User Assume Role for Multiple AWS Account
        • Implement Assume Role Correctly
        • Use MFA Protection
      • Amazon IAM Identities
      • Amazon IAM Access management for AWS resources
        • IAM Permission Boundary
        • Policy Evaluation Logic
      • Amazon IAM Tools
        • Delegate access across AWS accounts using IAM roles
      • Amazon IAM Case Study
        • Case Study - Setup IAM permission For Build Lab
    • Inspector Root
    • Key Management Service Root
    • Macie Root
    • Network Firewall Root
    • Private Certificate Authority Root
    • Resource Access Manager Root
    • Secrets Manager Root
    • Security Hub Root
    • Security Lake Root
    • Shield Root
    • Signer Root
    • Verified Permissions Root
    • WAF Root
  • Storage Root
    • Backup Root
    • EFS Root
      • Amazon EFS Overview
    • Elastic Block Store Root
      • Amazon EBS Overview
      • Amazon EBS Volume
    • Elastic Disaster Recovery Root
    • FSx Root
      • Amazon FSX for Windows Overview
    • FSx for Lustre Root
    • FSx for NetApp ONTAP Root
    • FSx for OpenZFS Root
    • FSx for WFS Root
    • File Cache Root
    • S3 on Outposts Root
    • Simple Storage Service Glacier Root
    • Simple Storage Service Root
      • Amazon S3 Overview
      • Amazon S3 Storage Class
      • Amazon S3 Storage Management - S3 Lifecycle
      • Amazon S3 Storage Management - S3 Object Lock
      • Amazon S3 Storage Management - S3 Replication
      • Amazon S3 Storage Management - S3 Batch Operations
      • Amazon S3 Storage Management - S3 Versioning
        • Using Versioning in S3 Bucket
      • Amazon S3 Access Management - Block Public Access
      • Amazon S3 Access Management - IAM
      • Amazon S3 Access Management - Bucket Policy
      • Amazon S3 Access Management - ACL
      • Amazon S3 Access Management - Object Ownership
      • Amazon S3 Access Management - IAM Access Analyzer for S3
      • Amazon S3 Data Process - S3 Object Lambda
      • Amazon S3 Data Process - S3 Event Notifications
      • Amazon S3 Storage Logging and Monitoring - Cloudwatch Metrics
      • Amazon S3 Storage Logging and Monitoring - AWS CloudTrail
      • Amazon S3 Storage Logging and Monitoring - Server Access Logging
      • Amazon S3 Storage Logging and Monitoring - AWS Trusted Advisor
      • Amazon S3 Analytics and Insights - Storage Lens
      • Amazon S3 Analytics and Insights - Storage Class Analysis
      • Amazon S3 Analytics and Insights - S3 Inventory
      • Amazon S3 Data Consistency Model
      • Hosting a static website on Amazon S3
      • Share Object with External User or Other
      • AWS VPC Endpoint for S3
      • Optimizing Amazon S3 performance
      • S3 Tools
    • Snowball Edge Root
    • Snowball Root
    • Snowcone Root
    • Snowmobile Root
    • Storage Gateway Root
  v: latest
Versions
latest
Downloads
On Read the Docs
Project Home
Builds
Back to top
Edit this page

AWS Athena SQL Examples#

Keywords: AWS, Amazon, Athena, SQL, Example, Reference.

Ref:

  • Running SQL Queries Using Amazon Athena: https://docs.aws.amazon.com/athena/latest/ug/querying-athena-tables.html

  • SQL Reference: https://docs.aws.amazon.com/athena/latest/ug/ddl-sql-reference.html

  • AWS Athena SQL - flattening nested arrays
Next
AWS Athena SQL - flattening nested arrays
Previous
Workload Management (WLM)
Copyright © 2024, Sanhe Hu
Made with Sphinx and @pradyunsg's Furo