有时候我们需要查看Hive表对应文件的文件大小,那么分两步:
- 知道Hive表在HDFS中的存储位置;
- 查看Hive表对应的文件大小。
1. 知道Hive表在HDFS中的存储位置
使用show create table tableName来查看:
0: jdbc:hive2://nfjd-hadoop02-node46.jpushoa.> show create table tmp.cdl_push_r;
INFO : Compiling command(queryId=hive_20191108203838_0355393e-9a92-44d3-a0c4-bf52cabcfa4b): show create table tmp.cdl_push_r
INFO : UserName: chendl
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string, comment:from deserializer)], properties:null)
INFO : Completed compiling command(queryId=hive_20191108203838_0355393e-9a92-44d3-a0c4-bf52cabcfa4b); Time taken: 0.398 seconds
INFO : Executing command(queryId=hive_20191108203838_0355393e-9a92-44d3-a0c4-bf52cabcfa4b): show create table tmp.cdl_push_r
INFO : Starting task [Stage-0:DDL] in serial mode
Original: https://blog.csdn.net/u010438126/article/details/127404080
Author: 奋进的码哥
Title: 查找hive表的存储位置并查看表文件大小及分区文件名
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/817700/
转载文章受原作者版权保护。转载请注明原作者出处!