Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://datastation.multiprocess.io/docs/tutorials/Query_Scylla_with_DataStation.html below:

Run Scylla in Docker and query with DataStation

This tutorial walks through running Scylla in Docker and querying the database in DataStation.

If you want to follow along with this tutorial verbatim, in your terminal start Scylla in Docker:

$ cid=$(docker run -d -p 9042:9042 scylladb/scylla --smp 1 --authenticator PasswordAuthenticator --broadcast-address 127.0.0.1 --listen-address 0.0.0.0 --broadcast-rpc-address 127.0.0.1)

Then use the started container id to create a new keyspace via cqlsh, using the default credentials, within the container (you may need to wait a few seconds for the container to initialize before running this):

$ docker exec "$cid" cqlsh -u cassandra -p cassandra -e "CREATE KEYSPACE test WITH REPLICATION = {'class': 'SimpleStrategy', 'replication_factor': 1};"

Now inside DataStation create a new data source in the left sidebar.

Give it a nice name so you easily can find it later. And select ScyllaDB in the Vendor dropdown.

If you are connecting to localhost:9042 (the default), you can leave the host field blank. If your port is 9042 then you can always omit the colon and port and just specify the address.

Next fill in the username and authentication fields if necessary. Leaving these fields blank is ok too.

If you want connect to a Scylla database on a remote server through an SSH proxy, you will need to set up the SSH connection to that server first. Once you do, you can select that connection in the "Via Server" dropdown within the data source editor.

Now create a new panel and select the Database type.

Copy the following query and hit play!

SELECT * FROM system.local;

Note: Ctrl-r is a shortcut for hitting the play button when you are focused on one panel.

You can always download the results of a panel by hitting the download button. Or you can reference the results in other panels.

After running the query, a table button will appear below the panel next to the New Panel button. Click it to generate a table based on this panel.

See an error or want to add a clarification? This page is generated from this file on Github.

Last edited Apr 06, 2022.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4