[
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)
