Hi Siddharth, basing on the fact that it works fine with HBase 0.98 I can suggest that somehow you run into the partial row problem. To confirm that can you rebuild the client with following changes in phoenix-core/src/main/java/org/apache/phoenix/coprocessor/BaseScannerRegionObserver.java
- return super.nextRaw(result, scannerContext); + return super.nextRaw(result); for nextRaw(List<Cell> result, ScannerContext scannerContext) method of RegionScannerHolder inner class. Thanks, Sergey On Fri, Jul 28, 2017 at 2:22 AM, Siddharth Ubale < [email protected]> wrote: > Hi , > > > > I am using Phoenix 4.10 over Hbase 1.2.6 . Running 2 join queries , one > with the hint /*+ USE_SORT_MERGE_JOIN */ and the other without . > > > > The query with the hint gives an error where it indicated the the region > servicg the table is null. I am unable to understand why the hint is > causiong the query to fail with an error and the other query without the > hint works perfectly fine. > > Queries for reference : > > > > Query 1(Failed): *Select /*+ USE_SORT_MERGE_JOIN */ > olap4address.olap4address292FEC765F1C486F85A509D88096F098street,olap4customer.olap4customer292FEC765F1C486F85A509D88096F098name > as Name,olap4address.olap4address292FEC765F1C486F85A509D88096F098aid from > dwh as olap4customer * > > * inner join RELATIONSHIPDATA as rel0 on > rel0.ParentObjectDatarowkey=olap4customer.rk * > > * and rel0.tenant_parentobjectid ='81aa279d-1b0a-409a-bcee-bb09da603d3e' > and rel0.tenant_childobjectid ='a5805b8b-103a-4786-ade9-bedfa0158b59' * > > * inner join dwh as olap4address on rel0.childobjectdatarowkey > =olap4address.rk* > > *where olap4address.olap4address292FEC765F1C486F85A509D88096F098street > = 'MG road132' AND > olap4customer.olap4customer292FEC765F1C486F85A509D88096F098Name = 'Prasad > 60'* > > > > Query 2 (gives result )*: Select > olap4address.olap4address292FEC765F1C486F85A509D88096F098street,olap4customer.olap4customer292FEC765F1C486F85A509D88096F098name > as Name,olap4address.olap4address292FEC765F1C486F85A509D88096F098aid from > dwh as olap4customer * > > * inner join RELATIONSHIPDATA as rel0 on > rel0.ParentObjectDatarowkey=olap4customer.rk * > > * and rel0.tenant_parentobjectid ='81aa279d-1b0a-409a-bcee-bb09da603d3e' > and rel0.tenant_childobjectid ='a5805b8b-103a-4786-ade9-bedfa0158b59' * > > * inner join dwh as olap4address on rel0.childobjectdatarowkey > =olap4address.rk* > > *where olap4address.olap4address292FEC765F1C486F85A509D88096F098street > = 'MG road132' AND > olap4customer.olap4customer292FEC765F1C486F85A509D88096F098Name = 'Prasad > 60'* > > > > 1. Error: org.apache.phoenix.exception.PhoenixIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,, > 1501224108837.1fc1615f5be984e13329b31a902ebf44.: null > > 2. at org.apache.phoenix.util.ServerUtil.createIOException( > ServerUtil.java:92) > > 3. at org.apache.phoenix.util.ServerUtil.throwIOException( > ServerUtil.java:58) > > 4. at org.apache.phoenix.iterate.RegionScannerFactory$1. > nextRaw(RegionScannerFactory.java:214) > > 5. at org.apache.phoenix.iterate. > RegionScannerResultIterator.next(RegionScannerResultIterator.java:61) > > 6. at org.apache.phoenix.iterate.OrderedResultIterator. > getResultIterator(OrderedResultIterator.java:255) > > 7. at org.apache.phoenix.iterate.OrderedResultIterator.next( > OrderedResultIterator.java:199) > > 8. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getTopNScanner( > NonAggregateRegionScannerFactory.java:319) > > 9. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getRegionScanner( > NonAggregateRegionScannerFactory.java:161) > > 10. at org.apache.phoenix.coprocessor.ScanRegionObserver. > doPostScannerOpen(ScanRegionObserver.java:72) > > 11. at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$ > RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221) > > 12. at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$ > RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266) > > 13. at org.apache.hadoop.hbase.regionserver.RSRpcServices. > scan(RSRpcServices.java:2580) > > 14. at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) > > 15. at org.apache.hadoop.hbase.ipc. > RpcServer.call(RpcServer.java:2196) > > 16. at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner. > java:112) > > 17. at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:133) > > 18. at org.apache.hadoop.hbase.ipc. > RpcExecutor$1.run(RpcExecutor.java:108) > > 19. at java.lang.Thread.run(Thread.java:745) > > 20. Caused by: java.lang.NullPointerException > > 21. at org.apache.phoenix.execute.TupleProjector.projectResults( > TupleProjector.java:286) > > 22. at org.apache.phoenix.iterate.RegionScannerFactory$1. > nextRaw(RegionScannerFactory.java:204) > > 23. ... 15 more (state=08000,code=101) > > 24. org.apache.phoenix.exception.PhoenixIOException: > org.apache.phoenix.exception.PhoenixIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: > RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.: null > > 25. at org.apache.phoenix.util.ServerUtil.createIOException( > ServerUtil.java:92) > > 26. at org.apache.phoenix.util.ServerUtil.throwIOException( > ServerUtil.java:58) > > 27. at org.apache.phoenix.iterate.RegionScannerFactory$1. > nextRaw(RegionScannerFactory.java:214) > > 28. at org.apache.phoenix.iterate.RegionScannerResultIterator. > next(RegionScannerResultIterator.java:61) > > 29. at org.apache.phoenix.iterate.OrderedResultIterator. > getResultIterator(OrderedResultIterator.java:255) > > 30. at org.apache.phoenix.iterate.OrderedResultIterator.next( > OrderedResultIterator.java:199) > > 31. at org.apache.phoenix.iterate.NonAggregateRegionScannerFacto > ry.getTopNScanner(NonAggregateRegionScannerFactory.java:319) > > 32. at org.apache.phoenix.iterate.NonAggregateRegionScannerFacto > ry.getRegionScanner(NonAggregateRegionScannerFactory.java:161) > > 33. at org.apache.phoenix.coprocessor.ScanRegionObserver. > doPostScannerOpen(ScanRegionObserver.java:72) > > 34. at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$ > RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221) > > 35. at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$ > RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266) > > 36. at org.apache.hadoop.hbase.regionserver.RSRpcServices. > scan(RSRpcServices.java:2580) > > 37. at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) > > 38. at org.apache.hadoop.hbase.ipc. > RpcServer.call(RpcServer.java:2196) > > 39. at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner. > java:112) > > 40. at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:133) > > 41. at org.apache.hadoop.hbase.ipc. > RpcExecutor$1.run(RpcExecutor.java:108) > > 42. at java.lang.Thread.run(Thread.java:745) > > 43. Caused by: java.lang.NullPointerException > > 44. at org.apache.phoenix.execute.TupleProjector.projectResults( > TupleProjector.java:286) > > 45. at org.apache.phoenix.iterate.RegionScannerFactory$1. > nextRaw(RegionScannerFactory.java:204) > > 46. ... 15 more > > 47. > > 48. at org.apache.phoenix.util.ServerUtil.parseServerException( > ServerUtil.java:113) > > 49. at org.apache.phoenix.iterate.BaseResultIterators. > getIterators(BaseResultIterators.java:852) > > 50. at org.apache.phoenix.iterate.BaseResultIterators. > getIterators(BaseResultIterators.java:796) > > 51. at org.apache.phoenix.iterate.MergeSortResultIterator. > getMinHeap(MergeSortResultIterator.java:72) > > 52. at org.apache.phoenix.iterate.MergeSortResultIterator. > minIterator(MergeSortResultIterator.java:93) > > 53. at org.apache.phoenix.iterate.MergeSortResultIterator.next( > MergeSortResultIterator.java:58) > > 54. at org.apache.phoenix.iterate.MergeSortTopNResultIterator. > next(MergeSortTopNResultIterator.java:95) > > 55. at org.apache.phoenix.execute.SortMergeJoinPlan$ > BasicJoinIterator.init(SortMergeJoinPlan.java:356) > > 56. at org.apache.phoenix.execute.SortMergeJoinPlan$ > BasicJoinIterator.next(SortMergeJoinPlan.java:286) > > 57. at org.apache.phoenix.iterate.OrderedResultIterator. > getResultIterator(OrderedResultIterator.java:255) > > 58. at org.apache.phoenix.iterate.OrderedResultIterator.next( > OrderedResultIterator.java:199) > > 59. at org.apache.phoenix.execute.SortMergeJoinPlan$ > BasicJoinIterator.init(SortMergeJoinPlan.java:351) > > 60. at org.apache.phoenix.execute.SortMergeJoinPlan$ > BasicJoinIterator.next(SortMergeJoinPlan.java:286) > > 61. at org.apache.phoenix.jdbc.PhoenixResultSet.next( > PhoenixResultSet.java:778) > > 62. at sqlline.BufferedRows.<init>(BufferedRows.java:37) > > 63. at sqlline.SqlLine.print(SqlLine.java:1660) > > 64. at sqlline.Commands.execute(Commands.java:833) > > 65. at sqlline.Commands.sql(Commands.java:732) > > 66. at sqlline.SqlLine.dispatch(SqlLine.java:813) > > 67. at sqlline.SqlLine.begin(SqlLine.java:686) > > 68. at sqlline.SqlLine.start(SqlLine.java:398) > > 69. at sqlline.SqlLine.main(SqlLine.java:291) > > 70. Caused by: java.util.concurrent.ExecutionException: > org.apache.phoenix.exception.PhoenixIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: > RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.: null > > 71. at org.apache.phoenix.util.ServerUtil.createIOException( > ServerUtil.java:92) > > 72. at org.apache.phoenix.util.ServerUtil.throwIOException( > ServerUtil.java:58) > > 73. at org.apache.phoenix.iterate.RegionScannerFactory$1. > nextRaw(RegionScannerFactory.java:214) > > 74. at org.apache.phoenix.iterate.RegionScannerResultIterator. > next(RegionScannerResultIterator.java:61) > > 75. at org.apache.phoenix.iterate.OrderedResultIterator. > getResultIterator(OrderedResultIterator.java:255) > > 76. at org.apache.phoenix.iterate.OrderedResultIterator.next( > OrderedResultIterator.java:199) > > 77. at org.apache.phoenix.iterate.NonAggregateRegionScannerFacto > ry.getTopNScanner(NonAggregateRegionScannerFactory.java:319) > > 78. at org.apache.phoenix.iterate.NonAggregateRegionScannerFacto > ry.getRegionScanner(NonAggregateRegionScannerFactory.java:161) > > 79. at org.apache.phoenix.coprocessor.ScanRegionObserver. > doPostScannerOpen(ScanRegionObserver.java:72) > > 80. at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$ > RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221) > > 81. at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$ > RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266) > > 82. at org.apache.hadoop.hbase.regionserver.RSRpcServices. > scan(RSRpcServices.java:2580) > > 83. at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) > > 84. at org.apache.hadoop.hbase.ipc. > RpcServer.call(RpcServer.java:2196) > > 85. at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner. > java:112) > > 86. at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:133) > > 87. at org.apache.hadoop.hbase.ipc. > RpcExecutor$1.run(RpcExecutor.java:108) > > 88. at java.lang.Thread.run(Thread.java:745) > > 89. Caused by: java.lang.NullPointerException > > 90. at org.apache.phoenix.execute.TupleProjector.projectResults( > TupleProjector.java:286) > > 91. at org.apache.phoenix.iterate.RegionScannerFactory$1. > nextRaw(RegionScannerFactory.java:204) > > 92. ... 15 more > > 93. > > 94. at java.util.concurrent.FutureTask.report(FutureTask. > java:122) > > 95. at java.util.concurrent.FutureTask.get(FutureTask.java:206) > > 96. at org.apache.phoenix.iterate.BaseResultIterators. > getIterators(BaseResultIterators.java:847) > > 97. ... 20 more > > 98. Caused by: org.apache.phoenix.exception.PhoenixIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,, > 1501224108837.1fc1615f5be984e13329b31a902ebf44.: null > > 99. at org.apache.phoenix.util.ServerUtil.createIOException( > ServerUtil.java:92) > > 100. at org.apache.phoenix.util. > ServerUtil.throwIOException(ServerUtil.java:58) > > 101. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214) > > 102. at org.apache.phoenix.iterate. > RegionScannerResultIterator.next(RegionScannerResultIterator.java:61) > > 103. at org.apache.phoenix.iterate. > OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255) > > 104. at org.apache.phoenix.iterate. > OrderedResultIterator.next(OrderedResultIterator.java:199) > > 105. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getTopNScanner( > NonAggregateRegionScannerFactory.java:319) > > 106. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getRegionScanner( > NonAggregateRegionScannerFactory.java:161) > > 107. at org.apache.phoenix.coprocessor. > ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72) > > 108. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate( > BaseScannerRegionObserver.java:221) > > 109. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.nextRaw( > BaseScannerRegionObserver.java:266) > > 110. at org.apache.hadoop.hbase. > regionserver.RSRpcServices.scan(RSRpcServices.java:2580) > > 111. at org.apache.hadoop.hbase. > protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod( > ClientProtos.java:33648) > > 112. at org.apache.hadoop.hbase.ipc. > RpcServer.call(RpcServer.java:2196) > > 113. at org.apache.hadoop.hbase.ipc. > CallRunner.run(CallRunner.java:112) > > 114. at org.apache.hadoop.hbase.ipc. > RpcExecutor.consumerLoop(RpcExecutor.java:133) > > 115. at org.apache.hadoop.hbase.ipc. > RpcExecutor$1.run(RpcExecutor.java:108) > > 116. at java.lang.Thread.run(Thread. > java:745) > > 117. Caused by: java.lang.NullPointerException > > 118. at org.apache.phoenix.execute. > TupleProjector.projectResults(TupleProjector.java:286) > > 119. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204) > > 120. ... 15 more > > 121. > > 122. at org.apache.phoenix.util.ServerUtil. > parseServerException(ServerUtil.java:113) > > 123. at org.apache.phoenix.iterate. > TableResultIterator.next(TableResultIterator.java:146) > > 124. at org.apache.phoenix.iterate. > LookAheadResultIterator$1.advance(LookAheadResultIterator.java:47) > > 125. at org.apache.phoenix.iterate. > LookAheadResultIterator.init(LookAheadResultIterator.java:59) > > 126. at org.apache.phoenix.iterate. > LookAheadResultIterator.peek(LookAheadResultIterator.java:73) > > 127. at org.apache.phoenix.iterate. > ParallelIterators$1.call(ParallelIterators.java:121) > > 128. at org.apache.phoenix.iterate. > ParallelIterators$1.call(ParallelIterators.java:106) > > 129. at java.util.concurrent. > FutureTask.run(FutureTask.java:266) > > 130. at org.apache.phoenix.job.JobManager$ > InstrumentedJobFutureTask.run(JobManager.java:183) > > 131. at java.util.concurrent. > ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > > 132. at java.util.concurrent. > ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > > 133. at java.lang.Thread.run(Thread. > java:745) > > 134. Caused by: > org.apache.phoenix.exception.PhoenixIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,, > 1501224108837.1fc1615f5be984e13329b31a902ebf44.: null > > 135. at org.apache.phoenix.util. > ServerUtil.createIOException(ServerUtil.java:92) > > 136. at org.apache.phoenix.util. > ServerUtil.throwIOException(ServerUtil.java:58) > > 137. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214) > > 138. at org.apache.phoenix.iterate. > RegionScannerResultIterator.next(RegionScannerResultIterator.java:61) > > 139. at org.apache.phoenix.iterate. > OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255) > > 140. at org.apache.phoenix.iterate. > OrderedResultIterator.next(OrderedResultIterator.java:199) > > 141. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getTopNScanner( > NonAggregateRegionScannerFactory.java:319) > > 142. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getRegionScanner( > NonAggregateRegionScannerFactory.java:161) > > 143. at org.apache.phoenix.coprocessor. > ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72) > > 144. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate( > BaseScannerRegionObserver.java:221) > > 145. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.nextRaw( > BaseScannerRegionObserver.java:266) > > 146. at org.apache.hadoop.hbase. > regionserver.RSRpcServices.scan(RSRpcServices.java:2580) > > 147. at org.apache.hadoop.hbase. > protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod( > ClientProtos.java:33648) > > 148. at org.apache.hadoop.hbase.ipc. > RpcServer.call(RpcServer.java:2196) > > 149. at org.apache.hadoop.hbase.ipc. > CallRunner.run(CallRunner.java:112) > > 150. at org.apache.hadoop.hbase.ipc. > RpcExecutor.consumerLoop(RpcExecutor.java:133) > > 151. at org.apache.hadoop.hbase.ipc. > RpcExecutor$1.run(RpcExecutor.java:108) > > 152. at java.lang.Thread.run(Thread. > java:745) > > 153. Caused by: java.lang.NullPointerException > > 154. at org.apache.phoenix.execute. > TupleProjector.projectResults(TupleProjector.java:286) > > 155. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204) > > 156. ... 15 more > > 157. > > 158. at org.apache.phoenix.util.ServerUtil. > parseServerException(ServerUtil.java:113) > > 159. at org.apache.phoenix.iterate. > ScanningResultIterator.next(ScanningResultIterator.java:65) > > 160. at org.apache.phoenix.iterate. > TableResultIterator.next(TableResultIterator.java:139) > > 161. ... 10 more > > 162. Caused by: > org.apache.hadoop.hbase.DoNotRetryIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,, > 1501224108837.1fc1615f5be984e13329b31a902ebf44.: null > > 163. at org.apache.phoenix.util. > ServerUtil.createIOException(ServerUtil.java:92) > > 164. at org.apache.phoenix.util. > ServerUtil.throwIOException(ServerUtil.java:58) > > 165. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214) > > 166. at org.apache.phoenix.iterate. > RegionScannerResultIterator.next(RegionScannerResultIterator.java:61) > > 167. at org.apache.phoenix.iterate. > OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255) > > 168. at org.apache.phoenix.iterate. > OrderedResultIterator.next(OrderedResultIterator.java:199) > > 169. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getTopNScanner( > NonAggregateRegionScannerFactory.java:319) > > 170. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getRegionScanner( > NonAggregateRegionScannerFactory.java:161) > > 171. at org.apache.phoenix.coprocessor. > ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72) > > 172. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate( > BaseScannerRegionObserver.java:221) > > 173. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.nextRaw( > BaseScannerRegionObserver.java:266) > > 174. at org.apache.hadoop.hbase. > regionserver.RSRpcServices.scan(RSRpcServices.java:2580) > > 175. at org.apache.hadoop.hbase. > protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod( > ClientProtos.java:33648) > > 176. at org.apache.hadoop.hbase.ipc. > RpcServer.call(RpcServer.java:2196) > > 177. at org.apache.hadoop.hbase.ipc. > CallRunner.run(CallRunner.java:112) > > 178. at org.apache.hadoop.hbase.ipc. > RpcExecutor.consumerLoop(RpcExecutor.java:133) > > 179. at org.apache.hadoop.hbase.ipc. > RpcExecutor$1.run(RpcExecutor.java:108) > > 180. at java.lang.Thread.run(Thread. > java:745) > > 181. Caused by: java.lang.NullPointerException > > 182. at org.apache.phoenix.execute. > TupleProjector.projectResults(TupleProjector.java:286) > > 183. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204) > > 184. ... 15 more > > 185. > > 186. at sun.reflect. > NativeConstructorAccessorImpl.newInstance0(Native Method) > > 187. at sun.reflect. > NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl. > java:62) > > 188. at sun.reflect. > DelegatingConstructorAccessorImpl.newInstance( > DelegatingConstructorAccessorImpl.java:45) > > 189. at java.lang.reflect.Constructor. > newInstance(Constructor.java:423) > > 190. at org.apache.hadoop.ipc. > RemoteException.instantiateException(RemoteException.java:106) > > 191. at org.apache.hadoop.ipc. > RemoteException.unwrapRemoteException(RemoteException.java:95) > > 192. at org.apache.hadoop.hbase. > protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:329) > > 193. at org.apache.hadoop.hbase. > client.ScannerCallable.call(ScannerCallable.java:262) > > 194. at org.apache.hadoop.hbase. > client.ScannerCallable.call(ScannerCallable.java:64) > > 195. at org.apache.hadoop.hbase. > client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:210) > > 196. at org.apache.hadoop.hbase.client. > ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas. > java:364) > > 197. at org.apache.hadoop.hbase.client. > ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas. > java:338) > > 198. at org.apache.hadoop.hbase. > client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:136) > > 199. at org.apache.hadoop.hbase.client. > ResultBoundedCompletionService$QueueingFuture.run( > ResultBoundedCompletionService.java:65) > > 200. ... 3 more > > 201. Caused by: org.apache.hadoop.hbase.ipc. > RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException): > org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,, > 1501224108837.1fc1615f5be984e13329b31a902ebf44.: null > > 202. at org.apache.phoenix.util. > ServerUtil.createIOException(ServerUtil.java:92) > > 203. at org.apache.phoenix.util. > ServerUtil.throwIOException(ServerUtil.java:58) > > 204. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214) > > 205. at org.apache.phoenix.iterate. > RegionScannerResultIterator.next(RegionScannerResultIterator.java:61) > > 206. at org.apache.phoenix.iterate. > OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255) > > 207. at org.apache.phoenix.iterate. > OrderedResultIterator.next(OrderedResultIterator.java:199) > > 208. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getTopNScanner( > NonAggregateRegionScannerFactory.java:319) > > 209. at org.apache.phoenix.iterate. > NonAggregateRegionScannerFactory.getRegionScanner( > NonAggregateRegionScannerFactory.java:161) > > 210. at org.apache.phoenix.coprocessor. > ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72) > > 211. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate( > BaseScannerRegionObserver.java:221) > > 212. at org.apache.phoenix.coprocessor. > BaseScannerRegionObserver$RegionScannerHolder.nextRaw( > BaseScannerRegionObserver.java:266) > > 213. at org.apache.hadoop.hbase. > regionserver.RSRpcServices.scan(RSRpcServices.java:2580) > > 214. at org.apache.hadoop.hbase. > protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod( > ClientProtos.java:33648) > > 215. at org.apache.hadoop.hbase.ipc. > RpcServer.call(RpcServer.java:2196) > > 216. at org.apache.hadoop.hbase.ipc. > CallRunner.run(CallRunner.java:112) > > 217. at org.apache.hadoop.hbase.ipc. > RpcExecutor.consumerLoop(RpcExecutor.java:133) > > 218. at org.apache.hadoop.hbase.ipc. > RpcExecutor$1.run(RpcExecutor.java:108) > > 219. at java.lang.Thread.run(Thread. > java:745) > > 220. Caused by: java.lang.NullPointerException > > 221. at org.apache.phoenix.execute. > TupleProjector.projectResults(TupleProjector.java:286) > > 222. at org.apache.phoenix.iterate. > RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204) > > 223. ... 15 more > > 224. > > 225. at org.apache.hadoop.hbase.ipc. > RpcClientImpl.call(RpcClientImpl.java:1267) > > 226. at org.apache.hadoop.hbase.ipc. > AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:227) > > 227. at org.apache.hadoop.hbase.ipc. > AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod( > AbstractRpcClient.java:336) > > 228. at org.apache.hadoop.hbase. > protobuf.generated.ClientProtos$ClientService$BlockingStub.scan( > ClientProtos.java:34094) > > 229. at org.apache.hadoop.hbase. > client.ScannerCallable.call(ScannerCallable.java:219) > > 230. ... 9 more > > > > > > The same behavior was observed for 4.11 phoenix with hbase1.2.6 . > > 4.10 phoenix client with Hbase0.98 works fine with both queries. > > Any thoughts Please. > > > > Thanks > > Siddharth Ubale. > > >
