Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Make information_schema.routine_load_jobs schema consistent with show routine load #55118

Open
Tracked by #1742
wyb opened this issue Jan 16, 2025 · 0 comments
Open
Tracked by #1742
Labels
good first issue Good for newcomers type/enhancement Make an enhancement to StarRocks

Comments

@wyb
Copy link
Contributor

wyb commented Jan 16, 2025

Enhancement

Some columns are not in the system table, such as TimestampProgress, LatestSourcePosition

mysql> select * from information_schema.routine_load_jobs where id = 3175854\G
*************************** 1. row ***************************
                      ID: 3175854
                    NAME: label0
             CREATE_TIME: 2025-01-14 12:33:38
              PAUSE_TIME: NULL
                END_TIME: NULL
                 DB_NAME: kafka_test
              TABLE_NAME: largeint_test
                   STATE: RUNNING
        DATA_SOURCE_TYPE: KAFKA
        CURRENT_TASK_NUM: 1
          JOB_PROPERTIES: {}
  DATA_SOURCE_PROPERTIES: {}
       CUSTOM_PROPERTIES: {"group.id":"label0_67d7accf-4fbb-45f4-bbb1-da8e3e20d1e0"}
              STATISTICS: {}
                PROGRESS: {"0":"1"}
REASONS_OF_STATE_CHANGED:
          ERROR_LOG_URLS: NULL
            TRACKING_SQL: NULL
               OTHER_MSG: 
1 row in set (0.11 sec)

mysql> show routine load\G
*************************** 1. row ***************************
                  Id: 3175854
                Name: label0
          CreateTime: 2025-01-14 12:33:38
           PauseTime: NULL
             EndTime: NULL
              DbName: kafka_test
           TableName: largeint_test
               State: RUNNING
      DataSourceType: KAFKA
      CurrentTaskNum: 1
       JobProperties: {}
DataSourceProperties: {}
    CustomProperties: {"group.id":"label0_67d7accf-4fbb-45f4-bbb1-da8e3e20d1e0"}
           Statistic: {}
            Progress: {"0":"1"}
   TimestampProgress: {}
ReasonOfStateChanged:
        ErrorLogUrls:
         TrackingSQL:
            OtherMsg: 
LatestSourcePosition: {"0":"2"}
1 row in set (0.00 sec)
@wyb wyb added the type/enhancement Make an enhancement to StarRocks label Jan 16, 2025
@wyb wyb changed the title Make information_schema.routine_load_jobs columns consistent with show routine load Make information_schema.routine_load_jobs schema consistent with show routine load Jan 16, 2025
@wyb wyb mentioned this issue Aug 5, 2024
26 tasks
@wyb wyb added the good first issue Good for newcomers label Jan 16, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Good for newcomers type/enhancement Make an enhancement to StarRocks
Projects
None yet
Development

No branches or pull requests

1 participant