在几个数据库中提取需要的数据
服务器:A ,localhost,mysql
用户名:user1 密码user1
服务器:B,192.168.1.2:10000,hive--》result--》tabl1
用户名:user2 密码 user2
客户端dbeaver
问题相关代码,请勿粘贴截图
create table a_gsa(imsi varchar(20) default null)engine = federated connection = 'hive://user2:user2@192.168.1.2:10000/result/tabl1';
运行结果及报错内容
[2022-05-17 17:27:54] 已连接
vonr_event_list> use vonr_event_list
[2022-05-17 17:27:54] 在 10 ms 内完成
vonr_event_list> create table a_gsa(imsi varchar(20) default null)engine = federated connection = 'hive://user2:user2@192.168.1.2:10000/result/tabl1'
[2022-05-17 17:27:54] [HY000][1432] Can't create federated table. The data source connection string 'hive://user2:user2@192.168.1.2:10000/result/tabl1'' is not in the correct format
[2022-05-17 17:27:54] [HY000][1432] Can't create federated table. The data source connection string 'hive://user2:user2@192.168.1.2:10000/result/tabl1'' is not in the correct format
[2022-05-17 17:27:54] [HY000][1030] Got error 1432 from storage engine
我的解答思路和尝试过的方法
我想要达到的结果
如何 把远程hive库中的相关数据映射到本地mysql中进行查询