oozie not running

2015-02-21 Thread Rahul Channe
Hi All, I configured the oozie build successfully and prepared oozie war file. After starting oozie when i tried to checkstatus its giving following error user@ubuntuvm:~/oozie-4.1.0/distro/target/oozie-4.1.0-distro/oozie-4.1.0$ bin/oozie admin -oozie http://localhost:11000/oozie -statusConnectio

Re: Union all with a field 'hard coded'

2015-02-21 Thread Lefty Leverenz
Yay! Thanks Pengcheng. -- Lefty On Sat, Feb 21, 2015 at 6:02 PM, kelphet wrote: > Hi Lefty and Xuefu, > > Thanks for the rigorous discussion. I confirm that this will apply to > UNION (DISTINCT) too according to HIVE-9039. That is to say, It is safe to > remove "ALL". Thanks. > > Best > P

Re: Union all with a field 'hard coded'

2015-02-21 Thread kelphet
Hi Lefty and Xuefu, Thanks for the rigorous discussion. I confirm that this will apply to UNION (DISTINCT) too according to HIVE-9039. That is to say, It is safe to remove "ALL". Thanks. Best Pengcheng On 2/21/15, 4:09 PM, Xuefu Zhang wrote: Tech writing assumes true unless proven fals

Re: Union all with a field 'hard coded'

2015-02-21 Thread Xuefu Zhang
Tech writing assumes true unless proven false. :) On Sat, Feb 21, 2015 at 1:13 PM, Lefty Leverenz wrote: > I haven't tried union distinct, but I assume the same rule applies. >> > > Reasonable assumption, so I'll remove "ALL" and see if anyone contradicts > it. (Tech writing by successive appro

Re: 38 digits vs 35 digits for Decimal type?

2015-02-21 Thread wfeng1982
how do you know that DECIMAL gives only 35 digits? 发自我的 iPhone > 在 2015年2月22日,00:23,Owen O'Malley 写道: > > Hive decimal supports 38 digits also. It is a natural size since it fits in > 127 bits. > > .. Owen > >> On Feb 21, 2015, at 07:35, Yang wrote: >> >> If I were to transfer a table from

Re: Union all with a field 'hard coded'

2015-02-21 Thread Lefty Leverenz
> > I haven't tried union distinct, but I assume the same rule applies. > Reasonable assumption, so I'll remove "ALL" and see if anyone contradicts it. (Tech writing by successive approximation.) Thanks again. -- Lefty On Sat, Feb 21, 2015 at 6:27 AM, Xuefu Zhang wrote: > I haven't tried uni

Re: 38 digits vs 35 digits for Decimal type?

2015-02-21 Thread Owen O'Malley
Hive decimal supports 38 digits also. It is a natural size since it fits in 127 bits. .. Owen > On Feb 21, 2015, at 07:35, Yang wrote: > > If I were to transfer a table from existing oracle to hive, I'd find it > impossible with NUMBER type columns. By default oracle NUMBER gives 38 bits, >

38 digits vs 35 digits for Decimal type?

2015-02-21 Thread Yang
If I were to transfer a table from existing oracle to hive, I'd find it impossible with NUMBER type columns. By default oracle NUMBER gives 38 bits, but hive's closest counterpart is the DECIMAL , which gives only 35 digits I'm curious how is the 35 digits determined when the DECIMAL type was int

Re: Union all with a field 'hard coded'

2015-02-21 Thread Xuefu Zhang
I haven't tried union distinct, but I assume the same rule applies. Thanks for putting it together. It looks good to me. --Xuefu On Fri, Feb 20, 2015 at 11:44 PM, Lefty Leverenz wrote: > Great, thanks Xuefu. So this only applies to UNION ALL, not UNION > DISTINCT? I had wondered about that.