有没有使用broker_load把hive的数据导入到doris的案例?

提问者:帅平 问题分类:大数据
有没有使用broker_load把hive的数据导入到doris的案例?
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属地:四川省
我来回答