getLocalIOTDBStaticTable

getLocalIOTDBStaticTable(dbUrl, tableName, [dfsPath])

dbUrl is a STRING scalar indicating the path to a DFS database.

tableName is a STRING scalar indicating the table name.

dfsPath is the DFS path to a database chunk. It can be derived by removing the time partition and any subsequent components from the dfsPath column in the result of getChunksMeta. For example, if a chunk's dfsPath is /db/Key1/20250428/gP, this parameter should be set to /db/Key1. By default, the function returns all static tables of the tableName at the local node.

Retrive the static table at the local node. This function can only be called on the data node by the users with TABLE_READ privilege to the table or DB_READ privilege to the database.

Return value:

A table with the following columns:

• innerId: The internal ID corresponding to the measurement point.
• Measurement point columns: They are determined by the sort key (the sort columns except for the last column). If one column is named id or type, it will be automatically renamed to _id_ or _type_ in the returned table.
• valueType: The type of the IOTANY column corresponding to the measurement point.

getLocalIOTDBStaticTable(dbUrl="dfs://db", tableName="pt", dfsPath="/db/Key1")