Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-3811

In Flat folder enabled table, it is returning no records while querying.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      opensource ANT cluster

      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;

        Attachments

        1. Flat_folder_returning_zero.png
          75 kB
          Prasanna Ravichandran

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Prasanna Ravichandran Prasanna Ravichandran
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: