Mailing-List: contact common-commits-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: common-dev@hadoop.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
From: Apache Wiki <wikidiffs@apache.org>
To: Apache Wiki <wikidiffs@apache.org>
Date: Tue, 18 May 2010 21:28:10 -0000
Message-ID: <20100518212810.6729.62816@eos.apache.org>
Subject: 
 =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/LanguageManual/DDL=22_by_Pa?=
 =?utf-8?q?ulYang?=

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for ch=
ange notification.

The "Hive/LanguageManual/DDL" page has been changed by PaulYang.
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=3Ddiff&rev1=3D=
59&rev2=3D60

--------------------------------------------------

  ALTER TABLE table_name TOUCH PARTITION partition_spec;
  }}}
  =

- TOUCH reads the metadata, and writes it back. This has the effect of caus=
ing the pre/post execute hooks to fire. An example use case might be if you=
 have a hook that logs all the tables/partitions that were modified. Then, =
if you have an external script that alters the files on HDFS directly, the =
modification wouldn't be logged it was performed outside of Hive. The exter=
nal script could call TOUCH to fire the hook and mark the said table or par=
tition as being modified.
+ TOUCH reads the metadata, and writes it back. This has the effect of caus=
ing the pre/post execute hooks to fire. An example use case might be if you=
 have a hook that logs all the tables/partitions that were modified. Then, =
if you have an external script that alters the files on HDFS directly, the =
modification wouldn't be logged it was performed outside of Hive. The exter=
nal script could call TOUCH to fire the hook and mark the said table or par=
tition as modified.
  =

  Also, it may be useful later if we incorporate reliable last modified tim=
es. Then touch would update that time as well.
  =

- Note that TOUCH doesn't create a table or partition if it doesn't already=
 exist. (See [[Hive/LanguageManual/DDL/Create_Table|Create Table]])
+ Note that TOUCH doesn't create a table or partition if it doesn't already=
 exist. (See [[Hive/LanguageManual/DDL#Create.2BAC8-Drop_Table|Create Table=
]])
  =

  =3D=3D Create/Drop View =3D=3D
 =20