Cassandra Products JSON | Fresco Play
Author: neptune | 29th-Oct-2023
Cassandra is a powerful NoSQL database system that's well-suited for handling large volumes of data. In this blog, we'll go through a series of common tasks related to managing data in Cassandra. We'll address each query and provide a detailed solution with explanations to help you get started.
Problem Statements with solution:
1. Create a Keyspace
To create a keyspace named 'electric' with class 'SimpleStrategy' and replication factor 1, you can use the following command in the Cassandra Query Language Shell (cqlsh):
CREATE KEYSPACE IF NOT EXISTS electric
WITH REPLICATION = {'class': 'SimpleStrategy', 'replication_factor': 1};
This command ensures that the keyspace is created only if it doesn't already exist.
2. Create a Table
Now, let's create a table named 'products' with the specified columns and data types:
- id (int, primary key)
- category (text)
- name (text)
- price (int)
- discount (text)
- companyname (text)
To create this table, use the following command:
CREATE TABLE IF NOT EXISTS electric.products (
id int PRIMARY KEY,
category text,
name text,
price int,
discount text,
companyname text
);
3. Insert Data from JSON
If you have a JSON file named 'products.json' with data to insert into the 'products' table, you can use the following CQL command:
COPY electric.products (id, category, name, price, discount, companyname)
FROM 'products.json' WITH HEADER = true;
Make sure that the 'products.json' file is in the same directory as cqlsh or provide the full path to the file. The `WITH HEADER = true` option assumes that the first row of the JSON file contains column headers.
To check if the data is loaded successfully, you can query the 'products' table.
4. Query for Discounted Products
To retrieve the details of products available for discounts (where `discount` is true) and save the results in 'discount_products.txt', use the following command:
cqlsh -e "SELECT * FROM electric.products WHERE discount = 'true'" > discount_products.txt
This command executes a SELECT query and redirects the output to 'discount_products.txt'.
5. Find the Maximum Price
To get the maximum price among the specified products and store the result in 'max_price.txt', use the following command:
cqlsh -e "SELECT MAX(price) FROM electric.products" > max_price.txt
This command calculates the maximum price and saves it to 'max_price.txt'.
6. Products Belonging to Haier
If you want to retrieve the details of products belonging to the company 'Haier' and store the results in 'haier_products.txt', use the following command:
cqlsh -e "SELECT * FROM electric.products WHERE companyname = 'Haier'" > haier_products.txt
This command filters the products based on the company name and saves the results in 'haier_products.txt'.
7. Washing Machine Products
To get the details of products categorized as 'Washing machine' and store the results in 'washingmachine_products.txt', use the following command:
cqlsh -e "SELECT * FROM electric.products WHERE category = 'Washing machine'" > washingmachine_products.txt
This command filters the products based on the category and saves the results in 'washingmachine_products.txt'.
By following these steps, you can efficiently manage your data in Cassandra, from creating keyspaces and tables to querying and exporting specific data based on your needs.
#JavaScript #Hackerrank #Python #Motivation #AI #React.js #Testing #Interview #SQL #Selenium #LeetCode #Problem Solving #Machine learning #Java #GPT #AWS #API #IT #Algorithms #Github #Jobs #Microservice #Certifications #Projects #Google #Django #Story #Pip #Data Science #Postman #Health #Twitter #Elon Musk #Node.js
5. Solution of Hacker Rank Weather Observation Station 8.Author: neptune | 23rd-Jan-2023
#SQL #Hackerrank
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates...
The Blunder | HackerrankAuthor: neptune | 21st-Nov-2022
#SQL #Hackerrank
Write a query calculating the amount of error (i.e.: average monthly salaries), and round it up to the next integer...
7.Solution of Hacker Rank The ReportAuthor: neptune | 23rd-Jan-2023
#SQL #Hackerrank
Problem Statement : generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the NAMES of those students who received a grade lower than 8...
4. Solution of Hacker Rank Weather Observation Station 6.Author: neptune | 23rd-Jan-2023
#SQL #Hackerrank
Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates...
3. Solution of Hacker Rank Weather Observation Station 4.Author: neptune | 23rd-Jan-2023
#SQL #Hackerrank
Problem Statement : Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table...
The PADS | HackerrankAuthor: neptune | 21st-Nov-2022
#SQL #Hackerrank
Problem Statement: Generate the following two result sets: 1. Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession...
6. Solution of Hacker Rank Employee Salaries.Author: neptune | 23rd-Jan-2023
#SQL #Hackerrank
Problem Statement : Query that prints a list of employee names for employees in Employee having a salary greater than $2000 per month and experience less than 10 months...
Identifying the Odd One Out in a Series of Strings | HackerrankAuthor: neptune | 15th-Jun-2023
#Hackerrank #Problem Solving
The article presents an algorithm to identify the odd one out in a series of strings efficiently...
1. Basic SQL Select Query of Hacker Rank.Author: neptune | 20th-Apr-2022
#SQL #Hackerrank
Problem Statement : Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA...
2. Solution of Hacker Rank Weather Observation Station 3.Author: neptune | 23rd-Jan-2023
#SQL #Hackerrank
Problem Statement : Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer...
Modified 0-1 knapsack problem | Frsco Play HackerrankAuthor: neptune | 05th-Nov-2023
#Hackerrank #Problem Solving
An automobile mechanic wants to buy a set of spare parts from a manufacturing unit. Goal is to maximise the amount of money the mechanic can earn...
AngularJS - Know Tech Frameworks | Fresco PlayAuthor: neptune | 05th-Nov-2023
#Hackerrank #Problem Solving
Build an application that displays the framework details using AngularJS routing. We will build an application that displays the Tech Frontend and Backend frameworks...
Solving the Ice Cream Parlor Problem | HackerrankAuthor: neptune | 04th-Jun-2023
#Hackerrank #Problem Solving
Two friends like to pool their money and go to the ice cream parlour. They always choose two distinct flavours and they spend all of their money...
Backspace String Compare using R | Fresco PlayAuthor: neptune | 05th-Nov-2023
#Hackerrank #Problem Solving
The code implementation in both R and Python solves the "Backspace String Compare" problem using stack data structure...
Git - Recovering Discarded ChangesAuthor: neptune | 13th-Jul-2023
#Github #Problem Solving
We will follow a scenario where a developer is working on a web application and needs to recover a discarded commit to reintroduce a specific feature...
PySpark Milestone Black Friday Sales Data | Fresco Play HackerrankAuthor: neptune | 05th-Nov-2023
#Data Science #Hackerrank
Welcome to the Spark Challenge. You are provided with the Black Friday sales data and we as a big data developer needs to analyze and fetch the required data...
Problem of Merging Two Sorted Linked ListsAuthor: neptune | 02nd-Jun-2023
#Algorithms #Problem Solving
Merging two sorted linked lists efficiently into a single, sorted list can be achieved using optimized algorithms...
Finding the Most Expensive Keyboard and USB Drive within a Budget | HackerrankAuthor: neptune | 05th-Jun-2023
#Hackerrank #Problem Solving
A person wants to determine the most expensive computer keyboard and USB drive that can be purchased with a give budget...
Python - Number Based Problem | HackerrankAuthor: neptune | 17th-Aug-2023
#Hackerrank #Problem Solving
Determine whether the number in descending order is a prime or not. If the number is a prime, then print "Sorted Number is a prime number," otherwise, print "Sorted Number is not a prime number."..
Join Operations in R | Fresco PlayAuthor: neptune | 29th-Oct-2023
#Hackerrank #Problem Solving
Perform various join operations in R using two data sets, 'flights' and 'weather'...
View More