Hi all, After we upgrade Impala from 2.5 to 2.12, we found some queries on views failed. The views contain a query hint which I think is the cause. I can't find anything about such kind of incompatibility was mentioned in https://www.cloudera.com/documentation/enterprise/release-notes/topics/impala_new_features.html or https://www.cloudera.com/documentation/enterprise/release-notes/topics/impala_incompatible_changes.html
The error can be reproduced by [impala-shell:21000] > use test; [impala-shell:21000] > create view view_2_12 as select /* +`queryId=abc` */ * from video_parq; Query: create view view_2_12 as select /* +`queryId=abc` */ * from video_parq +------------------------+ | summary | +------------------------+ | View has been created. | +------------------------+ WARNINGS: PLAN hint not recognized: queryId=abc Fetched 1 row(s) in 24.00s [impala-shell:21000] > desc formatted view_2_12; Query: describe formatted view_2_12 ERROR: AnalysisException: Failed to parse view-definition statement of view: test.view_2_12 CAUSED BY: TableLoadingException: Failed to parse view-definition statement of view: test.view_2_12 Since this's an emergency for us, I post an email here for help. I'm also looking into the history of the cup file and looking for a hotfix for this. Thanks if anyone can give some pointers! Thanks, Quanlong
