Few notes on the current (12/7/2010) implementation of Authorization in Howl.

warehouse dir is system-wide property and is configurable. It is considered as root data dir. It will have 777, so every one can create dirs (and thus table in Howl) in it.

Enumerating all the possible directory hierarchies in Howl. Everything in following paths is a dir except for part-00000 which is a file.

Unpartitioned table with no database

/user/hive/warehouse/mytable/part-00000

Partitioned table with no database

/user/hive/warehouse/mytable/p1/part-00000

Unpartitioned table with database

/user/hive/warehouse/mydatabase.db/mytable/part-00000

Partitioned table with database

/user/hive/warehouse/mydatabase.db/mytable/p1/part-00000