1.表數(shù)據(jù)備份 "備份到備份表中，執(zhí)行以下操作，其中nginx_log_info_20180724 為備份表

create table nginx_log_info_20180724 as select * from nginx_log_info;

2.查看表結(jié)構(gòu) "1.show create table 表名；

3.describe 表名

4.---查詢分區(qū)字段：? show partitions pdm.trd_ta_dividend;

hive添加數(shù)據(jù) INSERT INTO flt_ip_agency_hbs(key,sk_agency,agencyno,agency_name) VALUES ("20201105_135991","135991","000","諸菏酒類包裝廠")

5.數(shù)據(jù)量大的時候在root下運行，統(tǒng)計記錄數(shù)（適用于千萬級數(shù)據(jù)量，利用了hbase jar中自帶的統(tǒng)計行數(shù)的工具類） hbase org.apache.hadoop.hbase.mapreduce.RowCounter 'flt_ass_cust_fundbal_hbs'

6.從Ａ查詢數(shù)據(jù)寫入到Ｂ表 "１.insert into? pub.flt_agrm_tradeacco_reg (bk_fundaccount,bk_tradeaccount ) SELECT bk_fundaccount,bk_tradeaccount? FROM pub.flt_agrm_tradeacco_reg001 limit 10;

7.insert into pub.flt_agrm_tradeacco_reg　select * from? pub.flt_agrm_tradeacco_reg001;"

8.查詢分區(qū)字段 show partitions pdm.trd_ta_dividend;

9.hive環(huán)境認證 kinit -k -t /etc/hive.keytab hive

10.導(dǎo)出數(shù)據(jù) hive -e "select? bk_fundaccount,sk_invpty_of_cust,bk_invpty_of_cust from pub.flt_agrm_fundaccount"? > /tmp/flt_agrm_fundaccount.txt ；

11.在hive上建一張外部表 "

create external table if not exists fun_user_external (

? ? tid INT,

? ? userid STRING,

? ? pwd STRING,

? ? create_time BIGINT,

? ? email STRING

) ROW FORMAT DELIMITED FIELDS TERMINATED BY '`' STORED AS TEXTFILE"