[
https://issues.apache.org/jira/browse/CARBONDATA-4311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
PRIYESH RANJAN updated CARBONDATA-4311:
---------------------------------------
Component/s: data-query
Affects Version/s: 2.2.0
Description:
+*Query :-*+
from Spark Session :
drop table if exists lsc1;
CREATE TABLE lsc1(id int, name string, description string,address string, note
string) stored as carbondata
tblproperties('sort_columns'='id,name','long_string_columns'='description,note');
load data inpath 'hdfs://hacluster/chetan/longStringData_100rec.csv' into table
lsc1 options('DELIMITER'=',', 'QUOTECHAR'=
'"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='id,name,description,address,note');
delete from lsc1 where id=99;
alter table lsc1 add columns(id2 int);
alter table lsc1 change id2 col_id bigint;
from presto session :
select * from lsc1 limit 1;
error-
presto:ranj> select * from lsc1 limit 1;
Query 20211025_041130_00017_7gfn9, FAILED, 1 node
Splits: 18 total, 0 done (0.00%)
0:05 [0 rows, 0B] [0 rows/s, 0B/s]
Query 20211025_041130_00017_7gfn9 failed: Loaded block positions count (100)
doesn't match lazy block positions count (99)'
log :-
java.lang.IllegalStateException: Loaded block positions count (100) doesn't
match lazy block positions count (99)java.lang.IllegalStateException: Loaded
block positions count (100) doesn't match lazy block positions count (99) at
io.prestosql.spi.block.LazyBlock$LazyData.load(LazyBlock.java:383) at
io.prestosql.spi.block.LazyBlock$LazyData.getFullyLoadedBlock(LazyBlock.java:360)
at io.prestosql.spi.block.LazyBlock.getLoadedBlock(LazyBlock.java:276) at
io.prestosql.spi.Page.getLoadedPage(Page.java:273) at
io.prestosql.operator.TableScanOperator.getOutput(TableScanOperator.java:305)
at io.prestosql.operator.Driver.processInternal(Driver.java:379) at
io.prestosql.operator.Driver.lambda$processFor$8(Driver.java:283) at
io.prestosql.operator.Driver.tryWithLock(Driver.java:675) at
io.prestosql.operator.Driver.processFor(Driver.java:276) at
io.prestosql.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:1075)
at
io.prestosql.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:163)
at
io.prestosql.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:484)
at io.prestosql.$gen.Presto_333____20211027_064027_2.run(Unknown Source) at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Environment: Presto 333
Summary: Select query fails from presto session when table
contain long string column (was: Sele)
> Select query fails from presto session when table contain long string column
> ----------------------------------------------------------------------------
>
> Key: CARBONDATA-4311
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4311
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 2.2.0
> Environment: Presto 333
> Reporter: PRIYESH RANJAN
> Priority: Major
>
> +*Query :-*+
> from Spark Session :
> drop table if exists lsc1;
> CREATE TABLE lsc1(id int, name string, description string,address string,
> note string) stored as carbondata
> tblproperties('sort_columns'='id,name','long_string_columns'='description,note');
> load data inpath 'hdfs://hacluster/chetan/longStringData_100rec.csv' into
> table lsc1 options('DELIMITER'=',', 'QUOTECHAR'=
> '"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='id,name,description,address,note');
> delete from lsc1 where id=99;
> alter table lsc1 add columns(id2 int);
> alter table lsc1 change id2 col_id bigint;
> from presto session :
> select * from lsc1 limit 1;
> error-
> presto:ranj> select * from lsc1 limit 1;
> Query 20211025_041130_00017_7gfn9, FAILED, 1 node
> Splits: 18 total, 0 done (0.00%)
> 0:05 [0 rows, 0B] [0 rows/s, 0B/s]
> Query 20211025_041130_00017_7gfn9 failed: Loaded block positions count (100)
> doesn't match lazy block positions count (99)'
>
> log :-
> java.lang.IllegalStateException: Loaded block positions count (100) doesn't
> match lazy block positions count (99)java.lang.IllegalStateException: Loaded
> block positions count (100) doesn't match lazy block positions count (99) at
> io.prestosql.spi.block.LazyBlock$LazyData.load(LazyBlock.java:383) at
> io.prestosql.spi.block.LazyBlock$LazyData.getFullyLoadedBlock(LazyBlock.java:360)
> at io.prestosql.spi.block.LazyBlock.getLoadedBlock(LazyBlock.java:276) at
> io.prestosql.spi.Page.getLoadedPage(Page.java:273) at
> io.prestosql.operator.TableScanOperator.getOutput(TableScanOperator.java:305)
> at io.prestosql.operator.Driver.processInternal(Driver.java:379) at
> io.prestosql.operator.Driver.lambda$processFor$8(Driver.java:283) at
> io.prestosql.operator.Driver.tryWithLock(Driver.java:675) at
> io.prestosql.operator.Driver.processFor(Driver.java:276) at
> io.prestosql.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:1075)
> at
> io.prestosql.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:163)
> at
> io.prestosql.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:484)
> at io.prestosql.$gen.Presto_333____20211027_064027_2.run(Unknown Source) at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:834)
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
