Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Need to get Table schema from database using nifi processor
Labels:
- Labels:
-
Apache NiFi
Explorer
Created 11-01-2017 08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The problem is need to fetch the table schema for a table. Then after fetching the schema, I need to build the select query from the schema.This is because, it should work any table with any number of columns.
The idea is to build a generic processor to extract records from a table, irrespective of table schema. Instead of desiging different workflows for different table.
10 REPLIES 10
Guru
Created 11-02-2017 02:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can add limit 1 to your SQL query with ExecuteSQL to get only one row for schema inference

- « Previous
-
- 1
- 2
- Next »