thanks Jorn. the idea is to test a big data high availability tool. by ingesting data to the target cluster. I have provisioned aan oracle schema for it so we can use Sqoop to get data into Hive.
someone suggested try using sqoop to ingest from a hive table in one cluster to the target cluster. this is not really a test is iut? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <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. On 21 February 2017 at 10:26, Jörn Franke <jornfra...@gmail.com> wrote: > 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 > <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. > > > >
