Schema

A table schema contains information about the names and types of the columns of a table.

HDFS schema contains information about the names and types of the fields in an HDFS Avro or Parquet file.

Displaying Hive, Sqoop, and Impala Table Schema

Perform a metadata search for an entities of source type Hive and type Table.

In the list of results, click a result entry.

Click the Schema tab. The table schema displays.

Displaying Pig Table Schema

Perform a metadata search for entities of source type Pig. Do one of the following:

In the list of results, click a result entry of type Table.

In the list of results, click a result entry of type Operation_Execution.

Click the Tables tab. A list of links to tables involved in the operation displays.

Click a table link.

Click the Schema tab. The table schema displays.

Displaying HDFS Dataset Schema

If you ingest a Kite dataset into HDFS you can view the schema of the dataset. The
schema is represented as an entity of type Dataset and is implemented as an HDFS directory.

For Avro datasets, primitive types such as null, string, int, and so on, are not separate entities. For example, if you have a record type with a field A that's a record type and a field
B that's a string, the subfields of A become entities themselves, but B has no children. Another example would be if you had a union of null, string, map, array, and record types; the union has 3
children - the map, array, and record subtypes.

If this documentation includes code, including but not limited to, code examples, Cloudera makes this available to you under the terms of the Apache License, Version 2.0, including any required
notices. A copy of the Apache License Version 2.0 can be found here.