HIVE
鱼干片
这个作者很懒,什么都没留下…
展开
-
Hive中创建映射Hbase表
######To create hive table mapping hbase table### create external table hbase_test_mysql_general( rowkey string ,id bigint ,current_d string ,current_t string ,current_dt string ,current_z string ,id1...原创 2020-03-02 11:22:11 · 162 阅读 · 0 评论 -
sqoop导入hive表时,去除列中的tab键回车键等
sqoop import --connect jdbc:oracle:thin:@10.100.100.1:1521/orcl --username oracle --passowrd oracle --query "select * from oracle.sample where \$CONDITIONS and start_date < to_date('1999-10-31','yy...原创 2020-01-21 10:26:20 · 744 阅读 · 0 评论 -
Hive中实现数据增量累加主键覆盖的sql
insert overwrite table full_data_table select ddd.data_col from ( select aa.data_col from full_data_table aa left join ( select b.pk_col as pk_id from full_data_table a left join inc_data_tabl...原创 2019-12-12 09:16:09 · 899 阅读 · 0 评论 -
Installing the Teradata Connector with CDH5
1. Install the Sqoop connector by opening the distribution archive in a convenient location such as /usr/lib. Opening the distribution creates a directory that contains the jar file of the compiled...原创 2019-12-10 11:33:05 · 117 阅读 · 0 评论 -
如何使用sqoop导入avro file到hive中
1,使用sqoop命令,--as-avrodatafile参数从mysql,表t_movie导入hdfs,编辑命令 [root@cdh-demo ~]# cat import_avro.txt import --connect jdbc:mysql://cdh-demo:3306/mytest --username kobezhu --password kobezhu --table t_mo...原创 2019-11-09 10:26:42 · 641 阅读 · 0 评论