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.

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.
Download the new CSD files from the Download location.

Delete the old CSD version from /opt/cloudera/csd.

Access the host where the CSD is stored.

ssh root@<hostname>
cd /opt/cloudera/csd
rm FLINK-1.13.2-csa1.5.0.0-cdh7.1.7.0-551-17228637.jar
rm SQL_STREAM_BUILDER-1.13.2-csa1.5.0.0-cdh7.1.7.0-551-17228637.jar

Copy the new artifacts to the /opt/cloudera/csd folder.

warning
The upgrade process fails if you only add the new parcel file in Cloudera Manager. You must add the Flink and SSB CSD to the /opt/cloudera/csd folder as well.
```
scp <download_location>/FLINK-1.13.2-csa1.5.1.0-cdh7.1.7.0-551-18404383.jar root@<hostname>/opt/cloudera/csd:
scp <location>/SQL_STREAM_BUILDER-1.13.2-csa1.5.1.0-cdh7.1.7.0-551-18404383.jar root@<hostname>/opt/cloudera/csd:
```

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.1.0-cdh7.1.7.0-551-18404383.jar
chown cloudera-scm:cloudera-scm /opt/cloudera/csd/SQL_STREAM_BUILDER-1.13.2-csa1.5.1.0-cdh7.1.7.0-551-18404383.jar

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
Restart the Cloudera Management Services.
Select Parcels on the Home > Hosts tab in the Cloudera Manager main navigation bar.
Click on Parcel Repositories & Network Settings tab.
Add the new Remote Parcel Repository URL for CSA.
```
https://user:password@archive.cloudera.com/p/csa/1.5.0.0/parcels/
```
note
Make sure that the Remote Parcel Repository URL uses HTTPS link. To install a different version of the parcel, you can change the URL as needed.
Click Save & Verify Configuration to commit the change.
Click Close.
You are redirected to the Parcels page.
Deactivate the old version of the parcel on the Parcels page.
Download, activate and distribute the new version of the parcel.
Restart the SSB service when prompted in the wizard.
For more information about the general process of Service Management, see the Cloudera Manager documentation.
Update the Admin Database for the SSB service.
1. Click Action > Update Admin Database next to the SQL Stream Builder service name.