Re:

No I want to change 4to5 columns only outof 40 columns. On Wed, Jan 8, 2014 at 2:05 PM, Edward Capriolo wrote: > Alter table replace columns changes all columns and types. > > > On Wed, Jan 8, 2014 at 5:35 AM, Kishore kumar wrote: > >> Hi Experts, >> >> Is there a way to change multiple column

Re: write orcfile exception

Does it happen with trunk or any specific version of hive? Can you provide a test data that reproduces this issue? Thanks Prasanth Jayachandran On Jan 9, 2014, at 9:15 AM, bhsc.happy wrote: > write orcfile with compress CompressionKind.ZLIB or CompressionKind.SNAPPY > occur exception:(Compres

Hive setup

Hi, Is there any performance difference in running jobs using hive client (hive -f option inside shell scripts) vs configuring hiverserver2 and running jobs using thrift services with java programs? . Which is the preferred option and why? Thanks, Chandra

RE: merge columns and count no of records

Or Is it good idea to get data into shell variable/file and doing processing. Or using a pig script to do? hive -e 'select distinct(columnA), distinct(columnB) from blah' | sed 's/[\t]/,/g' >/tmp/test Thanks, Chandra From: Bogala, Chandra Reddy [Tech] Sent: Wednesday, January 08, 2014 5:49 P

write orcfile exception

write orcfile with compress CompressionKind.ZLIB or CompressionKind.SNAPPY occur exception:(CompressionKind.NONE is ok) Exception in thread "main" java.lang.IndexOutOfBoundsException at java.nio.ByteBuffer.wrap(ByteBuffer.java:352) at org.apache.hadoop.hive.ql.io.orc.InStream$Comp

Vectorizied execution on RCFile

Hi All, Vectorization with ORCFile provides amazing performance. Does vectorization work with RCFile as well? As per explain plan of Hive 0.13 (snapshot), it does not use vectorization with RCFile. Any pointers would be appreciated. -- ~Rajesh.B

Re: [DISCUSS] Proposed Changes to the Apache Hive Project Bylaws

More thoughts on the 24 hour wait : Changing the by-law to a 24 hr wait from first time patch is marked as available (or making this a guidance instead of by-law), is likely to nudge committers to review patches sooner. Right now, the clock starts ticking for a commit when another committer has +1'

ALTER INDEX factmemberperiod_idx ON factmemberperiod REBUILD failed with Can't set bits out of order with EWAHCompressedBitmap

Hi, BITMAP index created and dung REBUILD it failed with below error. CREATE INDEX factmemberperiod_idx ON TABLE factmemberperiod(dimmembereffectiveperiodid) AS 'BITMAP' WITH DEFERRED REBUILD; ALTER INDEX factmemberperiod_idx ON factmemberperiod REBUILD; Please help me on this. 2014-01-08 11:08:

Unit test failed because of statistics mismatch?

Hi all, I have problem running several unit tests related to statistics, e.g., alter_partition_coltype.q. The diff log is listed following: Running: diff -a /home/tedxu/src/hive.trunk/itests/qtest/../../itests/qtest/target/qfile-results/clientpositive/alter_partition_coltype.q.out /home/te

Re:

Alter table replace columns changes all columns and types. On Wed, Jan 8, 2014 at 5:35 AM, Kishore kumar wrote: > Hi Experts, > > Is there a way to change multiple column names and types ? > > -- > > *Kishore Kumar* > ITIM > >

Re: [ANNOUNCE] New Hive Committer - Vikram Dixit

Congrats sent from my mobile, , Please excuse typos On 7 Jan 2014 01:58, "Vaibhav Gumashta" wrote: > Congrats Vikram!!! > > > On Mon, Jan 6, 2014 at 11:24 AM, Jason Dere wrote: > >> Congrats Vikram! >> >> On Jan 6, 2014, at 11:10 AM, Prasanth Jayachandran < >> pjayachand...@hortonworks.com> wro

merge columns and count no of records

Hi, My requirement is to merge ( not concat ) two columns and count number of distinct records. I can use self-join on column A and column B and can count number of records. But looks not optimal way of doing. Is there any better way to do. Ex: Original table Column A COLUMN B 1 2 2 3 5

[no subject]

Hi Experts, Is there a way to change multiple column names and types ? -- *Kishore Kumar* ITIM