Hi guys, help needed! I’m linking superset to aws athena database and I’ve time 
data partitioned as year, month, day, hour, minute columns. How i can leverage 
superset to query on that columns for time/data filtering instead of timestamp 
column? without losing performance of curse
i’ve created a column on source>table with this expression

from_iso8601_timestamp( 
concat(year,‘-’,month,‘-’,day,‘T’,hour,‘:’,minute,‘:00’))

but i’m not sure if in that case i can take advantage of athena partitions 
performance. 

anyone had such similar experience?
any hint is appreciated, thanks!


Luciano Salemme
Chief Technical Officer
HyperTV Rome
Skype: luciano.salemme
+39 06 3322 5494

Privileged/Confidential Information may be contained in this message. If you 
are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to 
anyone. In such case, you should destroy this message and kindly notify the 
sender by reply email. Please advise immediately if you or your employer does 
not consent to email for messages of this kind. Opinions, conclusions and other 
information in this message that do not relate to the official business of 
HyperTv, Inc. shall be understood as neither given nor endorsed by it. For more 
info on HyperTv's Privacy Policy please refer to HyperTv's website under the 
Privacy section.

Reply via email to