[
https://issues.apache.org/jira/browse/HIVE-25223?focusedWorklogId=609716&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-609716
]
ASF GitHub Bot logged work on HIVE-25223:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 10/Jun/21 14:00
Start Date: 10/Jun/21 14:00
Worklog Time Spent: 10m
Work Description: kasakrisz merged pull request #2375:
URL: https://github.com/apache/hive/pull/2375
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 609716)
Time Spent: 0.5h (was: 20m)
> 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)
