Re: SQL CTAS query failed on compilation stage

2020-11-03 Thread Bartek Kotwica
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 los

Re: SQL CTAS query failed on compilation stage

2020-11-03 Thread Bartek Kotwica
mages 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 wit

SQL CTAS query failed on compilation stage

2020-11-03 Thread Bartek Kotwica
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