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 <[email protected]> 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 >
