Naming Requirements for Schemas, Tables, and Columns

Follow these requirements to name schemas, tables, and columns:
  • Use alphanumeric characters in the names of schemas, tables, and columns.
    • Use underscore characters, but do not use an underscore character as the leading character in the name.
    • Do not use double-byte character sets in names.
    • Do not use Hive quoted identifiers ( ) in column names.
  • Limit the length of the names of schemas, tables, and columns to 32 characters. This limit is required in the following directives and transformations:
    • Profile directive
    • Transpose directive
    • Summarize Rows transformation (a task in multiple directives)