To display information and usage instructions related to export command sqoop help export Command to connect to mysql mysql -u retail_user -h ms.itversity.com -p Command to connect to a database USE retail_export; Select statement on table SELECT count(1) FROM training_daily_revenue; Command to view records in table SELECT * FROM training_daily_revenue LIMIT 10; Command to delete …
To display information and usage instructions related to export command sqoop help export Command to launch hive connecting to the specified database hive –database training_sqoop_retail; Command to get list of tables SHOW tables; Command to create table CREATE TABLE daily_revenue01 AS SELECT * FROM daily_revenue; Command to get meta-data on table DESCRIBE FORMATTED daily_revenue01; Command …
Command to connect to mysql mysql -u retail_user -h ms.itversity.com -p Command to connect to a database USE retail_export; Command to get meta-data on table DESCRIBE training_daily_revenue; Command to truncate the table TRUNCATE TABLE training_daily_revenue; Command to alter table ALTER TABLE ADD description VARCHAR(200); Command to export data sqoop export –connect jdbc:mysql://ms.itversity.com:3306/retail_export –username retail_user –password …
Command to merge data using update-mode sqoop export –connect jdbc:mysql://ms.itversity.com:3306/retail_export –username retail_user –password itversity –export-dir /apps/hive/warehouse/training_sqoop_retail.db/daily_revenue –table training_daily_revenue –update-key order_date –update-mode allowinsert Command to connect to mysql mysql -u retail_user -h ms.itversity.com -p Command to connect to a database USE retail_export; To validate table SELECT count(1) FROM training_daily_revenue; SELECT * FROM training_daily_revenue WHERE order_date LIKE …
217.Sqoop Export – Using update-mode – allow-insert Read More »
Command to list the jobs already created Sqoop job –-list Command to get details related to the job sqoop job –show import_orders Command to get list of files in hdfs directory hadoop fs -ls /user/training/sqoop_import/retail_db/orders Command to run the job sqoop job –exec import_orders To display information and usage instructions related to job command sqoop …
