[CARBONDATA-2992] Fixed Between Query Data Mismatch issue for timestamp data type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Kumar Vishal
• Reporter: Kumar Vishal
• Created: 04/Oct/18 11:32
• Updated: 03/Feb/20 07:02
• Resolved: 04/Oct/18 12:32

Description

Problem:
Between query is giving wrong result.
Root cause:
For timestamp time when filter is given in yyyy-mm-dd format instead of yyyy-mm-dd HH:MM:SS format it will add cast, In CastExpressionOptimization it is using SimpleDateFormat object to parse the filter value which is failing as filter values is not same.
Solution:
Use SPARK:DateTimeUtils.stringToTime method as spark is handling for above scenario.

Issue Links

• links to: GitHub Pull Request #2787
• links to: GitHub Pull Request #2798
• links to: GitHub Pull Request #2798