Re: Can't drop table

2011-01-17 Thread Edward Capriolo
You are the first person I have heard of using postgres. I commend you for not succumbing to the social pressure and just installing mysql. However I would advice succumbing to the social pressure and using either derby or mysql. The reason I say this is because jpox "has support" for a number of

Re: Can't drop table

2011-01-17 Thread Jamie Cockrill
Hi all, We use postgres as a metastore for Hive and haven't come across any problems. The postgres driver jar is: postgresql-8.4.701-jdbc.jar. We use the version of hive that comes out of Cloudera's CDH3b2, which I believe is some variant of Hive 0.5.0. Java: HotSpot 1.6.0_20 OS: Ubuntu Lucid (10

Re: Can't drop table

2011-01-17 Thread 김영우
Hi All, I'm using PostgreSQL for Hive metastore in production. As far as I know MySQL has limitations on constraints in unicode environments. I remember Hive could not create metastore schema automatically with MySQL, Innodb and UTF-8 encoding environment. so I switched PostgreSQL for metastore.

RE: ‏Sequence file- custom serdes - question

2011-01-17 Thread Guy Doulberg
Hey again, I thought it will be easy to combine the key and the value, however I ran into difficulties, I wonder if someone has make a generic FileInputFormat that prepend the key to the value? Anyhow here is the code I am trying to write: I have a class that extends the SequenceFileInputForma

Re: ‏Sequence file- custom serdes - question

2011-01-17 Thread Edward Capriolo
2011/1/17 Guy Doulberg : > Hey again, > > I thought it will be easy to combine the key and the value, however I ran > into difficulties, I wonder if someone has make a generic FileInputFormat > that prepend the key to the value? > > Anyhow here is the code I am trying to write: > > I have a class

RE: ‏Sequence file- custom serdes - question

2011-01-17 Thread Guy Doulberg
Thanks Eduard, But I don't understand your suggestion, How do I convert the custom object that I have to text? An where? In the createValue method? Thanks again -Original Message- From: Edward Capriolo [mailto:edlinuxg...@gmail.com] Sent: Monday, January 17, 2011 4:13 PM To: user@hi

Re: ‏Sequence file- custom serdes - question

2011-01-17 Thread Edward Capriolo
On Mon, Jan 17, 2011 at 9:20 AM, Guy Doulberg wrote: > Thanks Eduard, > > But I don't understand your suggestion, > > How do I convert the custom object that I have to text? > > An where? > In the createValue method? > > Thanks again > > -Original Message- > From: Edward Capriolo [mailto:e

RE: ‏Sequence file- custom serdes - question

2011-01-17 Thread Guy Doulberg
Thanks, I eventually did it in the following way: If next (the method of RecordReader) returns true, than it has now the current key and the current value. I made my value implement the interface: ValueHoldsKey K getKey(); Void setKey(K k); Than I changed the wrapper to the following: publi

On bucketing : fewer files than buckets.

2011-01-17 Thread Ajo Fod
Hello, In the documentation I read that as many files are created in each partition as there are buckets. In the following sample script, I created 32 buckets, but only find 2 files in each partition directory. Am I missing something? In this sample script, I'm trying to load a tab separated fil