External Table Statistics

The collection method and content of external table statistical information are basically the same as those of internal tables. For detailed information, please refer to the statistical information. After version 2.0.3, Hive tables support automatic and sampling collection.

Note

  1. Currently (2.0.3) only Hive external tables support automatic and sampling collection. HMS type of Iceberg and Hudi tables, as well as JDBC tables only support manual full collection. Other types of external tables do not support statistics collection yet.

  2. The automatic collection function is turned off by default for the external tables. You need to add attributes to turn it on when creating the external catalog, or enable it by setting the catalog attribute.

Property to turn on automatic collection when creating a catalog (default is false)

  1. 'enable.auto.analyze' = 'true'

Control automatic collection by modifying the Catalog attribute:

  1. ALTER CATALOG external_catalog SET PROPERTIES ('enable.auto.analyze'='true'); // enable auto collection
  2. ALTER CATALOG external_catalog SET PROPERTIES ('enable.auto.analyze'='false'); // disable auto collection