Re: wrong result with CTAS(create table as select)

2017-06-21 Thread Barna Zsombor Klara
Hi Xiaomeng, this definitely seems like a bug, but I can't reproduce it on the master branch. Can you tell me which version of Hive you are using? On Wed, Jun 21, 2017 at 10:26 AM, Xiaomeng Huang wrote: > Hi, I missed a bug when use CTAS. > > 1. > hive> select 'test' as did from abc_test_old >

wrong result with CTAS(create table as select)

2017-06-21 Thread Xiaomeng Huang
Hi, I missed a bug when use CTAS. 1. hive> select 'test' as did from abc_test_old > where did = '5FCAFD34-C124-4E13-AF65-27B675C945CC' limit 1; OK test 2. hive> create table abc_test_12345 as > select 'test' as did from abc_test_old > where did = '5FCAFD34-C124-4E13-AF65-27B675C945CC