为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
iceberg建表之后, 查询报错
看了下建表语句 默认的location不对
mysql> show create catalog lake;
±--------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Catalog | Create Catalog |
±--------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| lake | CREATE EXTERNAL CATALOG lake
PROPERTIES (“aws.s3.access_key” = “rHLe",
“aws.s3.secret_key” = "s0x5”,
“enable_iceberg_metadata_cache” = “false”,
“aws.s3.endpoint” = “http://192.168.40.210:9000”,
“aws.s3.enable_ssl” = “false”,
“aws.s3.enable_path_style_access” = “false”,
“aws.s3.region” = “oss-cn-hangzhou”,
“iceberg.catalog.warehouse” = “s3a://yuce-saas-datalake/iceberg/”,
“hive.metastore.uris” = “thrift://192.168.40.203:9083”,
“type” = “iceberg”,
“iceberg.catalog.type” = “hive”
) |
±--------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
mysql> create table test_table (a int, b varchar);
Query OK, 0 rows affected (0.16 sec)
mysql> show create table test_table;
±-----------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±-----------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test_table | CREATE TABLE test_table (
a int(11) DEFAULT NULL,
b varchar(1073741824) DEFAULT NULL
)
PROPERTIES (“location” = “file:/user/hive/warehouse/test.db/test_table”); |
±-----------±---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.03 sec)
原来是这样的:
mysql> show create table test_table;
±-----------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±-----------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test_table | CREATE TABLE test_table (
a int(11) DEFAULT NULL,
b varchar(1073741824) DEFAULT NULL
)
PROPERTIES (“location” = “s3a://yuce-saas-datalake/iceberg/saas_datalake/test_table”); |
±-----------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.07 sec)
【背景】做过哪些操作？
【业务影响】
【是否存算分离】
【StarRocks版本】例如：1.18.2
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
- fe.log/beINFO/相应截图
- 慢查询：
- Profile信息，获取Profile，通过Profile分析查询瓶颈
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错：
- query_dump，怎么获取query_dump文件
- be crash
- be.out
- coredump，如何获取coredump
- 外表查询报错
- be.out和fe.warn.log