You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Manish Maheshwari (Jira)" <ji...@apache.org> on 2021/07/28 05:33:00 UTC
[jira] [Created] (IMPALA-10830) Trunc function to support minute
intervals
Manish Maheshwari created IMPALA-10830:
------------------------------------------
Summary: Trunc function to support minute intervals
Key: IMPALA-10830
URL: https://issues.apache.org/jira/browse/IMPALA-10830
Project: IMPALA
Issue Type: New Feature
Components: Frontend
Affects Versions: 4/
Reporter: Manish Maheshwari
We support rounding into minute intervals.
{code:java}
select trunc(now(), 'MI') ;
Query submitted at: 2021-07-28 05:27:48 (Coordinator: https://skylogic-demo-coordinator0.se-sandb.a465-9q4k.cloudera.site:25000)
Query progress can be monitored at: https://skylogic-demo-coordinator0.se-sandb.a465-9q4k.cloudera.site:25000/query_plan?query_id=694ca74fd48c06b3:0c0e51f200000000
2021-07-28 05:27:00
{code}
We also need to support rounding into custom intervals like 5/10/15/30 etc minutes. If can add `MIxx` or `HHxx` that would be ideal.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)