- Introduction
- Quick Start
- Table Design
- Data Loading
- Data Export
- Using StarRocks
- Administration
- FAQs
- Deploy
- Data Migration
- Developers
- Contribute to StarRocks
- Code Style Guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
- Integration
Edit
Insert Into FAQs
When performing data insert, each insert in SQL takes up 50 to 100ms. Is there any way to increase efficiency?
It is not recommended to insert data piece by piece to OLAP. It is usually inserted in batches. Both methods take up the same amount of time.
'Insert into select' task reports error: index channel has intoleralbe failure
This can be solved by changing the timeout limit for stream load RPC. Also, change the following two items in fe.conf and be.conf to larger values (you can also make the adjustment in the Manager page):
streaming_load_rpc_max_alive_time_sec=2400
tablet_writer_open_rpc_timeout_sec=120
The error "execute timeout" occurs when I run the INSER INTO SELECT command to load a large volume of data
By default, the query timeout duration is 300s. You can set the query_timeout
parameter to extend this duration. The unit is second.
Edit
In this article