phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vishnu rao <jaihind...@gmail.com>
Subject Cant do select = Row length is 0
Date Thu, 04 Aug 2016 07:54:59 GMT
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

Mime
View raw message