Rename Hive partition

2011-06-02 Thread Jon Bender
Hey all, Just wondering what the best way is to rename specific Hive table partitions. Is there some HiveQL command for this, or will I need to insert into new partitions to reflect the new naming convention? Cheers, Jon

RE: Logging MySQL queries

2011-06-02 Thread Steven Wong
It's my bad. I was editing hive/conf/hive-log4j.properties, but turns out hive is actually a symlink to the 0.5 tree, not 0.7. So, the properties have an effect in 0.7 for me now. From: Steven Wong [mailto:sw...@netflix.com] Sent: Tuesday, May 24, 2011 5:01 PM To: user@hive.apache.org Subject:

Re: Rename Hive partition

2011-06-02 Thread Eric Djatsa
Hi Jon since a partition appears as a column ( for example with *desc table_name* ) you could try renaming the partition as if it was a column as explained in the wiki : ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type [COMMENT col_comment] [FIRST|AFTER column_name] I

RE: Dose block size determine the number of map task

2011-06-02 Thread Steven Wong
I always set it, so am not sure what the behavior is if it is not set. You should probably always set it. See the comments/code in CombineFileInputFormat.java for detail. From: Junxian Yan [mailto:junxian@gmail.com] Sent: Wednesday, June 01, 2011 7:54 PM To: Steven Wong;

RE: Hive logging concurrency

2011-06-02 Thread Steven Wong
After researching on the web, the lost log lines is apparently an issue with DailyRollingFileAppender that may have been fixed in 1.2.16 (see https://issues.apache.org/bugzilla/show_bug.cgi?id=43374). On the other hand, DailyRollingFileAppender's documentation recommends using