Re: Hive query on ORC table is really slow compared to Presto

With ORC tables have you tried set hive.vectorized.execution.enabled = true; set hive.vectorized.execution.reduce.enabled = true; SET hive.exec.parallel=true; -- set hive.optimize.ppd=true; HTH Dr Mich Talebzadeh LinkedIn *

Re: Hive query on ORC table is really slow compared to Presto

Gopal, Thanx for the debugging steps. Here's the output *hive> select count(1) as collisions, hash(ip) from table group by hash(ip) order by collisions desc limit 10;* 4 -1432955330 4 -317748560 4 -1460629578 4 1486313154 4 -320519155 4 1875999753 4

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

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

wrong result with CTAS(create table as select)

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 =