question Re: Is there a way i can practise sqoop in apache ambari as like wo do with pig and Hive in Support Questions

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

ravikumashi — Tue, 26 Jul 2016 20:08:38 GMT

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.

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

sball — Tue, 26 Jul 2016 20:16:46 GMT

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).

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

ssubhas — Tue, 26 Jul 2016 20:19:48 GMT

@Ravikumar Kumashi

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

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

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

ravikumashi — Tue, 26 Jul 2016 20:26:08 GMT

@Simon Elliston Ball Thank you!!!

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

ravikumashi — Tue, 26 Jul 2016 20:26:49 GMT

@Sindhu Thank you!!!

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

ravikumashi — Sun, 18 Aug 2019 13:12:26 GMT

@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.

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

ssubhas — Wed, 27 Jul 2016 11:45:13 GMT

@Ravikumar Kumashi

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

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

ravikumashi — Sun, 18 Aug 2019 13:12:18 GMT

@Sindhu

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