
- Apache Tajo Tutorial
- Apache Tajo - Home
- Apache Tajo - Introduction
- Apache Tajo - Architecture
- Apache Tajo - Installation
- Apache Tajo - Configuration Settings
- Apache Tajo - Shell Commands
- Apache Tajo - Data Types
- Apache Tajo - Operators
- Apache Tajo - SQL Functions
- Apache Tajo - Math Functions
- Apache Tajo - String Functions
- Apache Tajo - DateTime Functions
- Apache Tajo - JSON Functions
- Apache Tajo - Database Creation
- Apache Tajo - Table Management
- Apache Tajo - SQL Statements
- Aggregate & Window Functions
- Apache Tajo - SQL Queries
- Apache Tajo - Storage Plugins
- Integration with HBase
- Apache Tajo - Integration with Hive
- OpenStack Swift Integration
- Apache Tajo - JDBC Interface
- Apache Tajo - Custom Functions
- Apache Tajo Useful Resources
- Apache Tajo - Quick Guide
- Apache Tajo - Useful Resources
- Apache Tajo - Discussion
Apache Tajo - Storage Plugins
Tajo supports various storage formats. To register storage plugin configuration, you should add the changes to the configuration file “storage-site.json”.
storage-site.json
The structure is defined as follows −
{ "storages": { “storage plugin name“: { "handler": "${class name}”, "default-format": “plugin name" } } }
Each storage instance is identified by URI.
PostgreSQL Storage Handler
Tajo supports PostgreSQL storage handler. It enables user queries to access database objects in PostgreSQL. It is the default storage handler in Tajo so you can easily configure it.
configuration
{ "spaces": { "postgre": { "uri": "jdbc:postgresql://hostname:port/database1" "configs": { "mapped_database": “sampledb” "connection_properties": { "user":“tajo", "password": "pwd" } } } } }
Here, “database1” refers to the postgreSQL database which is mapped to the database “sampledb” in Tajo.
Advertisements