The warning seems to come from SelectList.java:87 <https://github.com/apache/impala/blob/64e6719870db5602a6fa85014bc6c264080b9414/fe/src/main/java/org/apache/impala/analysis/SelectList.java#L87> which also was in 2.5 (SelectList.java:85 <https://github.com/cloudera/Impala/blob/cdh5-2.5.0_5.7.0/fe/src/main/java/com/cloudera/impala/analysis/SelectList.java#L85>. Do you see corresponding errors in the logfiles for the AnalysisException?
On Thu, Aug 23, 2018 at 7:53 PM Todd Lipcon <t...@cloudera.com> wrote: > I'm curious: can you describe the view using Hive to see what the stored > query consists of? > > On Thu, Aug 23, 2018, 7:44 PM Quanlong Huang <huangquanl...@gmail.com> > wrote: > >> 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 >> >