【详述】
前台报错:Failed to create table ods.test0502, msg: null
后台报错:Failed to create table ods.test0410
Caused by: org.apache.hadoop.hive.metastore.api.AlreadyExistsException: Table test0410 already exists
show tables可以看到表,但是没有对应的hdfs目录
【StarRocks版本】StarRocks-3.2.4
【集群规模】3fe(1 follower+2observer)+3be(fe与be混部)
【联系方式】578086335@qq.com
【附件】
StarRocks集群使用root启动,hadoop_env.sh已经使用了export hive,所有节点已部署
语句:set catalog tmp;create table tmp.ods.test0502(id int)
具体报错如下:
FE日志:
2024-04-01 16:23:04,164 ERROR (thrift-server-pool-21|239) [HiveMetaClient.callRPC():163] Failed to create table ods.test0410
Caused by: org.apache.hadoop.hive.metastore.api.AlreadyExistsException: Table test0410 already exists
2024-04-01 16:23:04,164 ERROR (thrift-server-pool-21|239) [HiveMetaClient.callRPC():170] An exception occurred when using the current long link to access metastore. msg: Failed to create table ods.test0410
2024-04-01 16:23:04,165 ERROR (thrift-server-pool-21|239) [HiveMetastoreOperations.createTable():189] Failed to create table ods.test0410
2024-04-01 16:23:04,189 WARN (thrift-server-pool-21|239) [StmtExecutor.handleDdlStmt():1599] DDL statement (create table test0410(id int)) process failed.
com.starrocks.common.DdlException: Failed to create table ods.test0410. msg: Failed to create table ods.test0410, msg: null
Hive-Meta的日志如下:
2024-04-01 17:00:39,020 INFO org.apache.hadoop.hive.metastore.HiveMetaStore.audit: [pool-8-thread-107246]: ugi=root ip=172.21.98.247 cmd=source:172.21.98.247 create_table: Table(tableName:test0502, dbName:ods, owner:root, createTime:1711962038, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:id, type:int, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[], parameters:{totalSize=0, numRows=0, rawDataSize=0, COLUMN_STATS_ACCURATE={“BASIC_STATS”:“true”}, numFiles=0, numFilesErasureCoded=0}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE, privileges:PrincipalPrivilegeSet(userPrivileges:{root=[PrivilegeGrantInfo(privilege:INSERT, createTime:-1, grantor:root, grantorType:USER, grantOption:true), PrivilegeGrantInfo(privilege:SELECT, createTime:-1, grantor:root, grantorType:USER, grantOption:true), PrivilegeGrantInfo(privilege:UPDATE, createTime:-1, grantor:root, grantorType:USER, grantOption:true), PrivilegeGrantInfo(privilege:DELETE, createTime:-1, grantor:root, grantorType:USER, grantOption:true)]}, groupPrivileges:null, rolePrivileges:null), temporary:false, ownerType:USER)