Support Questions
Find answers, ask questions, and share your expertise

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