666chaoge666 commented on issue #8600:
URL:
https://github.com/apache/incubator-doris/issues/8600#issuecomment-1074964690
> pls show the table schema , and query sql without sensitive info.
建表及load语句如下：
CREATE TABLE t_user_dau_detail (
dt varchar(10) DEFAULT "",
channel varchar(36) DEFAULT "",
uuid varchar(124) DEFAULT ""
)
DISTRIBUTED BY HASH(`dt`) BUCKETS 100
PROPERTIES("replication_num" = "1");
LOAD LABEL example_db.abc
(
DATA
INFILE("hdfs://nameservice1/user/hive/warehouse/t_user_detail/dt=20220302/channel=abc/*/*")
INTO TABLE t_user_dau_detail
COLUMNS TERMINATED BY "\\x01"
FORMAT AS "orc"
(uuid)
COLUMNS FROM PATH AS (dt,channel)
SET(
dt=dt,
channel=channel,
uuid=uuid
)
)
WITH BROKER 'broker_hdfs'
PROPERTIES
(
"max_filter_ratio" = "1",
"exec_mem_limit" = "3298534883328"
);
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
