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.

Working with multiple tables NiFi

Working with multiple tables NiFi

New Contributor

Hello,

i am trying to load data from multiple postgresql tables and load it into multiple hive tables. For that, i have followed procedure:

1. ListDatabaseTables

here, i mentioned connection details and database name.

2. routeonAttribure

here, i selected list of tables where i want to load from source into one variable called tables like, ${db.table.name:in("student","employee")}

3. Replace text

here, i am replacing content with sql query like:

SELECT * from ${db.table.fullname}

4.ExecuteSQL

here, fetch source table data.

5. putHive3Streaming

i am trying to load it into Hive like:

database name: default

table name : ${db.table.fullname}


Here my problem is, database name is different from source to destination and is there any way to get only table name without database name?
${db.table.fullname} from this expression i want only table name.


@Matt Burgess @Shu @Timothy Spann