2013-12-21

Sqoop

• 準備 MySQL 資料庫

  mysql> use test;
  mysql> show tables;
  mysql> create table mysql_data(id int primary key, name varchar(50));
  mysql> show tables;
  

  mysql> show tables;
  +----------------+
  | Tables_in_test |
  +----------------+
  | mysql_data     |
  +----------------+
  1 row in set (0.01 sec)
  

  mysql> insert into mysql_data values (1, 'Hello');
  mysql> insert into mysql_data values (2, 'World');
  

  mysql> select * from mysql_data;
  +----+-------+
  | id | name  |
  +----+-------+
  |  1 | Hello |
  |  2 | World |
  +----+-------+
  2 rows in set (0.01 sec)
  

  mysql> GRANT SELECT,INSERT,UPDATE ON 資料庫名.* TO user@host IDENTIFIED BY '密碼';