[ https://issues.apache.org/jira/browse/CARBONDATA-1247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16289364#comment-16289364 ]
Pawan Malwal commented on CARBONDATA-1247: ------------------------------------------ [https://github.com/apache/carbondata/pull/1656] > Block pruning not working for date type data type column > -------------------------------------------------------- > > Key: CARBONDATA-1247 > URL: https://issues.apache.org/jira/browse/CARBONDATA-1247 > Project: CarbonData > Issue Type: Bug > Components: sql > Environment: Standalone > Reporter: krishna reddy > Assignee: Pawan Malwal > Time Spent: 5h > Remaining Estimate: 0h > > 1. create table if not exists test_date (id int,first_name String,last_name > string,email string,gender string,dob date) stored by 'carbondata' > 2. LOAD DATA LOCAL INPATH 'D:/data/MOCK_DATA_24.csv' into table test_date > 3. LOAD DATA LOCAL INPATH 'D:/data/MOCK_DATA_25.csv' into table test_date > 4. select dob from test_date where dob = '2016-06-24' > Actual Result: In the logs it is going to 2 blocks > Identified no.of.blocks: 2, > no.of.tasks: 2, > no.of.nodes: 0, > parallelism: 1 > Expected: It should select only one block -- This message was sent by Atlassian JIRA (v6.4.14#64029)