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=38&rev2=39 -------------------------------------------------- ## page was renamed from Hive/LanguageManual/LanguageManual/DDL <<TableOfContents>> - == Create/Drop Table and Partition Statements == + == Create/Drop Table == === Create Table === {{{ CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name @@ -165, +165 @@ == Alter Table Statements == Alter table statements enable you to change the structure of an existing table. You can add columns/partitions, change serde, add table and serde properties, or rename the table itself. - === Add Partition === + === Add Partitions === {{{ ALTER TABLE table_name ADD partition_spec [ LOCATION 'location1' ] partition_spec [ LOCATION 'location2' ] ... @@ -254, +254 @@ 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. + == Create/Drop Function == + === Create Function === {{{ CREATE TEMPORARY FUNCTION function_name AS class_name
