Created 07-23-2018 10:19 AM
Created 07-23-2018 11:43 AM
Try DASH DASH for your arguments:
Also, best advice always try and search your errors for solutions: "sqoop Unrecognized argument: -hcatalog", "sqoop Unrecognized argument: -table"
I like to search here, stack, or google....
Created 07-23-2018 12:07 PM
Created 07-23-2018 01:04 PM
Hi @Gayathri Devi
it seems you're trying to use
-hcatalog-table The argument value for this option is the HCatalog tablename. The presence of the --hcatalog-table option signifies that the import or export job is done using HCatalog tables, and it is a required option for HCatalog jobs.
But it looks like you have an accidental space between the -hcatalog and -table, resulting in a command syntax issue;
Created 07-23-2018 01:54 PM
Perhaps this works, i haven't tried this myself yet as I don't currently have any lab setup using mariaDB.
Edit; This may also be helpful: https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_syntax_3
I've noticed now the --export-dir is also required;
sqoop export \ --connect "jdbc:mariadb://localhost/example" \ --username mariadb \ --password mariadb \ --table hivetable \
Created 07-24-2018 04:09 PM
I've created a database in MariaDB and exported a hive table using sqoop on my lab setup.
This worked well for me;
[sqoop@jsneep-lab ~]$ sqoop export --connect jdbc:mysql://220.127.116.11/export --username mariadb --password mariadb --table exported --direct --export-dir /apps/hive/warehouse/drivers
Make sure you have /usr/share/java/mysql-connector-java.jar present on your system, this gave me trouble initially.