Real time database Hologres AliCloud developer community AliCloud

Developer community > Big data and machine learning > Hologres

Hologres

follow

This technology circle will analyze the latest product trends and technical interpretations of Alibaba Cloud Hologres, and welcome you to join the nailing group - real-time digital warehouse Hologres communication group 32314975

zero
today
one thousand four hundred and forty-two
content
eight
activity
two thousand nine hundred and twelve
follow
|
26 days ago
|
storage Message oriented middleware Kafka
|
Topping

Real time warehouse enhancement, Hologres+Flink build enterprise level real-time database

This paper mainly introduces the enterprise level real-time database built by Hologres+Flink, which realizes real-time data calculation, real-time writing, real-time update and real-time query of the whole link.

one hundred and eleven thousand four hundred and forty-five two
|
26 days ago
|
storage Message oriented middleware monitor
|
Topping

Cao Cao's travel based on Hologres+Flink's real-time data warehouse construction

Lin Zhen, the person in charge of real-time computing for Cao Cao's travel, made a speech on the construction of real-time data warehouse based on Hologres+Flink for Cao Cao's travel

one hundred and forty-seven thousand eight hundred and sixty four
|
26 days ago
|
storage SQL Elastic calculation
|
Topping

Hologres V2.1 was released, and new computing group instances were added to build highly available real-time databases

New instances of elastic computing group are added to solve the core problems of analysis performance, resource isolation, high availability, and elastic expansion and contraction in real-time database scenarios. At the same time, multiple user analysis functions and real-time lake warehouse Paimon format support are added, and COUNT DISTINCT optimization significantly improves query efficiency.

one hundred and fifty thousand two hundred and sixteen twenty-seven
|
17 hours ago
|
storage SQL Distributed Computing
|

Real time data warehouse Hologres operation error collection error report: too many shards in this instance, the threshold is 16, now 16 used, What to do

When using Alibaba Cloud real-time database Hologres, you may encounter different types of errors. For example: 1. Memory overrun error, 2. String buffer expansion error, 3. Partition import error, 4. External table access error, 5. Service not opened or permission problem, 6. Data type range error. The following is an overview of some common error cases and possible causes and solutions.

eleven one
|
17 hours ago
|
SQL Relational database Java
|

Hologres query next from pg executor failed

When using Alibaba Cloud real-time database Hologres, you may encounter different types of errors. For example: 1. Memory overrun error, 2. String buffer expansion error, 3. Partition import error, 4. External table access error, 5. Service not opened or permission problem, 6. Data type range error. The following is an overview of some common error cases and possible causes and solutions.

eight four
|
17 hours ago
|
SQL Elastic calculation Distributed Computing
|

The real-time database Hologres operation error collection encountered a problem when executing the SQL query. The reason for the error is "Invalid index column id: 2". What should I do

When using Alibaba Cloud real-time database Hologres, you may encounter different types of errors. For example: 1. Memory overrun error, 2. String buffer expansion error, 3. Partition import error, 4. External table access error, 5. Service not opened or permission problem, 6. Data type range error. The following is an overview of some common error cases and possible causes and solutions.

ten two
|
17 hours ago
|
SQL data base Python
|

What should I do if an error is reported when creating a table of the real-time data warehouse Hologres operation error collection

When using Alibaba Cloud real-time database Hologres, you may encounter different types of errors. For example: 1. Memory overrun error, 2. String buffer expansion error, 3. Partition import error, 4. External table access error, 5. Service not opened or permission problem, 6. Data type range error. The following is an overview of some common error cases and possible causes and solutions.

eleven five
|
17 hours ago
|
SQL storage Java
|

Real time Data Warehouse Hologres Operation Error Collection: When trying to access the DataHub, the error connection timeout is reported. What should I do

When using Alibaba Cloud real-time database Hologres, you may encounter different types of errors. For example: 1. Memory overrun error, 2. String buffer expansion error, 3. Partition import error, 4. External table access error, 5. Service not opened or permission problem, 6. Data type range error. The following is an overview of some common error cases and possible causes and solutions.

sixteen seven
|
17 hours ago
|
SQL Relational database MySQL
|

Real time database Hologres operation error collection error report: connection to FE failed, and the remaining connection slots are reserved for non replicated super user connection. What should I do

When using Alibaba Cloud real-time database Hologres, you may encounter different types of errors. For example: 1. Memory overrun error, 2. String buffer expansion error, 3. Partition import error, 4. External table access error, 5. Service not opened or permission problem, 6. Data type range error. The following is an overview of some common error cases and possible causes and solutions.

twelve five
|
18 hours ago
|
Distributed Computing Relational database data mining
|

Real time data warehouse Hologres product uses collection. When using the dynamic partition management function to partition by date, query the time range through the primary key and segment_key. What is the reason for poor performance

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

thirteen three
|
18 hours ago
|
storage SQL Distributed Computing
|

How to view instances of the use collection of real-time digital warehouse Hologres products

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

thirteen four
|
18 hours ago
|
storage Distributed Computing Relational database
|

The real-time database Hologres product uses the collection to add a new column in the row stored Hologres. Does the DB lock the table? If not, how to deal with it now

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

eleven four
|
18 hours ago
|
Distributed Computing Relational database data base
|

How to escape single quotation marks in strings when Hologres products use collections

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

eleven three
|
18 hours ago
|
Distributed Computing Search recommendations Relational database
|

When the real-time data warehouse Hologres product returns "INSERT 0 0" using the collection, does the insertion succeed

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

four zero
|
18 hours ago
|
SQL Distributed Computing Relational database
|

Will the query syntax be different from the original query syntax after the real-time database Hologres product uses the combined partition table to create a hot and cold layer

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

six zero
|
18 hours ago
|
Distributed Computing DataWorks Relational database
|

How to initialize MySQL data into partition tables using collection of real-time database Hologres products

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

three zero
|
18 hours ago
|
Distributed Computing DataWorks Relational database
|

Where is the collection of Hologres products used? For example, you can view documents that have found problems but have not yet found a repair version

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

three zero
|
18 hours ago
|
SQL Distributed Computing Relational database
|

The real-time digital warehouse Hologres product uses the Hucang accelerated version of the collection to query the maxcompute external table. Is there any optimization way

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

four zero
|
18 hours ago
|
Distributed Computing Relational database MySQL
|

How to map CTAS to other tools or systems when using Hologres products

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

four zero
|
18 hours ago
|
SQL Distributed Computing Relational database
|

How to map the real-time database Hologres product use collection to Flink's Timestamp in the source table definition

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

six zero
|
18 hours ago
|
storage Distributed Computing Relational database
|

Real time digital warehouse Hologres products use the collection of Hologres quickbi to read whether to use direct reading or connection

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

six zero
|
18 hours ago
|
SQL Distributed Computing Relational database
|

How to connect paymon of real-time digital warehouse Hologres product use collection

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

six zero
|
18 hours ago
|
Distributed Computing algorithm Relational database
|

How to optimize query performance of real-time data warehouse Hologres product use collection

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

eight zero
|
18 hours ago
|
Distributed Computing Relational database data mining
|

Can the real-time data warehouse Hologres product support the flash back function when it uses the collection to delete the data of a table in Hologres by mistake

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

four zero
|
18 hours ago
|
SQL Distributed Computing Relational database
|

How to design a Hologres monthly data table in the hope of using the real-time digital warehouse Hologres product collection

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

five zero
|
18 hours ago
|
Distributed Computing Relational database data mining
|

If the real-time data warehouse Hologres product uses a combination of primary keys, such as id+time (string), will it cause data skew when it is used as a combination of primary keys

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

seven zero
|
18 hours ago
|
storage Distributed Computing Relational database
|

Whether the collection of real-time data warehouse Hologres products provides corresponding functional interfaces and instructions, which can synchronize data from OSS storage to Hologres for analysis

The basic concepts and characteristics of real-time data warehouse Hologres: 1. One stop real-time data warehouse engine: Hologres integrates the capabilities of data warehouse, online analytical processing (OLAP) and online service, and is suitable for real-time data analysis and decision support scenarios. 2. Compatible with PostgreSQL protocol: Hologres supports standard SQL (compatible with PostgreSQL protocol and syntax), making migration and integration simple. 3. Massive data processing capability: It can process multi-dimensional analysis and ad hoc queries of petabyte level data, and support high concurrency and low latency queries. 4. Real time: support real-time data writing, real-time update and real-time analysis to meet the business scenarios with high requirements for data freshness. 5. Integration with big data ecology: deep integration with MaxCompute, Flink, DataWorks and other Alibaba Cloud products to provide offline services

four zero
|
3 days ago
|
storage SQL Search recommendations
|

Introduction to the overall capability of one-stop real-time data warehouse Hologres 2024 Hologres Open Class 01

Introduction to the overall capability of one-stop real-time data warehouse Hologres 2024 Hologres Open Class 01

thirty-seven two
|
5 days ago
|
Java DataWorks
|

How should Hologres solve this situation?

eleven one
|
5 days ago
|
Java Database connection
|

Can Hologres jdbc configure pull resources?

six zero
|
6 days ago
|
Serverless SQL Disaster recovery
|

Real time database Hologres V2.2 was released, and serverless computing cost was reduced by 20%

Real time database Hologres V2.2 was released, and serverless computing cost was reduced by 20%

one hundred and seventeen two
I want to publish