[KYLIN-1766] CubeTupleConverter.translateResult() is slow due to date conversion

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.5.3
• Assignee: liyang
• Reporter: liyang
• Created: 06/Jun/16 14:18
• Updated: 28/Jul/16 06:48
• Resolved: 20/Jun/16 03:47

Description

As attached, profiling shows that current filling tuple is slow especially about dates. The norm form "yyyy-mm-dd" is parsed into a Date, then converted into # since epic day. This is slow because of Java's slow SimpleDateFormat.

An idea is to refine the norm form of date/time to be the time millis. This will save a lot of str <--> date conversions. However the change impacts dictionary, lookup snapshot, and maybe data ingestion. Also need to think about backward compatibility.