getTabletsMeta
Syntax
getTabletsMeta([chunkPath],[tableName],[diskUsage=false],[top=124])
Arguments
chunkPath (optional) is the DFS path to one or multiple database chunks. It supports wildcards %, * and ?.
tableName (optional) is a string indicating a table name.
diskUsage (optional) is a Boolean value indicating whether the result includes the column of diskUsage.
top (optional) 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.
-
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 |