开发者社区 问答 正文

Some questions about limit push down

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*来自志愿者整理的flink邮件归档

展开
收起
CCCC 2021-12-02 14:56:47 559 分享
分享
版权
举报
1 条回答
写回答
取消 提交回答
  • Currently, the rule PushLimitIntoTableSourceScanRule captures the structure that the FlinkLogicalSort node is the parent of the FlinkLogicalTableSourceScan.

    In your case, we have a Calc node between the Sort node and the Scan node, which makes the rule fails to apply.

    Maybe we can add a rule to transpose between the Sort and Calc.*来自志愿者整理的FLINK邮件归档

    2021-12-02 16:00:19 举报
    赞同 评论

    评论

    全部评论 (0)

    登录后可评论
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等