Simple query runs so long
0
I want to get min partitioned date from the view on Athena. For this I have very simple query:
select
min(dt)
from database.my_table
my_table is view
dt is partitioned
Query worked for half an hour after I canceled it. Why it took so long? I expected to receive data in seconds.
Topics
Tags
asked 2 months ago35 views
2 Answers
0
Even though it simple query it all depends on Query used to create the view ? Athena will run the query behind the view and finally min(dt) on that. What kind of Athena data source here ? backed by glue catalog ? if partitioned column like date try to use partition index in glue https://docs.aws.amazon.com/glue/latest/dg/partition-indexes.html
answered 2 months ago
Relevant questions
Help in creating the most simple Athena UDF
asked 4 months agoAthena Partition Projection and Column Stats
asked 4 months agoHow can I find the Query ID for an Athena Saved Query on AWS console?
asked 5 months agoBest way to structure data for fast access via Athena?
asked 4 months agoSave / backup Athena view
Accepted Answerasked 2 years agoSimple query runs so long
asked 2 months agoAthena query fails with GENERIC_INTERNAL_ERROR: Missing variable: <column_name>
Accepted Answerasked 2 months agoAthena views can't include Athena table partitions
asked 5 days agoAthena Query timeout
asked 2 months agoDoes Athena support query caching?
asked 4 years ago