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)