By using AWS re:Post, you agree to the Terms of Use
/Simple query runs so long/

Simple query runs so long


I want to get min partitioned date from the view on Athena. For this I have very simple query:

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.

asked 2 months ago35 views
2 Answers

can you please provide table DDL ?

answered 2 months ago

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

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions