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)

Reply via email to