Is there a way i can practise sqoop in apache ambari as like wo do with pig and Hive

[#1]

Hi,

Is there a way i can practice sqoop in apache ambari as like pig and Hive or sandbox is the only way i can use sqoop command to import and export data from and to RDBMS.

Can anyone please share the link to Sqoop hands on with HDP.

Thanks

Ravikumar.

[#2 · Accepted solution]

Sqoop is really a command line utility, so the best way to kick off sqoop jobs is very much on the console at the moment. You might also consider using Apache NiFi (HDF) for getting data out of relational sources if your use cases are reasonably simple (GBs rather than TBs).

[#3]

@Simon Elliston Ball Thank you!!!

[#4]

@Ravikumar Kumashi

For now, Sqoop can be run only from the HDP machine. Refer to below Tutorial link:

http://www.tutorialspoint.com/sqoop/

[#5]

@Sindhu Thank you!!!

[#6]

@Sindhu

When i run sqoop help command in sandbox i get warning saying accumulo does not exist.

Does the above error means my sqoop import command will fail ? how do i overcome the above error.

[#7]

@Ravikumar Kumashi

That is the warning wrt ACCUMULO setting and would not affect the Sqoop run. This warning can be ignored.

[#8]

@Sindhu

I tried using sqoop import command and it gives me the below error.