Prescripts

Prescripts are fired on a Hive connection, before firing a select from or insert into a Hive table. While defining a Prescript, note the following:

• Prescript should mandatorily begin with the keyword "SET".
• Multiple Prescripts should be semi-colon separated.
• Prescripts are validated for SQL Injection. The following key words are blacklisted:

  "DROP","TRUNCATE","ALTER","DELETE","INSERT","UPDATE","CREATE", "SELECT"

  All validations applicable in the UI are checked on execution also. If a prescript fails any of the validations or if there is an error in firing the pre-script, the load operation is exited.

  Note:

  For H2T, the Prescript is fired on the source.