–oss-hdfs的文件导入标签sr
–sr建表
CREATE TABLE test.arch_account_type2
(
id int(11) NOT NULL COMMENT “主键”,
name varchar(65533) NULL COMMENT “来源类型名称”,
url varchar(65533) NULL COMMENT “来源类型的图片的url”,
create_time datetime NULL COMMENT “创建时间”,
update_time datetime NULL COMMENT “更新时间”,
kudu_time datetime NULL COMMENT “kudu存储时间”,
kafka_time datetime NULL COMMENT “kafka发送时间”
) ENGINE=OLAP
PRIMARY KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
“compression” = “LZ4”,
“enable_persistent_index” = “true”,
“fast_schema_evolution” = “true”,
“replicated_storage” = “true”,
“replication_num” = “1”
);
2、–2、
SELECT * FROM FILES(
“path” = “oss://xxx/user/hive/warehouse/ods.db/arch_account_type_all_temp4/*”,
“format” = “parquet”,
“hadoop.security.authentication” = “simple”
);
报错：ERROR 1064 (HY000): Access storage error. Error message: No FileSystem for scheme “oss”