drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1984) Drillbit does not send the last RPC message when "limit" is appended to queries on hbase voter table
Date Fri, 15 May 2015 22:25:59 GMT

     [ 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: 1.2.0)
                   Future

> 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: Future
>
>         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)

Mime
View raw message