![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 169 阅读 · 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 · 771 阅读 · 0 评论 -
Hive中实现数据增量累加主键覆盖的sql
insert overwrite table full_data_table selectddd.data_colfrom( select aa.data_col from full_data_table aaleft join( select b.pk_col as pk_id from full_data_table a left join inc_data_tabl...原创 2019-12-12 09:16:09 · 915 阅读 · 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 · 128 阅读 · 0 评论 -
如何使用sqoop导入avro file到hive中
1,使用sqoop命令,--as-avrodatafile参数从mysql,表t_movie导入hdfs,编辑命令[root@cdh-demo ~]# cat import_avro.txtimport--connectjdbc:mysql://cdh-demo:3306/mytest--usernamekobezhu--passwordkobezhu--tablet_mo...原创 2019-11-09 10:26:42 · 655 阅读 · 0 评论