Hallo, I have not tried it, but sqoop supports any jdbc driver. However, since the SQL syntax is not necessarily standardized you may face issues or performance problems. Hive itself has a nice import and export tool that supports also the metadata import/export. It can be orchestrated from Oozie and/or Falcon.
Best regards > On 21 Feb 2017, at 11:16, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > > Hi, > > I have not tried this but someone mentioned that it is possible to use Sqoop > to get data from one Impala/Hive table in one cluster to another? > > The clusters are in different zones. This is to test the cluster. Has anyone > done such a thing? > > Thanks > > > > Dr Mich Talebzadeh > > LinkedIn > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > > http://talebzadehmich.wordpress.com > > Disclaimer: Use it at your own risk. Any and all responsibility for any loss, > damage or destruction of data or any other property which may arise from > relying on this email's technical content is explicitly disclaimed. The > author will in no case be liable for any monetary damages arising from such > loss, damage or destruction. >
