All Products
Search

This Product

    E-MapReduce:JindoTable access frequency collection

    Document Center

    E-MapReduce:JindoTable access frequency collection

    Last Updated:Jun 20, 2026

    You can use the JindoTable access frequency collection feature to identify hot and cold data. This helps reduce overall storage costs and improve the cache hit rate.

    Data collection

    JindoTable collects access records for Hive tables. The supported engines are Spark and Hive. The collected data is stored in the namespace of the SmartData service on the cluster.

    Access record collection is enabled by default. To disable it, see Disabling access record collection.

    Query access data

    JindoTable provides a command to query access frequency data.
    • Syntax
      jindo table -accessStat <-d [days]> <-n [topNums]>

      days and topNums are positive integers. If days is set to 1, the command queries all access records from 00:00 on the current day (local time) to the current time.

    • Function

      Returns the top N most frequently accessed tables or partitions within a specified time range.

    • Example: Query for the 20 most frequently accessed tables or partitions over the last seven days.
      jindo table -accessStat -d 7 -n 20

    For more information about JindoTable, see Use JindoTable.

    Disabling access record collection


    2. In the top navigation bar, select the region and resource group.
    3. Click the Clusters tab.
    4. On the Clusters page, click Details in the Actions column for your cluster.
    5. Modify the parameter values.
      Remove specific content from the following parameter values:
      • For the Hive service:
        1. In the left-side navigation pane, click Services > Hive.
        2. Click the Configure tab.
        3. Click the hive-site tab.
        4. Search for the hive.exec.post.hooks parameter and delete com.aliyun.emr.table.hive.HivePostHook from its value.
      • For the Spark service:
        1. In the left-side navigation pane, click Services > Spark.
        2. Click the Configure tab.
        3. Click the spark-defaults tab.
        4. Search for the spark.sql.queryExecutionListeners parameter and delete com.aliyun.emr.table.spark.SparkSQLQueryListener from its value.
    6. Save the configuration.
      1. In the upper-right corner, click Save.
      2. In the Confirm dialog box, enter a reason for the change and select Auto-update Configuration.
      3. Click OK.
    7. Restart the services.
      • For the Hive service:
        1. In the upper-right corner, choose Actions > Restart HiveServer2.
        2. In the Cluster Activities dialog box, configure the parameters.
        3. Click OK.
        4. ConfirmIn the confirmation dialog box, click OK.
      • For the Spark service:
        1. In the upper-right corner, choose Actions > Restart ThriftServer.
        2. In the Cluster Activities dialog box, configure the parameters.
        3. Click OK.
        4. ConfirmIn the confirmation dialog box, click OK.