1.

Explain About Tablespace?

Answer»

The locations in the STORAGE system are defined by TABLESPACE. It is supported for only INTERNAL tables. Tablespaces are accessed by their names. Each tablespace can use a different storage type. If the tablespace is not specified then, Tajo uses the default tablespace in the root directory. Tajo’s internal table RECORDS can be accessed from another table only. It can be configured with tablespace.

CREATE TABLE [IF NOT EXISTS] 

[(column_list)] [TABLESPACE tablespace_name]

[using [with ( = , ...)]] [AS ]

The locations in the storage system are defined by Tablespace. It is supported for only internal tables. Tablespaces are accessed by their names. Each tablespace can use a different storage type. If the tablespace is not specified then, Tajo uses the default tablespace in the root directory. Tajo’s internal table records can be accessed from another table only. It can be configured with tablespace.

CREATE TABLE [IF NOT EXISTS] 

[(column_list)] [TABLESPACE tablespace_name]

[using [with ( = , ...)]] [AS ]



Discussion

No Comment Found