Hologres
latest
Hologres
Hologres Introduction
What is HSAP?
Advantages and Key Features
Architecture
Basic Concepts and Terminology
Performance
Comparisons to Other Products
Use Cases
Quickstart
Hologres in 20 Minutes
Load, Query, and Visualize US Flight Dataset in Hologres
Using Hologres with Flink
Connect to Hologres
psql
JDBC
SQL Manual
Data Types
Function
Extension Functions via Public API
DDL
DML & DQL
other
Load Data Into Hologres
Apache Flink
Apache Spark
File System
PSQL Client
COPY From Stdin
Read and Unload Data from Hologres
Apache Flink
Apache Spark
File System
PSQL Client
Dump Query Results to OSS
Install and Operate
Installation and Deployment
Configuration
Metrics and Monitoring
Logging
Scale Up and Down
Upgrade
Backup and Restore
Migration
Debugging
Connect to BI Tools
Tableau
Qlik
Power BI
AWS Quicksight
Security and User Management
Roles Overview
Postgres Permission Model
Roles in Hologres
SPM
Powered By
Releases
Contribute
Contribute to Code
Contribute to and Deploy Documentation
Documentation Formatting Rules
Support
Support Resource
Requests, Feedbacks, Issues, Bugs
Hologres
Docs
»
Quickstart
Edit on GitHub
Quickstart
¶
Hologres in 20 Minutes
Prerequisites
Download Sample Data Files
Log into Hologres via psql
Create Hologres Objects
Copy CSV Data into Hologres
Query the Loaded Data
Query All Data
Count Total Number of Rows
Insert Additional Rows of Data
Query Rows Based on Email Address
Query Rows Based on Start Date
Summary and Clean Up
Tutorial Clean Up (Optional)
Load, Query, and Visualize US Flight Dataset in Hologres
Data Preparation
Create Table in Hologres
Copy Data into Hologres
Query
Tableau
Preparation work
Preparation Work 1: Download Tableau Desktop:
Preparation Work 2: Connect to Hologres with Tableau
Visualization in Tableau
Query 1:
Step 1: Add one custom SQL
Step 2: Create one work table, ensure each value in dimensions and measures correctiveness
Step 3: Drag the value to columns and rows to show the report
Query 2:
Step 1: Add one custom SQL
Step 2: Create one work table, ensure each value in dimensions and measures correctiveness
Step 3: Drag the value to columns and rows to show the report
Query 3:
Step 1: Add one custom SQL
Step 2: Create one work table, ensure each value in dimensions and measures correctiveness
Step 3: Drag the value to columns and rows to show the report
Query 4:
Step 1: Add one custom SQL
Step 2: Create one work table, ensure each value in dimensions and measures correctiveness
Step 3: Drag the value to colomns and rows to show the report
Using Hologres with Flink
Prerequisites
Create Hologres Objects
Create a Database
Create a Table
Downdload the Project and Import in IDE
Download the project from following example repository from Github
Import Project in IntelliJ IDEA
Set Hologres Configurations
Write Real-Time Streaming Data into Hologres
Clean the Table
Run the Job
Check the Data
Terminate the Job
Bulk Load Batch Data into Hologres
Clean the Table
Run the Job
Check the Data
Read Batch Data from Hologres
Run the Job
Read the Docs
v: latest
Versions
latest
Downloads
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.