sqoop import --table tablename\ --connect jdbc:mysql:servername\dbname --username dbuser --password pw \ --fields-terminated-by "\t" -- hive-partition-key -- hive-import
/--hive-partition-key is Name of a hive field to partition are sharded on Thanks & Regards Chandrasekaran Technical Consultant Business Solutions Group Jardine OneSolution (2001) Pte Ltd Tel +65 6551 9608 | Mobile +65 8138 4761 | Email chiranchan...@jos.com.sg<mailto:chiranchan...@jos.com.sg> 55, Ubi Avenue 1 #03-15,Singapore 408935 [Description: 150828 - JOS email signature_grey-02]<jos.com> From: Ted Yu [mailto:yuzhih...@gmail.com] Sent: Tuesday, 2 February, 2016 10:38 PM To: Arun Pandian Cc: user@hadoop.apache.org Subject: Re: Sqoop import Mysql to hive import Partitions The question is better suited for sqoop mailing list. Meanwhile, you can search for past threads / JIRAs on this subject. e.g. http://search-hadoop.com/m/C63T91ojE6B14UByZ&subj=sqoop+1+4+4+hive+import+error On Feb 2, 2016, at 5:28 AM, Arun Pandian <arunpandiansum...@gmail.com<mailto:arunpandiansum...@gmail.com>> wrote: How to create sqoop import mysql to hive partition , this is my code sqoop import --connect jdbc:mysql://localhost/arun --table account --username root --password hadoop -m 1 --hive-partition-key "name" --hive-partition-value "arun" --hive-database company --create-hive-table --hive-table account5 --target-dir /user/sqooptest21 mysql database is arun, table is account select * from account; +----+-------+------+------------+---------+ | id | name | age | joindate | namess | +----+-------+------+------------+---------+ | 1 | Arun | 23 | 29-01-2016 | super | | 2 | Mani | 22 | 30-01-2016 | superb | | 3 | Sana | 25 | 20-01-2016 | superbb | | 4 | Vicky | 24 | 02-02-2016 | supervb | | 5 | Vis | 23 | 30-05-2016 | super | +----+-------+------+------------+---------+ i need clear explanation for sqoop import mysql to hive Thanks & Regards Arunpandian.l Associate Developer ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ [http://img.photobucket.com/albums/v232/RiZZo66/WLAchieverAward2014BampW.jpg] For general enquiries, please contact us at JOS Enquiry Email: enqu...@jos.com.sg<mailto:enqu...@jos.com.sg> Hotline: (+65) 6551 9611 For JOS Support, please contact us at JOS Services Email: servi...@jos.com.sg<mailto:servi...@jos.com.sg> Hotline: (+65) 6484 2302 A member of the Jardine Matheson Group, Jardine OneSolution is one of Asia’s leading providers of integrated IT services and solutions with offices in Singapore, Malaysia, Hong Kong and China. Find out more about JOS at www.jos.com<http://www.jos.com> Confidentiality Notice and Disclaimer: This email (including any attachment to it) is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message (including any attachment to it). Thank you. ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. Confidentiality Notice and Disclaimer: This email (including any attachment to it) is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message (including any attachment to it). Thank you. ______________________________________________________________________