schema

Syntax

schema(table|dbHandle)

Arguments

X is a table or a database.

Details

Display information about the schema of a table or a database.

Examples

$ n=1000000
$ ID=rand(10, n)
$ x=rand(1.0, n)
$ t=table(ID, x)
$ db=database("dfs://rangedb101", RANGE, 0 5 10)
$ pt = db.createPartitionedTable(t, `pt, `ID)
$ pt.append!(t)
$ pt=loadTable(db,`pt);


$ schema(pt);

 partitionSchema->[0,5,10]
 partitionSites->
 partitionColumnType->4
 partitionTypeName->RANGE
 chunkGranularity->TABLE
 keepDuplicates->ALL
 engineType->OLAP
 chunkPath->
 partitionColumnIndex->0
 colDefs->
 name typeString typeInt comment
 ---- ---------- ------- -------
 ID   INT        4
 x    DOUBLE     16

 partitionType->2
 partitionColumnName->ID

$ schema(db);

partitionSchema->[0,5,10]
partitionSites->
partitionTypeName->RANGE
atomic->TRANS
databaseDir->dfs://rangedb101
chunkGranularity->TABLE
engineType->OLAP
partitionType->2