Re: hive 0.14 return some not NULL value as NULL

Can you also supply the table's DDL and a few lines of your raw data? Daniel > On 1 באפר׳ 2015, at 09:16, "r7raul1...@163.com" wrote: > > > > > I use hive 0.14 the result is > 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 9150119100048 > 7326356 NULL > 87FQEZT1

hive 0.14 return some not NULL value as NULL

I use hive 0.14 the result is 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 9150119100048 7326356 NULL 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 121501191035580028 7326356 NULL UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG2362223711289 1615

Re: Standard deviation (STDDEV) function calculation in Hive

Mich, the linked documentation is for Impala, not Hive. (Perhaps Hive is the same, I don't know.) But the Hive documentation doesn't explain much: Built-in Aggregate Functions (UDAF)

Re: ORDER BY clause in Hive

Thanks for the update, Mich. And thanks to you & Gopal for prompting me to get the documentation done. -- Lefty On Tue, Mar 31, 2015 at 5:20 AM, Mich Talebzadeh wrote: > Thanks Lefty for the information provided. > > > > My version of hive is 014.0 > > > > hive --version > > Hive 0.14.0 > > >

RE: hive union all same table

hive> select ti,count(1) from xx where day=20150330 group by ti> union all > select ti,count(1) from xx where day=20150330 group by ti;Total jobs = 3Launching Job 1 out of 3 From: smart...@hotmail.com To: user@hive.apache.org Subject: hive union all same table Date: Wed, 1 Apr 2015 03:

hive union all same table

Hi I want to query table_a by different where clause as follow select * from ( select col1, count(1) from table_a where col2 ='xx' group by col1 union all select col1, count(1) from table_a where col2 ='xx' group by col1 union all select col1, count(1)

empty plan shows when explaining CTAS query

When explaining a CTAS query, no execution plan shows somehow. 0: jdbc:hive2://localhost:1/default> explain create table if not exists test1 as select c1, count(distinct c2) as cnt from test group by c1 order by c1; +--+--+ | Explain| +-

Pyhs2: connection reset

A script that I am supporting uses pyhs2 to query hive from python and is no longer working. It used to work fine and now gets an errno 104 "Connection reset by peer". I have tried different connection settings (different port or host, just to see what happens or Kerberos auth) and get TTransp

RE: ORDER BY clause in Hive

Thanks Lefty for the information provided. My version of hive is 014.0 hive --version Hive 0.14.0 Which should support the configuration parameter at the session level à set hive.groupby.orderby.position.alias=true set hive.groupby.orderby.position.alias=true; SELECT