Attila Magyar created HIVE-25223: ------------------------------------ Summary: 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 Fix For: 4.0.0
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)