Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1255

PDI CS Bulk Load plugin can't work with variable defined in kettle.properties file

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.1.4
    • None
    • None
    • 2018-05, 2018-06

    Description

      CS Bulk Loader can't work with variable for ColumnStore XML file path defined in the kettle.properties.

      1. Open PDI spoon tool and open test.kjb
      2. Open export-to-mariadb transformation object.
      3. In Spoon main menu select Edit > Edit the kettle.properties file
      4. Click right mouse button and select one of Insert options.
      5. In new empty line add Variable name = DATABASE_CS_XML and Value = /home/pentaho/Downloads/test-job/Columnstore.xml (this is only an example for correct path to the file)
      6. In export-to-mariadb transformation > MariaDB ColumnStore Bulk Loader component > Settings change ColumnStore XML field to use DATABASE_CS_XML variable
      7. Save all changes
      8. Run the test.kjb

      Result:
      Job fails with error

      2018/03/09 16:25:11 - MariaDB ColumnStore Bulk Loader.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : The ColumnStoreDriver couldn't be instantiated.
      2018/03/09 16:25:11 - MariaDB ColumnStore Bulk Loader.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Error initializing step [MariaDB ColumnStore Bulk Loader]
      
      

      If user tries to edit the bulk loader component again the following message is displayed:
      Please select a valid Columnstore.xml file to proceed.

      Expected:
      Job finishes successfully if variable for columstore.xml file path is used.

      Attachments

        Activity

          People

            elena.kotsinova Elena Kotsinova (Inactive)
            elena.kotsinova Elena Kotsinova (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.