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 leftylever...@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