prods

gistfile1.txt

CREATE TABLE amazonindia.products (
    product_id uuid,
    product_price double,
    category_desc text,
    category_name text,
    product_name text,
    PRIMARY KEY (product_id, product_price)
)

CREATE CUSTOM INDEX product_name_idx ON amazonindia.products (product_name) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'case_sensitive': 'false'};