Re: SQL CTAS query failed on compilation stage

ok fine. LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of

Re: SQL CTAS query failed on compilation stage

I understand, but it looks strange as a query without the "create table" clause works. Obviously I use the workaround, but I think Hive as an application should be more predictable in interaction, so I created a JIRA for the issue. https://issues.apache.org/jira/browse/HIVE-24352 Regards, Bartosz

Re: SQL CTAS query failed on compilation stage

well you have to be pragmatic. That may well be a bug due to Hive, especially it says "Also check for circular dependencies" you can raise a JIRA but not sure about its priority as you have a work-around HTH LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOA

Re: SQL CTAS query failed on compilation stage

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 napisał(a): > Hm, > > Hi Bartosz, > > Can you create a temporary table with your sub-query and see it works? > > create tem

Re: SQL CTAS query failed on compilation stage

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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

SQL CTAS query failed on compilation stage

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 o