[IMPALA-3942] After creating a view that uses regexp_replace we are getting the following error: ERROR: AnalysisException: Failed to load metadata for table:

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.2.4
• Fix Version/s: Impala 2.12.0
• Component/s: Frontend
• Labels: newbie usability
• Assignee: Jin Chul Kim
• Reporter: Jeff Lord
• Created: 02/Aug/16 20:09
• Updated: 23/Oct/18 22:36
• Resolved: 23/Jan/18 20:51

Description

This was reproduced on nightly.

create view blown as select regexp_replace(description,"\\\\'","'") as descriptionf, * from sample_07;

After creating a view that uses regexp_replace we are getting the following error:

ERROR: AnalysisException: Failed to load metadata for table: 'customers_view'
CAUSED BY: TableLoadingException: Failed to parse view-definition statement of view: netsuite.customers_view

Screenshot is attached.
This is likely related to
https://issues.cloudera.org/browse/IMPALA-3941

Issue Links

• is duplicated by: IMPALA-6167 Single quotes inside double quotes drop data