﻿1
00:00:00,060 --> 00:00:05,790
‫Partitioning times, so that's what we did, partitioning range as the example I gave IDs, you can

2
00:00:05,790 --> 00:00:06,920
‫partition by a long day.

3
00:00:06,930 --> 00:00:11,610
‫Let's say you you have an Iot devices spitting out measurement or something like that.

4
00:00:11,640 --> 00:00:14,430
‫And there is a log date with every single measurement.

5
00:00:14,520 --> 00:00:22,770
‫And you go on a partition like, oh, 2012 data 2013, the 2020 data on each year by partition of each

6
00:00:22,770 --> 00:00:26,520
‫quarter or each month put it in a given partition.

7
00:00:26,520 --> 00:00:31,920
‫So that's ranged right from this date to this date, throw it in this partition and then the beauty

8
00:00:31,920 --> 00:00:37,440
‫of this like, oh, this, this table, this partition is old and nobody uses it anymore to who's going

9
00:00:37,440 --> 00:00:39,950
‫to query 1995 data anymore.

10
00:00:40,200 --> 00:00:44,730
‫So let's move it into a slower archive like, I don't know, running on tape somewhere.

11
00:00:44,940 --> 00:00:46,710
‫So if it's slow, I don't care.

12
00:00:47,000 --> 00:00:50,070
‫That's range bilis discrete values.

13
00:00:50,250 --> 00:00:55,440
‫States, for example, California, Oros or any customer in California goes on this table.

14
00:00:55,440 --> 00:00:56,340
‫This is not range.

15
00:00:56,580 --> 00:01:03,120
‫This is a value say that partition is for California people that partition for Alabama or zip codes.

16
00:01:03,120 --> 00:01:03,300
‫Right.

17
00:01:03,360 --> 00:01:04,530
‫Or countries the same thing.

18
00:01:04,920 --> 00:01:05,260
‫Right.

19
00:01:05,280 --> 00:01:08,560
‫So that's that's another way of partitioning by hash.

20
00:01:08,850 --> 00:01:15,810
‫Another popular Feinglass Cassandra uses that right where where you use the hash function to to spread

21
00:01:15,810 --> 00:01:16,290
‫the value.

22
00:01:16,290 --> 00:01:18,000
‫So hash function, that gives you a hash.

23
00:01:18,180 --> 00:01:20,280
‫If you got this hash, go to this table.

24
00:01:20,280 --> 00:01:21,930
‫If you got this hash goes to this table.

25
00:01:22,230 --> 00:01:24,090
‫So that's a very, very popular thing.

26
00:01:24,240 --> 00:01:31,170
‫I know in the proxy's we use IAP hash to kind of decide which back into it based on the IP.

27
00:01:31,170 --> 00:01:32,190
‫So that's another idea.

