[ https://issues.apache.org/jira/browse/CARBONDATA-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16337120#comment-16337120 ]
Sangeeta Gulia commented on CARBONDATA-2004: -------------------------------------------- This issue is working fine on current master branch code. Please retest and close this bug [~Vandana7]. > Incorrect result displays while loading data into a partitioned table. > ---------------------------------------------------------------------- > > Key: CARBONDATA-2004 > URL: https://issues.apache.org/jira/browse/CARBONDATA-2004 > Project: CarbonData > Issue Type: Bug > Components: data-load > Affects Versions: 1.3.0 > Environment: spark 2.1 > Reporter: Vandana Yadav > Priority: Major > Attachments: 2000_UniqData.csv, timestamp.png > > > Incorrect result displays while loading data into a partitioned table. > Steps to reproduce: > 1)create a partitioned table: > CREATE TABLE uniqdata_timestamp (CUST_ID int,CUST_NAME > String,ACTIVE_EMUI_VERSION string, DOJ timestamp, BIGINT_COLUMN1 > bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 > decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double, INTEGER_COLUMN1 > int) partitioned by(dob timestamp) STORED BY 'org.apache.carbondata.format' > TBLPROPERTIES ("TABLE_BLOCKSIZE"= "256 MB") > 2) Load data into table: > LOAD DATA INPATH 'hdfs://localhost:54310/Data/uniqdata/2000_UniqData.csv' > into table uniqdata_timestamp partition(dob='1') OPTIONS > ('FILEHEADER'='CUST_ID,CUST_NAME ,ACTIVE_EMUI_VERSION,DOB,DOJ, > BIGINT_COLUMN1, > BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1, > Double_COLUMN2,INTEGER_COLUMN1','BAD_RECORDS_ACTION'='FORCE'); > 3) Expected result: It should throw an error as invalid partition value. > 4) Actual Result: it displays notification of successful load, but there is > no data into the table > 5) execute query: select count(*) from uniqdata_timestamp; > output: > +-----------+--+ > | count(1) | > +-----------+--+ > | 0 | > +-----------+--+ -- This message was sent by Atlassian JIRA (v7.6.3#76005)