Apache Tajo Database Creation - Apache Tajo

How to create Database Statement in Apache Tajo?

The statement used to create a database in Tajo is Create Database and the syntax for the statement is:

Query

Result

The output generated by the above query is as follows -

Database is the namespace in Tajo. A database can contain multiple tables with a unique name.

How to show current Database in Apache Tajo?

The command used to check the name of the current database is -

Query

Result

The output generated by the above query is as follows -

How to connect to Database in Apache Tajo?

As a database is created with the name “test”, to connect to the “test” database, the syntax used is:

Query

Result

The output generated by the above query is as follows -

The prompt changes change from default database to test database is visible.

How to drop Database in Apache Tajo?

The syntax used to drop a database is -

Query

Result

The output generated by the above query is as follows -

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Apache Tajo Topics