[DRILL-6450] Visualized plans for profiles querying JDBC sources is broken

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.14.0
• Component/s: Query Planning & Optimization, Storage - JDBC
• Labels: ready-to-commit
• Assignee: Kunal Khatua
• Reporter: Kunal Khatua
• Reviewer: Aman Sinha
• Created: 29/May/18 18:27
• Updated: 05/Jun/18 00:18
• Resolved: 05/Jun/18 00:18

Description

When viewing a profile for a query against a JDBC source, the visualized plan is not rendered. This is because the generated SQL pushed down to the JDBC source has a line break injected just before the FROM clause.

The workaround is to strip away any injected newlines at least for the SQL defined in the text plan, so that the backend Javascript can render it correctly.

Issue Links

• links to: GitHub Pull Request #1295