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 Kotwica
wt., 3 lis 2020 o 11:57 Mich Talebzadeh
napisał(a):
> 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=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <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 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 10:46, Bartek Kotwica wrote:
>
>> 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 temporary table tab2 as ...
>>>
>>> HTH
>>>
>>>
>>>
>>> LinkedIn *
>>> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>> <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 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 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=4)
>>>>
>>>> Please confirm the issue then I will create a Jira ticket.
>>>>
>>>> Kind regards,
>>>> Bartosz Kotwica
>>>>
>>>
