Popularize Tables

Jump to bottom Edit New page

Yi Wang edited this page Oct 19, 2018 · 6 revisions

Hive

SQL

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

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

Python

https://dev.mysql.com/doc/connector-python/en/connector-python-examples.html

MySQL

SQL

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;

Python

https://dzone.com/articles/write-csv-data-hive-and-python