- 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 - JSON Functions
The JSON functions are listed in the following table −
| S.No. | Function & Description |
|---|---|
| 1 | json_extract_path_text(js on text, json_path text)
Extracts JSON string from a JSON string based on json path specified. |
| 2 | json_array_get(json_array text, index int4)
Returns the element at the specified index into the JSON array. |
| 3 | json_array_contains(json_ array text, value any)
Determine if the given value exists in the JSON array. |
| 4 | json_array_length(json_ar ray text)
Returns the length of json array. |
Advertisements