Re: User doc for table properties

[Lefty Leverenz <le...@gmail.com>]

Review request:  Predefined TBLPROPERTIES are documented briefly in the Create
Table section
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable>
of the wiki -- see the notes immediately following the syntax.  I'd still
like to know if there are any other predefined table properties.

By the way, one of the properties mentioned in the previous message isn't a
table property, it's a SerDe property (hbase.table.default.storage.type
<https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration#HBaseIntegration-ColumnMapping>
).

-- Lefty


On Fri, Feb 14, 2014 at 6:45 PM, Lefty Leverenz <le...@gmail.com>
wrote:

> The user doc for TBLPROPERTIES needs work.  Currently the DDL wikidoc only
> says this:
>
> The TBLPROPERTIES clause allows you to tag the table definition with your
> own metadata key/value pairs.
>
> But some table properties have predefined keys and values.  HIVE-6406
> <https://issues.apache.org/jira/browse/HIVE-6406> will add "immutable" --
> how many others already exist?  Are they all listed in one file and
> distinguishable from internal parameters, or just scattered throughout the
> code?
>
> A quick search found orc.compress (example in HIVE-6083
> <https://issues.apache.org/jira/browse/HIVE-6083>) and hbase.table.name &
> hbase.table.default.storage.type (in TestPigHBaseStorageHandler.java).
>  OrcFile.java has several more listed after orc.compress (some mentioned in
> HIVE-4221 <https://issues.apache.org/jira/browse/HIVE-4221> comments).
>
> This might be a can of worms but the wiki should list all predefined keys
> and their possible values, with version information where needed.  I
> suggest a new subsection in the Create Table section of DDL:
>
>    - Language Manual – DDL – Create Table
>    <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/TruncateTable>
>
> Then particular table properties can be mentioned in their topic docs
> (like ORC) with links to the DDL doc.
>
> This message can be converted to a JIRA ticket later, but now I'm just
> looking for information.
>
> Hearts & flowers & chocolate to all on Valentine's Day. -- Lefty
>