mysql-to-hadoop-sample.sql

CREATE TABLE `retail_db`.`retail_master` (
`transaction_id` INT NOT NULL AUTO_INCREMENT,
`customer_name` VARCHAR(45) NOT NULL,
`bought_products` VARCHAR(255) NOT NULL,
`amount` INT NULL,
PRIMARY KEY (`transaction_id`));
INSERT INTO `retail_db`.`retail_master` (`customer_name`, `bought_products`, `amount`) VALUES ('prashantkhunt', 'laptop,headphones,watch,mobile', '70000');
INSERT INTO `retail_db`.`retail_master` (`customer_name`, `bought_products`, `amount`) VALUES ('harsh savani', 'book,sunglasses,tshirt,pen', '85000');
INSERT INTO `retail_db`.`retail_master` (`customer_name`, `bought_products`, `amount`) VALUES ('chiragloliyana', 'laptop,headphones,watch', '45000');
INSERT INTO `retail_db`.`retail_master` (`customer_name`, `bought_products`, `amount`) VALUES ('vivekpatel', 'mobile,book,tshirt', '30000');