Hadoop生态hive（四）数据类型

悠悠 2023-06-13 11:13 20阅读 0赞

### 一、原始类型 ###

<table> 
 <thead> 
  <tr> 
   <th>类型</th> 
   <th>描述</th> 
   <th>字面量示例</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>BOOLEAN</td> 
   <td>true/false</td> 
   <td>TRUE</td> 
  </tr> 
  <tr> 
   <td>TINYINT</td> 
   <td>1字节的有符号整数 -128~127</td> 
   <td>10</td> 
  </tr> 
  <tr> 
   <td>MALLINT</td> 
   <td>2个字节的有符号整数，-32768~32767</td> 
   <td>20000</td> 
  </tr> 
  <tr> 
   <td>INT</td> 
   <td>4个字节的带符号整数</td> 
   <td>1000000</td> 
  </tr> 
  <tr> 
   <td>BIGINT</td> 
   <td>8字节带符号整数</td> 
   <td>13L</td> 
  </tr> 
  <tr> 
   <td>FLOAT</td> 
   <td>4字节单精度浮点数</td> 
   <td>2.1</td> 
  </tr> 
  <tr> 
   <td>DOUBLE</td> 
   <td>8字节双精度浮点数</td> 
   <td>3.2</td> 
  </tr> 
  <tr> 
   <td>DEICIMAL</td> 
   <td>任意精度的带符号小数</td> 
   <td>1.23</td> 
  </tr> 
  <tr> 
   <td>STRING</td> 
   <td>字符串，变长</td> 
   <td>“123”,’123’</td> 
  </tr> 
  <tr> 
   <td>VARCHAR</td> 
   <td>变长字符串</td> 
   <td>“123”,’123’</td> 
  </tr> 
  <tr> 
   <td>CHAR</td> 
   <td>固定长度字符串</td> 
   <td>“123”,’123’</td> 
  </tr> 
  <tr> 
   <td>BINARY</td> 
   <td>字节数组 无法表示</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>TIMESTAMP</td> 
   <td>时间戳，毫秒值精度</td> 
   <td>1573897649000</td> 
  </tr> 
  <tr> 
   <td>DATE</td> 
   <td>日期</td> 
   <td>‘2019-11-16’</td> 
  </tr> 
  <tr> 
   <td>INTERVAL</td> 
   <td>时间频率间隔</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

### 二、复杂类型 ###

<table> 
 <thead> 
  <tr> 
   <th>类型</th> 
   <th>描述</th> 
   <th>字面量示例</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ARRAY</td> 
   <td>有序的的同类型的集合</td> 
   <td>array(0,1,2,3)</td> 
  </tr> 
  <tr> 
   <td>MAP</td> 
   <td>key-value,key必须为原始类型，value可以任意类型</td> 
   <td>map(‘zb’,1,’cz’,23)</td> 
  </tr> 
  <tr> 
   <td>STRUCT</td> 
   <td>字段集合,类型可以不同</td> 
   <td>struct(‘Dins’,12,13443.0),named_stract(‘name’,’Jon’,’age’,40,’money’,12332.0)</td> 
  </tr> 
  <tr> 
   <td>UNION</td> 
   <td>在有限取值范围内的一个值</td> 
   <td>create_union(0,’zz’,2)</td> 
  </tr> 
 </tbody> 
</table>