-
Type:
Improvement
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Duplicate
-
Affects Version/s: Impala 2.1
-
Fix Version/s: None
-
Component/s: Backend
-
Labels:None
-
Target Version:
Without string function (to_date()):
select `Date`, clusterID, count(*) as 'cnt' from FactDailyUser group by `Date`, clusterID order by 1,3
Result: 21984 records
Execution: 1m 49s
With string function (to_date()):
select to_date(`Date`), clusterID, count(*) as 'cnt' from FactDailyUser group by to_date(`Date`), clusterID order by 1,3
Result: 21984 records
Execution: 9m 9s
- is duplicated by
-
IMPALA-4055 Investigate and fix to_date() slowness
-
- Resolved
-