[ https://issues.apache.org/jira/browse/CARBONDATA-4114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nihal kumar ojha closed CARBONDATA-4114. ---------------------------------------- Resolution: Duplicate > 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 > Priority: Major > Time Spent: 40m > Remaining Estimate: 0h > > 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)