Vertica migrates data from other tables to a new table (insertinto statement usage instance)

# Example: migrate Weibo user data. Because the structure of the source table weiboFriend is not exactly the same as that of the target table weiboUser, the statement must not only strictly arrange the field order, but also use the default (for example) fill in the SQL statement for fields not found in the source table: insertintopublic. weiboUser (id, screen_name, location, descriptio

# Example: migrate Weibo user data. Because the structure of the source table weiboFriend is not exactly the same as that of the target table weiboUser, the statement must not only strictly arrange the field order, but also use the default (for example) SQL statement for filling fields not in the source table: insert into public. weiboUser (id, screen_name, location, descriptio

# Example: migrate Weibo user data.

Because the structure of the source table weiboFriend is not exactly the same as that of the target table weiboUser, the statement must not only strictly arrange the field order, but also use the default value (for example) fill fields not in the source table

Specific SQL statement:

Insert into public. weiboUser (id, screen_name, location, description, profile_image_url, blog_url, followers_count, statuses_count, created_at) (select uid, screen_name, '','', comment, '', followers_count, statuses_count, created from public. weiboFriend );

You can use it after slight modification according to the actual situation.