existsPartition
Syntax
existsPartition(path, [tableName])
Arguments
path is a string indicating the path of a partition folder.
tableName (optional) is a string indicating the table name. If
chunkGranularity is set to "DATABASE" when creating the database,
tableName is not required. If chunkGranularity is set to
"TABLE":
-
If the parameter path contains the physical index of the table (which can be retrieved with the function
listTables), tableName is not required. -
Otherwise, tableName must be specified.
Details
Check if the specified partition exists.
Examples
Check if the specified partition exists. The following scripts must be executed on a data node or compute node.
n=1000000
ID=rand(10, n)
dates=2017.08.07..2017.08.11
date=rand(dates, n)
x=rand(10.0, n)
t=table(ID, date, x)
db = database("dfs://valueDB", VALUE, 2017.08.07..2017.08.11)
pt = db.createPartitionedTable(t, `pt, `date);
pt.append!(t);
listTables("dfs://valueDB")| tableName | physicalIndex |
|---|---|
| pt | s |
existsPartition("dfs://valueDB/20170807/s");
// output: true
//When the chunk granularity of the database is at TABLE level and the parameter path doesn't contain table physicalIndex, the parameter tableName must be specified or the partition cannot be found.
existsPartition("dfs://valueDB/20170807", `pt)
// output: true
existsPartition("dfs://valueDB/20170807");
// output: false
existsPartition("dfs://valueDB");
// output: false
existsPartition("dfs://valueDB/20170807/s/pt");
// output: false