[jira] [Created] (CARBONDATA-2992) Fixed Between Query Data Mismatch issue for timestamp data type

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-2992) Fixed Between Query Data Mismatch issue for timestamp data type

Akash R Nilugal (Jira)
kumar vishal created CARBONDATA-2992:
----------------------------------------

             Summary: Fixed Between Query Data Mismatch issue for timestamp data type
                 Key: CARBONDATA-2992
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2992
             Project: CarbonData
          Issue Type: Bug
            Reporter: kumar vishal
            Assignee: kumar vishal


*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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)