[Hive基础]-- 查看hive 表在hdfs上的存储路径

原创

high2011 2022-11-03 14:19:44 博主文章分类：Hive ©著作权

文章标签 hive hdfs 数据库 apache 文章分类 虚拟化云计算

©著作权归作者所有：来自51CTO博客作者high2011的原创作品，请联系作者获取转载授权，否则将追究法律责任

1、执行hive，进入hive窗口

2、执行show databases,查看所有的database;

3、执行use origin_ennenergy_onecard; 则使用origin_ennenergy_onecard数据库

4、执行show create table M_BD_T_GAS_ORDER_INFO_H;则可以查看table在hdfs上的存储路径

如下：

hive (origin_ennenergy_onecard)> show create table M_BD_T_GAS_ORDER_INFO_H;

OK
CREATE TABLE `M_BD_T_GAS_ORDER_INFO_H`(
`fguid` string,
`fstationno` string,
`fstationname` string,
`fgunno` int,
`fserialno` int,
`fgas` double,
`fprice` double,
`fmoney` double,
`fsumgas` double,
`ftradedatetime` date,
`fstopdatetime` date,
`fsavedatetime` date,
`ffueltype` string,
`recorddate` date)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://mycluster/user/hive/warehouse/origin_ennenergy_onecard.db/m_bd_t_gas_order_info_h' -----标红部分为hdfs的路径
TBLPROPERTIES (
'COLUMN_STATS_ACCURATE'='true',
'numFiles'='6',
'numRows'='3546198',
'rawDataSize'='435279808',
'totalSize'='438826006',
'transient_lastDdlTime'='1468831756')
Time taken: 0.279 seconds, Fetched: 30 row(s)