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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (Jira)
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)