Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/DDL" page has been changed by JohnSichi. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=26&rev2=27 -------------------------------------------------- }}} This statement enables you to add user defined metadata to table SerDe object. The serde properties are passed to the table's SerDe when it is being initialized by Hive to serialize and deserialize data. So users can store any information required for their custom serde here. Refer to SerDe section of Users Guide for more information. + === Alter Table File Format and Organization === + + {{{ + ALTER TABLE table_name SET FILE FORMAT file_format + ALTER TABLE table_name CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name, ...)] INTO num_buckets BUCKETS] + }}} + + These statements change the table's physical storage properties. For available file_format options, see the section above on CREATE TABLE. + + NOTE: These commands will only modify Hive's metadata, and will NOT reorganize or reformat existing data. Users should make sure the actual data layout conforms with the metadata definition. + == Show/Describe Statements == These statements provide a way to query Hive metastore for existing data and metadata accessible to this Hive system.
