Modern Big Data Processing with Hadoop

Example 5 – incrementally loading data from MySQL table to HBase table

mysql -u sales -pmysql> use orders;

Insert a new customer and update the existing one:

mysql> Update customer set cust_city = 'Dublin', InsUpd_on = '1505095065' where cust_id = 4;Query OK, 1 row affected (0.00 sec)Rows matched: 1 Changed: 1 Warnings: 0mysql> INSERT into customer (cust_id,cust_name,cust_city,InsUpd_on) values (12,'Jane Turner','Glen Park',1505095075);Query OK, 1 row affected (0.00 sec)mysql> commit;Query OK, 0 rows affected (0.00 sec)mysql> select * from customer;+---------+--------------+--------------+------------+| cust_id | cust_name | cust_city | InsUpd_on |+---------+--------------+--------------+------------+| 1 | Sam James | Austin | 1505095030 ...