btw, it seems that aws hive has a cool feature to recover all partitions
from subfolders by name of (col=value) under table folder in S3 without
explicitly specifying add partition for each ...
On Wed, Mar 23, 2011 at 3:03 PM, Michael Jiang wrote:
> solved.
>
> uh, thought that hive will by defa
solved.
uh, thought that hive will by default look into the table folder in hdfs and
match sub-folders with partition column names to recognize partitions
automatically. But realized partition addition has to be done explicitly by
giving partition name and location. So, by doing "alter table add p
Met a problem that data in an external table didn't get read by hive.
Here's how the table was created and data loaded.
- Created an external table w/ a partition, pointing to an existing location
in hdfs as follows :
create external table order_external (item string, quantity int) partitioned
b