Internal tables that are used by the ANALYZE command
Some tables are for internal use only and should not be queried.
The following tables are used for internal processing of analyze operations:
- SYSHADOOP.ANALYZE_TABLE
- This table is used by the ANALYZE command to transport encoded data from the worker nodes to the head node as part of analyze processing. It is a logical table that contains no data and cannot be queried.
- SYSHADOOP.METADATA_TABLE
- Stores the synopsis metadata for each partition of each table. The data is encoded internally and should not be queried.
- SYSHADOOP.SYNOPSIS_TABLE
- Stores the synopsis data for each column of each table. The data is encoded internally and should not be queried.