while doing a ---> (select * from BIDDING_EVENTS_PROD WHERE wTs IS NOT
NULL AND TS >= 1470201526501 AND TS < 1470287926501;)
java.lang.RuntimeException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_BIDDING_EVENTS_PROD,,1459280128606.7d44e12333e81e3a8b07264bfe1812b7.:
Row length is 0
The explain is:
CLIENT 424-CHUNK PARALLEL 150-WAY RANGE SCAN OVER
_LOCAL_IDX_BIDDING_EVENTS_PROD [-32748,~1,470,287,926,501] -
[-32748,~1,470,201,526,501]* |*
*| * SERVER FILTER BY "WTS" IS NOT NULL * |*
*The definition of the index is :*
CREATE LOCAL INDEX IF NOT EXISTS _LOCAL_IDX_BIDDING_EVENTS_PROD ON
BIDDING_EVENTS_PROD (ts DESC) " +
" INCLUDE (wTs, clTs, cvTs, paid, bidAmt, bidFlr) " +
------------------------------------------------------------------------------------------------------------------------------------------
i think it has something to do with the columns fetched - not all columns
are part of the index and hence the problem.
when i do --> select wTs, clTs, cvTs, paid, bidAmt, bidFlr from
BIDDING_EVENTS_PROD WHERE wTs IS NOT NULL AND TS >= 1470201526501 AND TS <
1470287926501;
it works
--
with regards,
ch Vishnu
mash213.wordpress.com
doodle-vishnu.blogspot.in
