Help Center/ Log Tank Service/ FAQs/ Log Transfer/ What Do I Do If I Cannot Find a New Partition in a DLI Table After Logs Are Transferred to DLI?
Updated on 2025-02-08 GMT+08:00
View PDF
Share

What Do I Do If I Cannot Find a New Partition in a DLI Table After Logs Are Transferred to DLI?

If a new partition cannot be found in a DLI table after logs are transferred to DLI, perform the following operations:

Method 1: Update the Table Partition Information of the Metabase

  1. Log in to the DLI console.
  2. In the navigation pane, choose Job Management > SQL Jobs.
  3. Click Edit in the Operation column of the corresponding queue. On the details page that is displayed, enter the MSCK REPAIR TABLE table_name command in the text box. table_name indicates the name of the partitioned table. For example, update the partitioned table named lts_qpg_dli.
  4. Click Execute and wait until the update is complete.

    For more information about DLI, see SQL Job Management.

Method 2: Configuring a Scheduled Task

  1. Log in to the DataArts Studio console and ensure that a SQL instance has been created.
  2. Locate an instance and click Access.
  3. On the Dashboard tab page, click DataArts Factory in the lower part of the workspace to access the details page.

  4. Click Create Job, set parameters as prompted, and click OK. For details, see Creating a Job.

  5. On the page of the created job, drag the DLI SQL icon to the blank area.

  6. Click the DLI SQL icon in the blank area. On the DLI SQL page that is displayed, enter the SQL statement MSCK REPAIR TABLE table_name. table_name indicates the name of the partitioned table. Set Database Name and Queue Name to the database and queue created when you configure transfer to DLI.

    For more information about the DLI SQL properties, see Developing a SQL Script.

  7. After setting the DLI SQL properties, click the blank area and click Scheduling Setup to set the time of performing the scheduled operations. For details, see Setting Up Scheduling for a Job.

  8. After the setting is complete, click Submit and then click to trigger the job execution scheduling.
Parent topic: Log Transfer