[jira] [Created] (CARBONDATA-2832) Block loading error for select query executed after merge index command executed on V1/V2 store table

["Chetan Bhat (JIRA)" <ji...@apache.org>]

Chetan Bhat created CARBONDATA-2832:
---------------------------------------

             Summary: 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


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)