在hive环境下输入以下命令:
hive> show create table ecej_md_company;
OK
CREATE TABLE `md_company`(
`company_id` int,
`update_user` int,
`merchant_id` string,
`company_attribute` tinyint)
COMMENT 'Imported by sqoop on 2018/07/03 15:58:44'
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'field.delim'='\t',
'line.delim'='\n',
'serialization.format'='\t')
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://auth.ai.ecej.com:8020/data/var/hive/warehouse/ecejservice.db/ecej_md_company'
TBLPROPERTIES (
'COLUMN_STATS_ACCURATE'='true',
'numFiles'='1',
'totalSize'='210138',
'transient_lastDdlTime'='1530604728')
Time taken: 0.154 seconds, Fetched: 59 row(s)
hive>
在结果中可以看到LOCATOIN,就是hive在hdfs中的存储目录。