Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-11922

UpdateDatabaseTable does not honor catalog/schema field

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.23.0
    • 2.0.0-M1, 1.24.0, 1.23.1
    • None
    • None

    Description

      When using updatedatabasetable, with catalog and schema set, the processor does not give any errors but creates the tables in the public schema disregarding the schema field set in the processor.

      Looking at the create ddl messages with debug enabled its not adding catalog.schema to the create if not exists statement. 

       

      Database type: postgres

      Attachments

        Issue Links

          Activity

            People

              mattyb149 Matt Burgess
              readl1 Lucas Read
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m