Konrad created PHOENIX-4065:
-------------------------------
Summary: NPE SELECT + WHERE + ORDER BY date
Key: PHOENIX-4065
URL: https://issues.apache.org/jira/browse/PHOENIX-4065
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.11.0
Environment: HBase 1.3.1, Phoenix 4.11.0
Reporter: Konrad
Priority: Critical
I found NPE while working with 4.11.0. Select statement was working for 4.9.0.
CREATE TABLE IF NOT EXISTS sample
(
A UNSIGNED_LONG NOT NULL,
B VARCHAR,
C DATE
CONSTRAINT pk_A PRIMARY KEY (A)
);
upsert into sample (A, B, C) values (1, 'test', '2017-08-03');
select A FROM sample where B = 'test' ORDER BY C ;
org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
SAMPLE,,1501852502789.c348edcb5540cc47d91cb62c4721b689.: null
at
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)
at
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)
at
org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)
at
org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)
at
org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)
at
org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)
at
org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)
at
org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2633)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2837)
at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:34950)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2339)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:123)
at
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:188)
at
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:168)
Caused by: java.lang.NullPointerException
at
org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)
... 15 more [SQL State=08000, DB Errorcode=101]
workaround:
select A, B FROM sample where B = 'test' ORDER BY C ;
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
