[jira] [Resolved] (HIVE-25223) Select with limit returns no rows on non native table

["Krisztian Kasa (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-25223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krisztian Kasa resolved HIVE-25223.
-----------------------------------
    Resolution: Fixed

Pushed to master. Thanks [~amagyar].

> Select with limit returns no rows on non native table
> -----------------------------------------------------
>
>                 Key: HIVE-25223
>                 URL: https://issues.apache.org/jira/browse/HIVE-25223
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Attila Magyar
>            Assignee: Attila Magyar
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Str:
> {code:java}
> CREATE EXTERNAL TABLE hht (key string, value int) 
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
> TBLPROPERTIES ("hbase.table.name" = "hht", "hbase.mapred.output.outputtable" = "hht");
> insert into hht select uuid(), cast((rand() * 1000000) as int);
> insert into hht select uuid(), cast((rand() * 1000000) as int) from hht;
> insert into hht select uuid(), cast((rand() * 1000000) as int) from hht;
> insert into hht select uuid(), cast((rand() * 1000000) as int) from hht;
> insert into hht select uuid(), cast((rand() * 1000000) as int) from hht;
> insert into hht select uuid(), cast((rand() * 1000000) as int) from hht;
> insert into hht select uuid(), cast((rand() * 1000000) as int) from hht;
>  set hive.fetch.task.conversion=none;
>  select * from hht limit 10;
> +----------+------------+
> | hht.key  | hht.value  |
> +----------+------------+
> +----------+------------+
> No rows selected (5.22 seconds) {code}
>  
> This is caused by GlobalLimitOptimizer. The table directory is always empty with a non native table since the data is not managed by hive (but hbase in this case).
> The optimizer scans the directory and sets the file list to an empty list.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)