Install Java 8
Install Java8 with HotSpot JVM:
https://adoptium.net/?variant=openjdk8
When installing, make sure to select “set java_home”
Install 7Zip
https://www.7-zip.org/download.html
Install Python 2.7
(note, this is necessary for cqlsh to work)
https://www.python.org/download/releases/2.7/
Download the windows x86 x64 installer.
Make sure to select “install for all users” when installing.
Note that the python installer does NOT add python to the path. If you would like to add it to the path, you will need to Right-Click on “My Compter” or “This PC”, select “Advanced system settings” Select “Environment Variables” select PATH under “System variables” select “edit” select “new” and then add in the path for python (typically C:\Python27)
Install Visual C++ 2010 Runtime:
https://www.microsoft.com/en-gb/download/details.aspx?id=26999
Download and install the x64 version.
Install Cassandra 3.* (Not 4)
Note, we currently do not run Cassandra 4. This will change in the near future, please make sure to check your release notes in case this changes.
Download the latest version of Cassandra from Apache’s website:
https://cassandra.apache.org/_/download.html
Extract the tar.gz into your download folder using 7zip (simple right-click and extract – you will need to do this twice).
Create a c:\cassandra folder
Copy the contents that you extracted into that folder (drill into the extracted folders until you get a bin\conf\doc, etc. list of files and folders)
Right-click on “c:\cassandra\bin\cassandra.bat” and select “run as administrator” This will launch Cassandra for you. Leave this command window open so you can access cassandra.
if it throws an access violation exception and mentions “sigar-amd64…” in the error, navigate to
C:\cassandra\lib\sigar-bin
rename sigar-amd64-winnt.dll to “_sigar-amd64-winnt.dll“ (this is so it doesn’t bother trying to load it)
Download latest Spoon with Plugins
This downloads our pre-packaged version of spoon with all the Alterian plugins pre-installed
https://ddepdi.s3.eu-west-2.amazonaws.com/pdi.zip
Extract that to your download folder, create a folder to hold it where you want. I usually have C:\
Program Files\Kettle but it doesn’t matter where it is.
Run spoon.bat to launch Kettle.
Download a client to query Cassandra
The following instructions detail how to install Datastax DevCenter. However, there are a number of clients available to view tables and run queries against Cassandra.
Download Devcenter from the following location: https://downloads.datastax.com/#devcenter
Uncompress the file to the root of C
e.g. DevCenter-1.6.0-win-x86_64.zip → C:\DevCenter-1.6.0-win-x86_64
Run "C:\DevCenter-1.6.0-win-x86_64\DevCenter\DevCenter.exe"
Ensure Cassandra is running and create a connection to it:
Click Finish
In the query window, select the connection
The schema window will now show all the available keyspaces and tables
...