Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-5951

SQL过滤条件过太复杂导致 无法抽取过滤列/SegmentPruning失效

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 5.0-beta
    • None
    • Query Engine
    • None

    Description

      版本:kylin5/77201e7b

      这些sql是内部报表系统拼接的sql。

       

      导出模型/查询诊断包(包含模型和表等元数据) 在附件中。

      error_sql_1

      过滤条件太复杂,导致过滤列没能提取出来

       

      error_sql_2

      过滤条件太多,导致segmentpruning失败

      修改 kylin.query.filter-condition-count=1000 参数可以绕过这个问题。

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            Unassigned Unassigned
            jlelehe Jiale He
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: