Alexander Zarei created DRILL-1984:
--------------------------------------
Summary: Drillbit does not send the last RPC message when "limit"
is appended to queries on hbase voter table
Key: DRILL-1984
URL: https://issues.apache.org/jira/browse/DRILL-1984
Project: Apache Drill
Issue Type: Bug
Components: Execution - RPC
Affects Versions: 0.7.0
Environment: Windows/OS X
Reporter: Alexander Zarei
Assignee: Jacques Nadeau
. When using “limit” in queries on hbase “voter” table, drill server does not
return the very last RPC message. The very last RPC message is the one
translated by DrillClient to a null record batch to notify the ODBC driver of
the completion/failure of a query.
This problem is only with the voter table; I tested other hbase multi-region
and non-multi-region tables and they worked fine.
It is only queries such as
------------------------------------------------------------
SELECT * FROM (select cast(row_key as integer) voter_id, cast(voter.onecf.name
as varchar(30)) name, cast(voter.twocf.age as integer) age,
cast(voter.twocf.registration as varchar(20)) registration,
cast(voter.threecf.contributions as decimal(6,2)) contributions,
cast(voter.threecf.voterzone as integer)
voterzone,cast(voter.fourcf.create_date as timestamp) create_date from
hbase.voter) T LIMIT 0
select cast(row_key as integer) voter_id, cast(voter.onecf.name as varchar(30))
name, cast(voter.twocf.age as integer) age, cast(voter.twocf.registration as
varchar(20)) registration, cast(voter.threecf.contributions as decimal(6,2))
contributions, cast(voter.threecf.voterzone as integer)
voterzone,cast(voter.fourcf.create_date as timestamp) create_date from
hbase.voter limit 5
that fail because the very last RPC message is not sent from the server to the
DrillClient and as a result the driver keeps waiting for it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
