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.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319) 32. at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.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.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319) 78. at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.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.
