question Re: Does Atlas track Sqoop Exports? in Archives of Support Questions (Read Only)

Does Atlas track Sqoop Exports?

George_Cancro — Fri, 10 Mar 2017 04:01:37 GMT

Was able to follow the sandbox tutorial and got sqoop import to be tracked in atlas. I then made a new hive table by joining two tables I sqooped in and then tried to sqoop export the new hive table back to MySQL. This worked fine in terms of transferring the new hive table into a new MySQL table.... but Atlas did not track the export!?! (I can see the import lineage and the hiveQL lineage...but no export lineage.)

So, does Altas support sqoop exports? or is their something else I have to configure. (using Atlas 0.7 and Hortonworks Sandbox 2.5)

Re: Does Atlas track Sqoop Exports?

namaheshwari — Fri, 10 Mar 2017 09:45:53 GMT

This might help you:

https://community.hortonworks.com/questions/66715/export-metadata-lineage-from-atlas.html

Re: Does Atlas track Sqoop Exports?

George_Cancro — Tue, 14 Mar 2017 21:34:26 GMT

Namit, looked at article you submitted. Are you saying that sqoop exports are not automatic like sqoop imports and therefore I should use the API or kafka topic to "work-around" this?

Re: Does Atlas track Sqoop Exports?

apathan — Tue, 14 Mar 2017 22:36:58 GMT

@George Cancro

Currently, atlas does not track the sqoop export, it supports only sqoop import. Please refer to the below documentation.

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_command-line-installation/content/configuring-atlas-sqoop-hook.html

Re: Does Atlas track Sqoop Exports?

namaheshwari — Tue, 14 Mar 2017 23:17:06 GMT

Yes, as Ayub mentioned below as of now Sqoop exports are not automatic.

Re: Does Atlas track Sqoop Exports?

George_Cancro — Tue, 14 Mar 2017 23:33:13 GMT

Thanks for quick reply, got it.