[KYLIN-4365] RDBMS pushdown failed with with clause

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: all
• Fix Version/s: v3.1.0
• Component/s: Query Engine, RDBMS Source
• Assignee: rongchuan.jin
• Reporter: rongchuan.jin
• Created: 01/Feb/20 05:51
• Updated: 31/Jul/20 12:25
• Resolved: 02/Feb/20 09:25

Description

When use pushdown for RDBMS, I query with following sql:

`with tmp as (select id from a),tmp2 as (select * from b) select * from tmp,tmp2 where tmp.id = tmp2.id` it will cause exception like 'table tmp not exists'.

Issue Links

• links to: GitHub Pull Request #1086