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)
