hive框架处理数据结果保存

方法一：执行完语句后将结果存放到本地

1：hive> insert overwrite local directory "存放结果目录"
2：    > row format delimited fields terminated by "\t"     
3：    > select from group by where  order by limit ;

2：存放结果时以什么方式分割数据

方法二：执行完语句后将结果存放到HDFS

hive> insert overwrite directory "/datas/tmp"、
    > row format delimited fields terminated by "\t"
    > select from group by where  order by limit ;
    

方法三：结果存放到Hive新表中

hive> create table 新建表 
    > as
    >  select from group by where  order by limit ;

方法四：结果存放到已经有的Hive表中

hive> insert into table 已经有的表
    > select from group by where  order by limit ;

方法五：使用hdfs直接导出表

首先、先找到要导出的表存放到哪个目录下：

show create table tb_word;
OK
CREATE TABLE `tb_word`(
  `word` string, 
  `count` int)
ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY '\t' 
  LINES TERMINATED BY '\n' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'hdfs://bigdata-hpsk01.huadian.com:8020/user/hive/warehouse/tb_word'
TBLPROPERTIES (
  'COLUMN_STATS_ACCURATE'='false', 
  'numFiles'='1', 
  'numRows'='-1', 
  'rawDataSize'='-1', 
  'totalSize'='56', 
  'transient_lastDdlTime'='1562359755')
Time taken: 0.388 seconds, Fetched: 19 row(s)

之后，使用hadoop导出到本地

hadoop dfs -get file:/user/hive/warehouse/test.db/user_login  /tmp/out/