U shud create partitions by date and add partitions by alter table cmnd daily
U can then query data by date partition
Sent from my iPhone
On Aug 12, 2011, at 1:16 PM, Sam William wrote:
>
> I have a case where I want to dump data daily under
>
> /user/sampd/test/{date}.
>
>
> I thought
I have a case where I want to dump data daily under
/user/sampd/test/{date}.
I thought of making this an external table on Hive so that I can just keep
dumping data daily.
In my external table definition , I specified the location as
/user/sampd/test.
But when I try to run a qu
