cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lutaya Shafiq Holmes <lutayasha...@gmail.com>
Subject Re: CREATE INDEX without IF NOT EXISTS when snapshoting
Date Tue, 10 Oct 2017 08:01:03 GMT
TRY THIS CODE -

REPLACE WITH YOUR OWN KEYSPACE AND TABLE

cqlsh:tutorialspoint> describe table emp;
CREATE TABLE tutorialspoint.emp (
emp_id int PRIMARY KEY,
emp_city text,
emp_name text,
emp_phone varint,
emp_sal varint
) WITH bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'min_threshold': '4', 'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32'}
AND compression = {'sstable_compression':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
CREATE INDEX emp_emp_sal_idx ON tutorialspoint.emp (emp_sal);

On 10/10/17, ganesh.gadde@bt.com <ganesh.gadde@bt.com> wrote:
> Hi,
>
> Is there a way to estimate the size of table and index ?
> I know we can estimate the size once table and index are already created
> using nodetool cfstats, but I want to know before loading data into table.
> Could you please help if there is any such formula to find out.
>
> Thanks and Regards
> Ganesh
> From: Javier Canillas [mailto:javier.canillas@gmail.com]
> Sent: 05 October 2017 14:42
> To: user@cassandra.apache.org
> Cc: Cassandra DEV <dev@cassandra.apache.org>
> Subject: Re: CREATE INDEX without IF NOT EXISTS when snapshoting
>
> Well,
>
> Patches submitted for version 3.0, 3.11 and trunk (although 3.0 patch can be
> applied to 3.11). Feel free to review and comment.
>
> Thanks!
>
> 2017-10-04 16:41 GMT-03:00 Javier Canillas
> <javier.canillas@gmail.com<mailto:javier.canillas@gmail.com>>:
> Kurt,
>
> Thanks for your response. Created this
> ticket<https://issues.apache.org/jira/browse/CASSANDRA-13935>. Feel free to
> add anything to it that seems legit.
>
> Downloading Cassandra code right now.
>
> Fix seems quite simple. Expect a pull-request soon xD
>
> 2017-10-03 20:19 GMT-03:00 kurt greaves
> <kurt@instaclustr.com<mailto:kurt@instaclustr.com>>:
> Certainly would make sense and should be trivial.
> here<https://github.com/apache/cassandra/blob/982ab93a2f8a0f5c56af9378f65d3e9e430000b9/src/java/org/apache/cassandra/db/ColumnFamilyStoreCQLHelper.java#L251>
> is where you want to look. Just create a ticket for it and prod here for a
> reviewer once you've got a change.‚Äč
>
>
>


-- 
Lutaaya Shafiq
Web: www.ronzag.com | info@ronzag.com
Mobile: +256702772721 | +256783564130
Twitter: @lutayashafiq
Skype: lutaya5
Blog: lutayashafiq.com
http://www.fourcornersalliancegroup.com/?a=shafiqholmes

"The most beautiful people we have known are those who have known defeat,
known suffering, known struggle, known loss and have found their way out of
the depths. These persons have an appreciation, a sensitivity and an
understanding of life that fills them with compassion, gentleness and a
deep loving concern. Beautiful people do not just happen." - *Elisabeth
Kubler-Ross*

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org


Mime
View raw message