show create table warehouse;
+----------------------------------------------------+
| createtab_stmt |
+----------------------------------------------------+
| CREATE EXTERNAL TABLE `warehouse`( |
| `w_warehouse_sk` bigint, |
| `w_warehouse_id` char(16), |
| `w_warehouse_name` varchar(20), |
| `w_warehouse_sq_ft` int, |
| `w_street_number` char(10), |
| `w_street_name` varchar(60), |
| `w_street_type` char(15), |
| `w_suite_number` char(10), |
| `w_city` varchar(60), |
| `w_county` varchar(30), |
| `w_state` char(2), |
| `w_zip` char(10), |
| `w_country` varchar(20), |
| `w_gmt_offset` decimal(5,2)) |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' |
| WITH SERDEPROPERTIES ( |
| 'field.delim'='|', |
| 'serialization.format'='|') |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.mapred.TextInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' |
| LOCATION |
| 'hdfs://mycluster/data/tpcds/2/warehouse' |
| TBLPROPERTIES ( |
| 'bucketing_version'='2', |
| 'serialization.null.format'='', |
| 'transient_lastDdlTime'='1616470752') |
+----------------------------------------------------+
网友评论