[jira] [Commented] (FLINK-20809) Limit push down with Hive table doesn't work when using with filter

["Jark Wu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-20809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17256295#comment-17256295 ] 

Jark Wu commented on FLINK-20809:
---------------------------------

cc [~lirui], could you help to check this?

> Limit push down with Hive table doesn't work when using with filter
> -------------------------------------------------------------------
>
>                 Key: FLINK-20809
>                 URL: https://issues.apache.org/jira/browse/FLINK-20809
>             Project: Flink
>          Issue Type: Bug
>          Components: Connectors / Hive
>    Affects Versions: 1.12.0
>            Reporter: Jun Zhang
>            Priority: Major
>             Fix For: 1.13.0
>
>
> when I use flink sql to query hive table , like this 
> {code:java}
> // select * from hive_table where id = 1 limit 1
> {code}
>  
> when the sql contain query conditions in where clause, I found that the limit push down is invalid.
> I look up the comment on source code , I think it is should be push down , is it a bug ?
> [the comment |https://github.com/apache/flink/blob/master/flink-table/flink-table-planner-blink/src/main/java/org/apache/flink/table/planner/plan/rules/logical/PushLimitIntoTableSourceScanRule.java#L64]



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