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

["Nihal kumar ojha (Jira)" <ji...@apache.org>]

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