Hi Mich, Thank you for the reply! Creating a stage table works well, a problem comes up when CTE or subquery in from clause is used.
wt., 3 lis 2020 o 10:45 Mich Talebzadeh <mich.talebza...@gmail.com> napisaĆ(a): > Hm, > > Hi Bartosz, > > Can you create a temporary table with your sub-query and see it works? > > create temporary table tab2 as ... > > HTH > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > > On Tue, 3 Nov 2020 at 09:28, Bartek Kotwica <bkotw...@gmail.com> wrote: > >> Hi! >> I use Hive 3.1.0 and beeline. >> I have encountered a compilation error when issue a CTAS query from >> beeline, but without "create table" query works as expected,* narrowed query >> to reproduce:* >> >> create table tab_error as >> with tab2 as ( >> select >> id, >> lead(id) over (partition by id order by id) as x >> from >> (select 1 id) a >> ) >> select >> lead(x) over (partition by id order by id) = 1 >> from >> tab2 >> ; >> >> *ERROR:* >> Error: Error while compiling statement: FAILED: SemanticException Failed >> to breakup Windowing invocations into Groups. At least 1 group must only >> depend on input columns. Also check for circular dependencies. >> Underlying error: org.apache.hadoop.hive.ql.parse.SemanticException: Line >> 0:-1 Invalid column reference '1': (possible column names are: ) >> (state=42000,code=40000) >> >> Please confirm the issue then I will create a Jira ticket. >> >> Kind regards, >> Bartosz Kotwica >> >