Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    UNSOLVED mysql→kudu结构迁移失败

    问答区
    mysql→kudu结构迁移失败
    2
    6
    138
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • X
      Xeon last edited by

      社区版2.2.0.4
      源库:
      8cfce567-9d1a-4d15-bdde-f9ba16257f77-image.png
      目标库:
      769870ee-50e2-4ff8-aa40-9884f5bc23be-image.png

      在创建任务的时候,一旦选择目标表为自己提前创的表,就无法显示可选字段,如下:
      c0b287df-4d54-4578-b2fc-148a9b8d6ea5-image.png
      或者
      d5bf1e15-934c-41b3-a2e0-3e5674b95d5a-image.png

      然而就算把目标表改为默认的待创建表,创建任务后还会在结构迁移时报错:
      97199945-8896-4fc0-9aaa-738ed50e91e8-image.png

      1 Reply Last reply Reply Quote 0
      • X
        Xeon @Xeon last edited by

        今天发现如果目标端选择一个与源端结构相同的表,即使没有显示可选字段,依然能够点击下一步,且字段可以一一对应,但是会提醒此表没有唯一键,而且又会报新的错误:primary key column <主键字段> is not set
        2e4b5cc8-f970-48ea-bdf8-d8902277c682-image.png
        24545391-8272-4fa7-9f21-35d8fc2c7c8b-image.png

        1 Reply Last reply Reply Quote 0
        • X
          Xeon @zycgit last edited by

          @zycgit
          mysql源表:
          CREATE TABLE test_table (
          id int(5) NOT NULL,
          name varchar(10) DEFAULT NULL,
          age int(3) DEFAULT NULL,
          PRIMARY KEY (id)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8

          目标kudu表:
          CREATE TABLE test_table (
          id BIGINT,name STRING,age BIGINT,PRIMARY KEY (id)
          ) PARTITION BY HASH (id) PARTITIONS 16 STORED AS KUDU;

          1 Reply Last reply Reply Quote 0
          • zycgit
            zycgit @Xeon last edited by

            @xeon 源端表结构可以发一下么,我们模拟一下

            X 1 Reply Last reply Reply Quote 0
            • X
              Xeon @zycgit last edited by

              @zycgit 这个有试过,不管有没有同名表都会出现一样的情况

              zycgit X 2 Replies Last reply Reply Quote 0
              • zycgit
                zycgit last edited by

                对端 Kudu 上是否已经有同名表了?

                X 1 Reply Last reply Reply Quote 0
                • 1 / 1
                • First post
                  Last post
                Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2