You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Nihal kumar ojha (Jira)" <ji...@apache.org> on 2021/01/29 08:50:00 UTC

[jira] [Created] (CARBONDATA-4114) Select query is returning empty result when carbon.read.partition.hive.direct = false

Nihal kumar ojha created CARBONDATA-4114:
--------------------------------------------

             Summary: Select query is returning empty result when carbon.read.partition.hive.direct = false
                 Key: CARBONDATA-4114
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4114
             Project: CarbonData
          Issue Type: Bug
            Reporter: Nihal kumar ojha


Currently when {{carbon.read.partition.hive.direct = false}} then select query with load command for the CSV file which contain multiple rows is returning empty result.

 

set carbon.read.partition.hive.direct=false;

drop table if exists sourceTable;
CREATE TABLE sourceTable (empno int, empname String, designation String, doj Timestamp, workgroupcategory int, workgroupcategoryname String, deptno int, deptname String, projectcode int, projectjoindate Timestamp, projectenddate Timestamp) partitioned by(attendance int, utilization int, salary int) STORED AS carbondata;

LOAD DATA local inpath '$resourcesPath/data.csv' INTO TABLE sourceTable OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= '"');
select * from sourceTable;



--
This message was sent by Atlassian Jira
(v8.3.4#803005)