Viewing Table Information

View Columns

To view column information, select a table in HDFS and then click Column information. The following display shows an example:
Column Information
Sample Columns display
The following information about each column is provided:
Column Information
Field
Description
Column Name
Specifies the column name from the source table.
Label
Specifies the label for the data set column when the table was added to HDFS.
Type
Numeric or Character. Numeric variables are encoded as 1.
Offset
Specifies the starting position for the variable in the SASHDAT file.
Length
Specifies the storage used by the variable.
Format
Specifies the format associated with the variable.
Format length
Specifies the format length of the format that existed on the variable when it was added to HDFS. This value is zero if the variable did not have a format when it was added to HDFS.
Precision
Specifies the precision portion of the format for number formats.
Length (Formatted)
Specifies the length of the variable when formatting is applied.

View Row Count

To view the row count, select a table in HDFS and then click Row count.
Sample Row Count display
The following information is provided:
Row Count Information
Field
Description
Rows
Specifies the number of rows in the data.
Blocks
Specifies the number of HDFS blocks that are used to store the data.
Allocated
Specifies the number of bytes allocated to store the data. It is a multiple of the block size and the number of blocks. This value is smaller than the file size because it does not include the space needed for the SASHDAT file header.
Used
Specifies the number of bytes within the allocated blocks that are used for storing rows of data.
Utilization
Specifies the percentage of allocated space that is used for storing rows of data.