CREATE TABLE 复制表 LIKE 表;
INSERT INTO 复制表 SELECT * FROM 表;
hive:
insert into t_positions (title,spider_url)
select
p_name as title,
request_url as spider_url
from position_hbase where p_name='网站运营专员Website operation'
--limit 100 insert into ...select 不能加limit