Cloudera Docs

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.13.2-csa1.5.1.0-cdh7.1.7.0-551-18404383.jar
rm SQL_STREAM_BUILDER-1.13.2-csa1.5.1.0-cdh7.1.7.0-551-18404383.jar
  4. Copy the new artifacts to the /opt/cloudera/csd folder. 
    scp <download_location>/FLINK-1.14.0-csa1.6.0.0-cdh7.1.7.0-551-19591977.jar root@<hostname>/opt/cloudera/csd:
scp <location>/SQL_STREAM_BUILDER-1.14.0-csa1.6.0.0-cdh7.1.7.0-551-19591977.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.14.0-csa1.6.0.0-cdh7.1.7.0-551-19591977.jar
chown cloudera-scm:cloudera-scm /opt/cloudera/csd/SQL_STREAM_BUILDER-1.14.0-csa1.6.0.0-cdh7.1.7.0-551-19591977.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.6.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. Select the "Activate Only (no restart)" option when prompted in the wizard.
    For more information about the general process of Service Management, see the Cloudera Manager documentation.
  16. Stop the SQL Stream Builder service.
    1. Click Actions > Stop next to the SQL Stream Builder service name.
  17. Update the Admin Database for the SSB service.
    1. Click Actions > Update Admin Database next to the SQL Stream Builder service name.
  18. Start the SQL Stream Builder service.
    1. Click Actions > Start next to the SQL Stream Builder service name.
  19. Refresh your keytab in Streaming SQL Console.
    1. Select SQL Stream Builder from the list of services.
    2. Click SQLStreamBuilder Console.
      The Streaming SQL Console opens in a new window.
    3. Select your username on the left main menu of Streaming SQL Console.
    4. Click Manage keytab.
    5. Provide your password again.
    6. Click Refresh Keytab.