You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Manish Gupta (JIRA)" <ji...@apache.org> on 2018/08/07 08:38:00 UTC
[jira] [Resolved] (CARBONDATA-2832) Block loading error for select
query executed after merge index command executed on V1/V2 store table
[ https://issues.apache.org/jira/browse/CARBONDATA-2832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Manish Gupta resolved CARBONDATA-2832.
--------------------------------------
Resolution: Fixed
Fix Version/s: 1.4.1
> Block loading error for select query executed after merge index command executed on V1/V2 store table
> -----------------------------------------------------------------------------------------------------
>
> Key: CARBONDATA-2832
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2832
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.4.1
> Environment: Spark 2.1
> Reporter: Chetan Bhat
> Assignee: dhatchayani
> Priority: Minor
> Fix For: 1.4.1
>
>
> Steps :
> *Create and load data in V1/V2 carbon store:*
> create table brinjal (imei string,AMSize string,channelsId string,ActiveCountry string, Activecity string,gamePointId double,deviceInformationId double,productionDate Timestamp,deliveryDate timestamp,deliverycharge double) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('table_blocksize'='1');
> LOAD DATA INPATH 'hdfs://hacluster/chetan/vardhandaterestruct.csv' INTO TABLE brinjal OPTIONS('DELIMITER'=',', 'QUOTECHAR'= '"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'= 'imei,deviceInformationId,AMSize,channelsId,ActiveCountry,Activecity,gamePointId,productionDate,deliveryDate,deliverycharge');
> *In 1.4.1*
> refresh table brinjal;
> alter table brinjal compact 'segment_index';
> select * from brinjal where AMSize='8RAM size';
>
> *Issue : Block loading error for select query executed after merge index command executed on V1/V2 store table.*
> 0: jdbc:hive2://10.18.98.101:22550/default> select * from brinjal where AMSize='8RAM size';
> *Error: java.io.IOException: Problem in loading segment blocks. (state=,code=0)*
> *Expected :* select query executed after merge index command executed on V1/V2 store table should return correct result set without error**
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)