Some questions about limit push down

[Jun Zhang]

when I query hive table by sql, like this `select * from hivetable where id = 1 limit 1`,   I found that the limit push down is invalid, is it a bug or was it designed like this?

if the sql is  'select * from hivetable  limit 1'  ,it is ok

thanks

[Arvid Heise-3]

This is most likely a bug, could you reiterate a bit how it is invalid?

I'm also CCing Jark since he is one of the SQL experts.

On Mon, Dec 28, 2020 at 10:37 AM Jun Zhang <[hidden email]> wrote:

when I query hive table by sql, like this `select * from hivetable where id = 1 limit 1`,   I found that the limit push down is invalid, is it a bug or was it designed like this?

if the sql is  'select * from hivetable  limit 1'  ,it is ok

thanks

--