getTabletsMeta
Syntax
getTabletsMeta([chunkPath], [tableName], [diskUsage=false], [top=1024])
Arguments
chunkPath is the DFS path to one or multiple database chunks. It supports wildcards %, * and ?.
tableName is a string indicating a table name.
diskUsage is a Boolean value indicating whether the result includes the column of diskUsage.
top is a positive number indicating the maximum number of chunks in the output. The default value is 1024. To remove the upper limit of chunks in the output, set top to -1.
Details
Return metadata of specified tablet chunks on the local node. To get metadata about all tablet chunks of a distributed table, use getTabletsMeta together with pnodeRun.
Return a table with the following columns:
chunkId: the unique identifier of chunk.
path: the physical path of the partition.
dfsPath: the dfs path of the partition.
tableName: the table name.
version: the version number.
rowNum: the number of records in the partition.
diskUsage: the disk space occupied by partition.
createCids: the Cids created when updating/deleting the table.
latestPhysicalDir: the temporary physical directory storing the data generated by the operation with the latest Cid.
diskUsage: the disk space occupied by partition (in Bytes).
Examples
$ if(existsDatabase("dfs://testDB")){
$ dropDatabase("dfs://testDB")
$ }
$ db=database("dfs://testDB", VALUE, 1..10)
$ n=1000000
$ t=table(rand(1..10, n) as id, rand(100.0, n) as x)
$ db.createPartitionedTable(t, `pt1, `id).append!(t)
$ n=2000000
$ t=table(rand(1..10, n) as id, rand(100.0, n) as x, rand(100, n) as y)
$ db.createPartitionedTable(t, `pt2, `id).append!(t)
$ update loadTable("dfs://testDB",`pt1) set x=x*10
$ getTabletsMeta("/testDB/%", `pt1, true);
chunkId |
path |
dfsPath |
tableName |
version |
rowNum |
createCids |
latestPhysicalDir |
|---|---|---|---|---|---|---|---|
dbfd1767-f9ca-689e-4d5e-643b8506e82d |
C:UsersDownl… |
/testDB/10 |
pt1 |
2 |
99815 |
[2059] |
pt1_2_2059 |
d221b457-fa7b-5990-4caa-13c99f56f716 |
C:UsersDownl… |
/testDB/9 |
pt1 |
2 |
99975 |
[2059] |
pt1_2_2059 |
92904d3b-0147-9bb8-4a28-f99525b250e7 |
C:UsersDownl… |
/testDB/8 |
pt1 |
2 |
99844 |
[2059] |
pt1_2_2059 |
7478c15a-0629-c8ab-47ee-a1d12c3c1cd6 |
C:UsersDownl… |
/testDB/1 |
pt1 |
2 |
100237 |
[2059] |
pt1_2_2059 |
8bc48c11-86ca-97ac-4ee4-8f829de92cc8 |
C:UsersDownl… |
/testDB/5 |
pt1 |
2 |
99991 |
[2059] |
pt1_2_2059 |
6b3a0a09-bc64-3bab-4535-344b7316d244 |
C:UsersDownl… |
/testDB/2 |
pt1 |
2 |
100120 |
[2059] |
pt1_2_2059 |
a7452c44-5d2b-6f82-4150-7bc48e941d64 |
C:UsersDownl… |
/testDB/4 |
pt1 |
2 |
99535 |
[2059] |
pt1_2_2059 |
a1a375cc-b6c0-29b2-485a-330af7447564 |
C:UsersDownl… |
/testDB/6 |
pt1 |
2 |
100518 |
[2059] |
pt1_2_2059 |
b04b4c04-6d43-0d8d-4000-6ae88e349eda |
C:UsersDownl… |
/testDB/3 |
pt1 |
2 |
99919 |
[2059] |
pt1_2_2059 |
b20df3a7-678b-1cbe-400d-d8e566706682 |
C:UsersDownl… |
/testDB/7 |
pt1 |
2 |
100046 |
[2059] |
pt1_2_2059 |