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)