Prasad Chakka wrote:
You should create a daily partition table. So you just need to create a new partition which is automatic if you use ‘LOAD DATA... INTO TABLE ... PARTITION (ds=’2009-09-01’)’Just wanted to clarify, I still need to do LOAD DATA .. INTO TABLE .. PARTITION (day='hdfs/path/to/day') every night correct? I was confused since you said its automatic. This is actually great if it can work like this!Prasad
thanks again
