內部表又稱為管理表。 <br/> **內部表的特點：** <mark>1. 在hive中刪除了內部表，存儲在HDFS上的數據和該表存儲在mysql中對應的元數據一同被刪除。</mark> <mark>2. 對內部表的任何更改都會對存儲在hdfs上的數據和存儲在mysql中的元數據產生影響。 <br/> **創建 empt內部表** ```sql create table if not exists empt( empt_id int comment "empt ID", empt_name string comment "empt name" ) comment "empt table" stored as textfile -- /home/hadoop/hive/warehouse/hivebook.db/要求已存在，empt為表名 location "/home/hadoop/hive/warehouse/hivebook.db/empt" ; ``` **查看建表信息** ```shell 0: jdbc:hive2://hadoop101:10000> show create table empt; +----------------------------------------------------+--+ | createtab_stmt | +----------------------------------------------------+--+ | CREATE TABLE `empt`( | | `empt_id` int COMMENT 'empt ID', | | `empt_name` string COMMENT 'empt name') | | COMMENT 'empt table' | | ROW FORMAT SERDE | | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | | STORED AS INPUTFORMAT | | 'org.apache.hadoop.mapred.TextInputFormat' | | OUTPUTFORMAT | | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | | LOCATION | | 'hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db/empt' | | TBLPROPERTIES ( | | 'transient_lastDdlTime'='1607494285') | +----------------------------------------------------+--+ ``` **查看表類型** ``` 0: jdbc:hive2://hadoop101:10000> desc formatted empt; +-------------------------------+----------------------------------------------------+-----------------------+--+ | col_name | data_type | comment | +-------------------------------+----------------------------------------------------+-----------------------+--+ | # col_name | data_type | comment | | | NULL | NULL | | empt_id | int | empt ID | | empt_name | string | empt name | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | hivebook | NULL | | Owner: | root | NULL | | CreateTime: | Wed Dec 09 14:11:25 CST 2020 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Protect Mode: | None | NULL | | Retention: | 0 | NULL | | Location: | hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db/empt | NULL | | Table Type: | MANAGED_TABLE | NULL | | Table Parameters: | NULL | NULL | | | comment | empt table | | | transient_lastDdlTime | 1607494285 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | -1 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | | Storage Desc Params: | NULL | NULL | | | serialization.format | 1 | +-------------------------------+----------------------------------------------------+-----------------------+--+ ```