1 个回答
示例如下:
LOAD LABEL 2024_12_25_broad_1 (
DATA INFILE ( "hdfs://bigdata01:8020/user/hive/warehouse/sdgh_dwd.db/dwd_uc_login_log/dt=2024-12-25/*" ) INTO TABLE dwd_uc_login_log COLUMNS TERMINATED BY "`" FORMAT AS "orc" (
corp_code,
create_time,
user_id,
login_log_id,
session_id,
login_name,
user_name,
logout_time,
create_by,
last_modify_time,
last_modify_by,
login_time,
login_ip,
real_logout,
status,
opt_time,
logout_type,
except_user,
login_type
) COLUMNS
FROM
PATH AS ( dt )
SET (
dt_time = str_to_date( dt, '%Y-%m-%d' ))
) WITH BROKER broker_name ( "username" = "hdfs", "password" = "hdfs" ) PROPERTIES ( "timeout" = "18000", "max_filter_ratio" = "0.1", "exec_mem_limit" = "2147483648" );
发布于:4个月前 (12-26) IP属地:四川省
我来回答
您需要 登录 后回答此问题!