Limitations and Setup Guide
Refer to the following limitations for optimization when running queries in Data Query.
Query settings
| Item | Value | Description |
|---|---|---|
| Max Query Run Time | 1h | Max time a query runs on the cluster - The query stops after this time |
| Max Query Length | 256KB | Max character length of SQL query text - Queries exceeding this length will not be processed and end with QUERY_TEXT_TOO_LARGE error |
Hive Connector settings
| Item | Value | Description |
|---|---|---|
| Table Storage Format | ORC | Default file format when creating new tables - ORC(default), Parquet, Avro, JSON, CSV, TEXT |
| Data Storage Compression Codec | GZIP | Compression codec used when storing data |
| Max Partitions Scanable Per Single Table | 10,000 pcs | Max number of partitions for scanning a single table |
| Max Partitions Scanable Per Single Query | 10,000 pcs | Max number of partitions scanned in a single query |
| Max Files Scanable Per Single Query | 10,000 pcs | Max number of files scanned in a single query |
MySQL connector settings
| Item | Value | Description |
|---|---|---|
| Case Sensitivity for Table/Schema | false | Case-insensitive schema and table names supported - true, false |
Resource group settings
| Item | Value | Description |
|---|---|---|
| Max Queue Queries | 50 pcs | Max number of queries allowed in queue |
| Max Concurrent Queries | 10 pcs | Max number of queries running concurrently - New queries rejected if exceeded |