getTablet

Syntax

getTablet(table, partition)

Arguments

table is an in-memory partitioned table.

partition is a scalar/vector indicating a partition or partitions. If an element of partition belongs to the partitioning scheme of a partition, it represents the entire partition.

Details

Return a table or a list of tables corresponding to the specified partition or partitions.

If partition is a scalar, return a table.

If partition is a vertor, return a tuple in which every element is a table.

Examples

$ db=database(partitionType=RANGE, partitionScheme=2012.06.01 2012.06.10 2012.06.20 2012.07.01)
$ n=30
$ t=table(take(2012.06.01..2012.06.30, n) as date, n..1 as val)
$ pt=db.createPartitionedTable(table=t, tableName=`pt, partitionColumns=`date).append!(t);

$ getTablet(pt, 2012.06.05);

date	val
2012.06.01	30
2012.06.02	29
2012.06.03	28
2012.06.04	27
2012.06.05	26
2012.06.06	25
2012.06.07	24
2012.06.08	23
2012.06.09	22

$ result=getTablet(pt, 2012.06.22 2012.06.11);
$ result.size();
2

$ result[0];

date	val
2012.06.20	11
2012.06.21	10
2012.06.22	9
2012.06.23	8
2012.06.24	7
2012.06.25	6
2012.06.26	5
2012.06.27	4
2012.06.28	3
2012.06.29	2
2012.06.30	1