Cannot support join operations in scans with limit

[Alex Kamil <al...@gmail.com>]

We're getting below exception in sqlline in phoenix 4.6 (community edition)
with hbase1.0_cdh5.5, any ideas?


0: jdbc:phoenix:localhost> select * from table2 B join (select id from
table1) A on A.id=B.otherid;
java.lang.RuntimeException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException: *Failed after retry of
OutOfOrderScannerNextException: was there a rpc timeout?*
        at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
        at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
        at sqlline.SqlLine.print(SqlLine.java:1653)
        at sqlline.Commands.execute(Commands.java:833)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:808)
        at sqlline.SqlLine.begin(SqlLine.java:681)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)


*in regionserver log:*


2016-02-10 22:39:13,579 DEBUG org.apache.hadoop.hbase.ipc.RpcServer:
B.defaultRpcServer.handler=0,queue=0,port=60020: callId: 2858 service:
ClientService methodName: Scan size: 24 connection: 172.17.66.31:63811

*java.io.IOException: Cannot support join operations in scans with limit*

        at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2068)

        at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107)

        at
org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)

        at
org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)

        at java.lang.Thread.run(Thread.java:744)

Caused by: java.lang.UnsupportedOperationException: Cannot support join
operations in scans with limit

        at
org.apache.phoenix.coprocessor.HashJoinRegionScanner.processResults(HashJoinRegionScanner.java:120)

        at
org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinRegionScanner.java:270)

        at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)

        at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2292)

        at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)

        at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2034)


*To Reproduce:*

CREATE TABLE table1( id bigint not null, message varchar CONSTRAINT pk
PRIMARY KEY (id) );
CREATE TABLE table2( id bigint not null, message varchar, otherid bigint
CONSTRAINT pk PRIMARY KEY (id) );
upsert into table1(id,message) values(123,'m1');
upsert into table1(id,message) values(456,'m2');
upsert into table2(id,message,otherid) values(789,'m1',123);
0: jdbc:phoenix:localhost> select * from table2 B join (select id from
table1) A on A.id=B.otherid;
java.lang.RuntimeException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException: Failed after retry of
OutOfOrderScannerNextException: was there a rpc timeout?
        at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
        at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
        at sqlline.SqlLine.print(SqlLine.java:1653)
        at sqlline.Commands.execute(Commands.java:833)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:808)
        at sqlline.SqlLine.begin(SqlLine.java:681)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)
0: jdbc:phoenix:localhost>