Different partitions can have different paths - A partition's path need not be a sub-direcotry of the table's path. In facebook, we use this regularly, specially for external tables.
So, it simplifies things if the full path is stored for the partition in the metastore. Thanks, -namit On 2/3/11 2:22 AM, "Chinna" <chinna...@huawei.com> wrote: >Hi all, > > While creating hive table using create table command, the code flow will >also insert the HDFS location in SDS table present in Derby > >For Example on executing:- >create table sample(rate int) stored as textfile; > > >The SDS table (meta table present in Derby) contains following entry >corresponding to Hive table sample like >http://{IP}:9001/user/hive/warehouse/sample > >say 9001 is the port configured, >and {HDFS-URL}/user/hive/warehouse is the warehouse configured. > >Now here I'm interested to know the intention of maintaining full path of >the HDFS location in SDS Table, say why not a relative path, anyhow Hive >is >capable of constructing full HDFS URL Path. > >Any design inputs on it, will surely help. > >Thanks, >Chinna Rao Lalam > > > > > > >************************************************************************** >** >*********** > > This e-mail and attachments contain confidential information >from HUAWEI, which is intended only for the person or entity whose address >is listed above. Any use of the information contained herein in any way >(including, but not limited to, total or partial disclosure, reproduction, >or dissemination) by persons other than the intended recipient's) is >prohibited. If you receive this e-mail in error, please notify the sender >by >phone or email immediately and delete it! > >
