Partitioned tables

2013-08-27 Thread Babe Ruth
I created an external table and have been inserting data into it for some time. I would now like to add a partitions to the table, is this possible? thanks,George

anyone ever user filecrush?

2013-07-25 Thread Babe Ruth
I am using the --clone option correctly? hadoop jar filecrush.jar crush.Crush --clone --threshold 1 --compress org.apache.hadoop.io.compress.GzipCodec --input-format org.apache.hadoop.mapred.TextInputFormat --output-format org.apache.hadoop.mapred.SequenceFileOutputFormat --info --verbose /user

/tmp/hive-username folder in HDFS

2013-07-16 Thread Babe Ruth
Hi Everyone, Does a setting exist to autotrim the /tmp/hive-username folder? I have several TBs of space from old jobs and it is a pain to remember to remove them every few weeks. Thanks,George

Can a bucket be added to a partition?

2013-04-30 Thread Babe Ruth
Hello, I have a table that is already created and is partitioned dynamically by day. i would like all future partitions to be bucketed on two columns. Can I add a bucket to a partitions in an already existing table? Thanks,George

Setting to make all tables external by default

2013-03-27 Thread Babe Ruth
Hello, Is there a setting where all tables created will default to external? I know this isn't ideal long term but I am setting up the environment and would rather start with all tables being external then switch them to managed if necessary. Thanks, George

Setting to make all tables external by default

2013-03-21 Thread Babe Ruth
From: Babe Ruth Sent: 21 Mar 2013 19:06:59 GMT To: user@hive.apache.org Subject: Re: Important information required about Hive metastore connections Hello, Is there a setting where all tables created will default to external? I know this isn't ideal long term but I am setting up the envir

Re: Important information required about Hive metastore connections

2013-03-21 Thread Babe Ruth
Hello, Is there a setting where all tables created will default to external? I know this isn't ideal long term but I am setting up the environment and would rather start with all tables being external then switch them to manager if necessary. Thanks, George -Original Message- From: A

RE: Determining DateDiff By Minutes in Hive

2012-12-05 Thread Babe Ruth
to day light savings time. If that's important, it will be best to convert precise timestamps to UTC and then subtract them. Mark On Wed, Dec 5, 2012 at 12:33 PM, Babe Ruth wrote: Hello All, I would like to find the total amount of minutes between two dates. Not sure if this is pos

Determining DateDiff By Minutes in Hive

2012-12-05 Thread Babe Ruth
Hello All, I would like to find the total amount of minutes between two dates. Not sure if this is possible in hive. Any help would be great. Thanks,George

RE: EXTERNAL: setting HIVE table property to READ ONLY

2012-10-31 Thread Babe Ruth
through DDL options? Thanks, Ranjith From: Babe Ruth [mailto:gtevelde-h...@hotmail.com] Sent: Wednesday, October 24, 2012 09:49 PM To: user@hive.apache.org Subject: EXTERNAL: setting HIVE table property to READ ONLY Hello everyone, Is there a way to set a table property to

setting HIVE table property to READ ONLY

2012-10-24 Thread Babe Ruth
Hello everyone, Is there a way to set a table property to read only? I am using hive 0.8.1 Thanks,G

RE: Changing table types from managed to external

2012-08-07 Thread Babe Ruth
rdecide.com On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth wrote: Hello, I created a managed table in HIVE when i intended for it to be external, is it possible for me to change the table back to external? OR do I have to copy the data to a new directory, drop the table, then copy it back? Thanks,George

Changing table types from managed to external

2012-08-06 Thread Babe Ruth
Hello, I created a managed table in HIVE when i intended for it to be external, is it possible for me to change the table back to external? OR do I have to copy the data to a new directory, drop the table, then copy it back? Thanks,George