-
Type:
Story
-
Status: Done
-
Resolution: Done
-
Affects Version/s: Search Services 1.4
-
Fix Version/s: Search Services 2.0
-
Labels:None
-
Epic Link:
-
Sprint:Team Ninja-King - S&I 38, Team Ninja-King - S&I 39, Team Ninja-King - S&I 40
-
Release Train:Southall
-
Delivery Team:Search
-
Story Points:13
When using Tableau, date fields are drilled down using CAST functions when gathering hour, minutes and seconds. This produces queries including the following pattern:
SELECT HOUR(CAST(`cm_created` AS TIMESTAMP)) FROM alfresco GROUP BY HOUR(CAST(`cm_created` AS TIMESTAMP))
We can simplify the case testing following query:
SELECT CAST(`cm_created` AS TIMESTAMP) FROM alfresco
That produces this exception when executed:
java.lang.ClassCastException: class java.lang.String cannot be cast to class java.lang.Number
Acceptance criteria:
- SELECT CAST in SELECT, WHERE and GROUP BY
- Support CAST as an inner operator
- Depended on by
-
SEARCH-2316 Error is produced in Tableau when trying to produce a graph for number of nodes created by year and type
- Review
- Depends on
-
SEARCH-2255 SQL avg(field) function is broken with multiple group by
- Done
- relates to
-
SEARCH-2296 Support for QUARTER function
- Done