[
https://issues.apache.org/jira/browse/DRILL-1984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Deneche A. Hakim updated DRILL-1984:
------------------------------------
Fix Version/s: (was: 0.9.0)
1.0.0
> 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: Deneche A. Hakim
> Fix For: 1.0.0
>
> Attachments: drillbit.log, drillbit.out,
> drillclient20150109T155028.log, driver.log
>
>
> . 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)
