[CARBONDATA-3811] In Flat folder enabled table, it is returning no records while querying.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Environment: opensource ANT cluster
• Assignee: Unassigned
• Reporter: Prasanna Ravichandran
• Created: 08/May/20 15:56
• Updated: 21/May/20 05:07
• Resolved: 13/May/20 05:22

Description

Flat folder table is retuning no records for select queries.

 

Test queries:

drop table if exists uniqdata1;
CREATE TABLE uniqdata1 (cust_id int,cust_name String,active_emui_version string, dob timestamp, doj timestamp, bigint_column1 bigint,bigint_column2 bigint,decimal_column1 decimal(30,10), decimal_column2 decimal(36,36),double_column1 double, double_column2 double,integer_column1 int) stored as carbondata TBLPROPERTIES('flat_folder'='true');
load data inpath 'hdfs://hacluster/user/prasanna/2000_UniqData.csv' into table uniqdata1 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');
select count from uniqdata1;--0;
select * from uniqdata1 limit 10;--0;