Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

sqooping multiple tables that ends with a certain character from different schema in oracle

sqooping multiple tables that ends with a certain character from different schema in oracle

New Contributor

hi experts out there - 

 

I would like to sqoop import multiple tables from oracle tables but only tables that ends with certan strings from different schemas. For example, our oracle structure is

pod1.user,

pod2.user,

pod3.user,

podxx.user... and we keep adding podxx time to time. Instead of updating script whenever new pod is added i would like to see whether there is any way to import these user tables from different schema using regex. Can anyone advise whether this is doable?

 

Thanks in advance,