Upgrading CSA artifacts for SQL Stream Builder service

You need to upgrade the Cloudera Streaming Analytics (CSA) artifacts to the newer version by manually deleting the old CSD file from the repository, deactivating the old parcel and installing the latest CSD file and parcel.

  1. Stop the SQL Stream Builder service on your cluster.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click Action > Stop.
  2. Download the new CSD files from the Download location.
  3. Delete the old CSD version from /opt/cloudera/csd.
    1. Access the host where the CSD is stored.
      ssh root@<hostname>
      cd /opt/cloudera/csd
      rm FLINK-1.12-csa1.4.1.0-cdh7.1.6.0-297-15479260.jar
      rm SQL_STREAM_BUILDER-1.12-csa1.4.1.0-cdh7.1.6.0-297-15479260.jar
  4. Copy the new artifacts to the /opt/cloudera/csd folder.
    scp <download_location>/FLINK-1.13.2-csa1.5.0.0-cdh7.1.7.0-551-17228637.jar root@<hostname>/opt/cloudera/csd:
    scp <location>/SQL_STREAM_BUILDER-1.13.2-csa1.5.0.0-cdh7.1.7.0-551-17228637.jar root@<hostname>/opt/cloudera/csd:
  5. Ensure that you maintain the appropriate file ownership and access the attributes if needed.
    chown cloudera-scm:cloudera-scm /opt/cloudera/csd/FLINK-1.13.2-csa1.5.0.0-cdh7.1.7.0-551-17228637.jar
    chown cloudera-scm:cloudera-scm /opt/cloudera/csd/SQL_STREAM_BUILDER-1.13.2-csa1.5.0.0-cdh7.1.7.0-551-17228637.jar
  6. Restart the Cloudera Manager Server with the following command:
    • RHEL 7 Compatible, SLES 12, Ubuntu: systemctl restart cloudera-scm-server
    • RHEL 6 Compatible: service cloudera-scm-server restart
  7. Restart the Cloudera Management Services.
  8. Select Parcels on the Home > Hosts tab in the Cloudera Manager main navigation bar.
  9. Click on Parcel Repositories & Network Settings tab.
  10. Add the new Remote Parcel Repository URL for CSA.
    https://user:password@archive.cloudera.com/p/csa/1.5.0.0/parcels/
  11. Click Save & Verify Configuration to commit the change.
  12. Click Close.
    You are redirected to the Parcels page.
  13. Deactivate the old version of the parcel on the Parcels page.
  14. Download, activate and distribute the new version of the parcel.
  15. Restart the SSB service when prompted in the wizard.
    For more information about the general process of Service Management, see the Cloudera Manager documentation.
  16. Update the Admin Database for the SSB service.
    1. Click Action > Update Admin Database next to the SQL Stream Builder service name.