[ZEPPELIN-5299] Comment at end of query causes query to be ignored

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 0.9.1, 0.10.0

Environment

Bug found in Zeppelin 0.9.0-preview1, which is included in the AWS EMR 6.2.0 release.

• Assignee: Jeff Zhang
• Reporter: Jon Courtney
• Created: 25/Mar/21 15:25
• Updated: 07/Apr/21 05:42
• Resolved: 07/Apr/21 05:42

Description

A trailing comment at the end of a query causes the query to be ignored.  Running a cell with such a query will cause Zeppelin to return immediately, without an error.

Example:

%sql
select
  'one'
  , 'two' -- comment

Workaround: Adding a final ';' at the end of the query fixes the problem, like so:

%sql
select
  'one'
  , 'two' -- comment
;