close
Warning:
Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_repos.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.
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 '密碼';
mysql> FLUSH PRIVILEGES;
- 執行 Sqoop 連到 MySQL 匯入資料的測試
jazz@master ~ $ sqoop import --connect jdbc:mysql://sql.3du.me/test --table mysql_data --username sqoop -P
Download in other formats: