GitHub user kumarvishal09 opened a pull request: https://github.com/apache/carbondata/pull/2787
[HOTFIX]fixed filter mismatch issue **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. - [ ] Any interfaces changed? - [ ] Any backward compatibility impacted? - [ ] Document update required? - [ ] Testing done Added UT - [ ] For large changes, please consider breaking it into sub-tasks under an umbrella JIRA. You can merge this pull request into a Git repository by running: $ git pull https://github.com/kumarvishal09/incubator-carbondata filterfix Alternatively you can review and apply these changes as the patch at: https://github.com/apache/carbondata/pull/2787.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #2787 ---- commit e14820f87b316282edcd9d510a99539cfcfbd52b Author: kumarvishal09 <kumarvishal1802@...> Date: 2018-09-28T13:03:29Z fixed filter mismatch issue ---- ---