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