Re: Trying to improve compression ratio for an ORC table

2015-01-18 Thread Gopal V
On 1/18/15, 10:11 PM, Daniel Haviv wrote: I have an ORC table with the "orc.compress"="SNAPPY" property that weighs 4.9 GB and is composed of 253 files.. I then do a CTAS into a new table where I added this property "orc.compress.size"="2485760" to improve the compression ratio. The new table w

show create table issue

2015-01-18 Thread AnilKumar B
Hi All, We have observed that "show create table " is not providing the information on serde's. Is it a bug or intention? describe formatted is showing the serde's info properly. Thanks & Regards, B Anil Kumar.

Trying to improve compression ratio for an ORC table

2015-01-18 Thread Daniel Haviv
Hi guys, I'm experiencing something very odd: I have an ORC table with the "orc.compress"="SNAPPY" property that weighs 4.9 GB and is composed of 253 files.. I then do a CTAS into a new table where I added this property "orc.compress.size"="2485760" to improve the compression ratio. The new table

Re: Hive UPDATE : query around usage

2015-01-18 Thread Devopam Mittra
hi Lefty, Thanks again for the crisp response. After going through it all over again , and brooding over the weekend I understood that my ask is yet not there and I was trying to do things in a (yet) impractical way. I am sure it will be the need in future , if we were to use and promote Hive as T

Re:

2015-01-18 Thread Navis류승우
There seemed not registered issue in hive. Really appreciate if you do that. Thanks, Navis 2015-01-19 10:56 GMT+09:00 Dayong : > Is it reported? If not, I'll report it? > > Thanks, > Dayong > > On Jan 18, 2015, at 8:41 PM, Navis류승우 wrote: > > Yes, it's a bug. Seemed not handling properly with P

Re:

2015-01-18 Thread Dayong
Is it reported? If not, I'll report it? Thanks, Dayong > On Jan 18, 2015, at 8:41 PM, Navis류승우 wrote: > > Yes, it's a bug. Seemed not handling properly with PRECEDING+PRECEDING or > FOLLOWING+FOLLOWING cases. > > Thanks, > Navis > > 2015-01-18 4:40 GMT+09:00 DU DU : >> Hi folks, >> The windo

Re:

2015-01-18 Thread Navis류승우
Yes, it's a bug. Seemed not handling properly with PRECEDING+PRECEDING or FOLLOWING+FOLLOWING cases. Thanks, Navis 2015-01-18 4:40 GMT+09:00 DU DU : > Hi folks, > The window clause in Hive 0.13.* does not work for the following example > statement > >- BETWEEN 2 PRECEDING AND 1 PRECEDING >