col_name | data_type | comment | |
---|---|---|---|
1 | # col_name | data_type | comment |
2 | NULL | NULL | |
3 | 1字段name | string | |
4 | 2字段name | string | |
5 | 3字段name | string | |
6 | 字段name | string | |
7 | i字段name | string | |
8 | NULL | NULL | |
9 | # Detailed Table Information | NULL | NULL |
10 | Database: | 数据库名称 | NULL |
11 | Owner: | root | NULL |
12 | CreateTime: | 创建时间 | NULL |
13 | LastAccessTime: | UNKNOWN | NULL |
14 | Retention: | 0 | NULL |
15 | Location: | 存储位置 | NULL |
16 | Table Type: | MANAGED_TABLE | NULL |
17 | Table Parameters: | NULL | NULL |
18 | COLUMN_STATS_ACCURATE | {\"BASIC_STATS\":\"true\"} | |
19 | numFiles | 0 | |
20 | numRows | 0 | |
21 | rawDataSize | 0 | |
22 | totalSize | 0 | |
23 | transient_lastDdlTime | 1551170643 | |
24 | NULL | NULL | |
25 | # Storage Information | NULL | NULL |
26 | SerDe Library: | org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | NULL |
27 | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL |
28 | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL |
29 | Compressed: | No | NULL |
30 | Num Buckets: | -1 | NULL |
31 | Bucket Columns: | [] | NULL |
32 | Sort Columns: | [] | NULL |
33 | Storage Desc Params: | NULL | NULL |
34 | field.delim | , | |
serialization.format | , |
Storage Desc Params:
field.delim 和serialization.format 没有声明则是默认
hive 默认的字段分隔符为ascii码的控制符\001,
建表的时候用fields terminated by '\001',或者使用fields terminated by '\u0001'