Popularize Tables

Via SQL

1. Hive

   https://stackoverflow.com/questions/18049444/hive-select-into

   create table people1990 as select * from people where dob_year=1990 

2. MySQL

   https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html

   INSERT INTO tbl_temp2 (fld_id)
      SELECT tbl_temp1.fld_order_id
      FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;