[
https://issues.apache.org/jira/browse/IMPALA-10830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Manish Maheshwari updated IMPALA-10830:
---------------------------------------
Description:
We support rounding into minute intervals.
{code:java}
select trunc(now(), 'MI') ;
Query submitted at: 2021-07-28 05:27:48 (Coordinator:
https://demo-coordinator0.se-sandb.a465-9q4k.cloudera.site:25000)
Query progress can be monitored at:
https://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.
was:
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.
> 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
> Priority: Major
>
> We support rounding into minute intervals.
> {code:java}
> select trunc(now(), 'MI') ;
> Query submitted at: 2021-07-28 05:27:48 (Coordinator:
> https://demo-coordinator0.se-sandb.a465-9q4k.cloudera.site:25000)
> Query progress can be monitored at:
> https://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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
