[MCOL-1554] PDI CS not work in the Pentaho Sever repository Created: 2018-07-11  Updated: 2023-10-26  Resolved: 2018-11-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.5
Fix Version/s: 1.1.7, 1.2.1

Type: Bug Priority: Blocker
Reporter: Nicola Assignee: Elena Kotsinova (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Pentaho Server : Single VM on vmware.
MariaDB Columnstore 1.1.5 Architecture (under Vmware) :
2 Um and 3 Pm with Oracle Linux 7.5.


 Description   

Hi,
I try to save the pdi transformation on the pentaho server repository but failed and in the pentaho server logs not founding errors.
The output error is : Please contact your administrator for assistance.
Outside the repository (under filesystem), the transformation is saved correctly.
I use the Pentaho Server 8.1 CE and PDI CE (kettle) 8.1.
Thanks,
Regards.
Nicola Battista

 Comments   
Comment by Nicola [ 2018-07-25 ]

Hi,
Are there news?

Thanks,
Regards.

Comment by Nicola [ 2018-09-19 ]

Hi,
Are there news?

Thanks,
Regards.

Comment by Nicola [ 2018-09-20 ]

Hi,
I've opened a ticket jira at Pentaho:
https://jira.pentaho.com/browse/PDI-17599?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel

This is the answer :
jbleuel Jens Bleuel made changes - Yesterday
Closing as Won't fix, this is an issue of the MariaDB developed ColumnStore - Pentaho Data Integration - Data Adapter:
https://mariadb.com/kb/en/library/columnstore-streaming-data-adapters/#columnstore-pentaho-data-integration-data-adapter

Looks like they have issues with (or have not implemented) the saveRep() loadRep() methods, see "Serialize Step Settings":
https://help.pentaho.com/Documentation/8.1/Developer_Center/PDI/Extend/000

Thanks Nicola for reporting this, you might update the MCOL-1554 case with the above information. Thank you!

Comment by Nicola [ 2018-09-27 ]

Hi,
Are there news?

Thanks,
Regards.

Comment by Jens Röwekamp (Inactive) [ 2018-10-12 ]

Hi,

Nicola sorry for the delay, there is a lot going on here.
Thank you for all your effort and contact with Pentaho.

I'll try to patch it in for our ColumnStore 1.2.2 GA release.

Comment by Nicola [ 2018-10-15 ]

Hi Jens,
Thank you very much for the support.
We really need these features to develop our ETLs and as a result the patch will be released first and we could use MariaDB Columnstore as the Data Warehouse / Bigdata system for production.

Best Regards.
Nicola Battista

Comment by Jens Röwekamp (Inactive) [ 2018-10-19 ]

Updated the routines to save and load from Pentaho server repository.

Tested the develop branch with PDI 8.1 and 7 and Pentaho Server 8.1, as well as the transaction execution from the server side. (Operating system Windows 10)

For QA:

  • Build the plugin or get it from buildbot
  • Install the plugin in PDI 7 and 8.1 and Pentaho Server 8.1 (pentaho-server\pentaho-solutions\system\kettle\plugins)
  • Start PDI and connect to the pentaho server
  • Create some sample transformations and save them on the server
  • Execute the sample transactions from the server
  • Download the sample transactions from the server (via http fronted) and open them in PDI from the file system
Comment by Elena Kotsinova (Inactive) [ 2018-11-02 ]

build 1.1.7 for CentOS
and builds 1.1.7 for Windows

Generated at Thu Feb 08 02:29:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.