[IMPALA-638] Impala service fail when submitting query with "non" valid regex

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.1.1
• Fix Version/s: Impala 1.2
• Labels: regexp_extract rlike sql
• Environment: CDH 4.3 using parcels, Impala 1.1.1 using parcel, CENTOS
• Assignee: Unassigned
• Reporter: Sergey
• Created: 24/Oct/13 13:01
• Updated: 20/Dec/15 00:05
• Resolved: 20/Nov/13 00:08

Description

A query:

select *
from http_20131001
where
  host like "%somehost.lol" and
  (uri rlike ".+(?<!(tl|br)_lat=)55(\\.|,)\\d+.+(?<!(tl|br)_lon=)37(\\.|,)\\d+.+" or
   uri rlike ".+(?<!(tl|br)_lon=)37(\\.|,)\\d+.+(?<!(tl|br)_lat=)55(\\.|,)\\d+.+")
limit 30;

HUe response:

Your query has the following error(s):

Could not connect to prod-node012.lol.ru:21050

click the Error Log tab below for details

Cloudera manager impalad daemons health after submitting query:

Unexpected Exits: 12 Bad  1 Good
Host Health: 13 Good
Resident Set Size : 13 Checks disabled
StateStore Connectivity: 13 Good
Log Directory Free Space: 13 Checks disabled
Web Server Status: 13 Checks disabled
Process Status: 1 Bad  12 Good
File Descriptors: 13 Checks disabled

impalad log:

16:57:30.651	INFO	status.cc:44	
Invalid regular expression: .+(?<!(tl|br)_lat=)55(\.|,)\d+.+(?<!(tl|br)_lon=)37(\.|,)\d+.+
    @           0x83af7d  (unknown)
    @           0x732174  (unknown)
    @           0x7245fb  (unknown)
    @           0x726776  (unknown)
    @           0x73ff29  (unknown)
    @           0x72440a  (unknown)
    @           0x906a4d  (unknown)
    @           0x964373  (unknown)
    @           0x964483  (unknown)
    @           0x9269f2  (unknown)
    @           0x910936  (unknown)
    @           0x90a680  (unknown)
    @           0x9a36c4  (unknown)
    @       0x33f0407851  (unknown)
    @       0x33f00e811d  (unknown)

And then all daemons are restarted automatically.