ElasticSearch SQL 数据类型

àì夳堔傛蜴生んèń 2022-04-24 19:28 217阅读 0赞

# ElasticSearch SQL 数据类型 #

<table> 
 <thead> 
 <tr> 
 <th style="text-align:center;"> ElasticSearch类型 </th> 
 <th style="text-align:center;"> ElasticSearch sql 类型 </th> 
 <th style="text-align:center;"> sql 类型 </th> 
 <th style="text-align:center;"> SQL精度 </th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td colspan="4" style="text-align:center;vertical-align:middle;"> 核心数据类型 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/null-value.html" rel="nofollow"><code>null</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>null</code> </td> 
 <td style="text-align:center;vertical-align:top;"> NU LL </td> 
 <td style="text-align:center;vertical-align:top;"> 0 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/boolean.html" rel="nofollow"><code>boolean</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>boolean</code> </td> 
 <td style="text-align:center;vertical-align:top;"> BOOLEAN </td> 
 <td style="text-align:center;vertical-align:top;"> 1 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>byte</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>byte</code> </td> 
 <td style="text-align:center;vertical-align:top;"> TINYINT </td> 
 <td style="text-align:center;vertical-align:top;"> 3 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>short</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>short</code> </td> 
 <td style="text-align:center;vertical-align:top;"> SMALLINT </td> 
 <td style="text-align:center;vertical-align:top;"> 5 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>integer</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>integer</code> </td> 
 <td style="text-align:center;vertical-align:top;"> INTEGER </td> 
 <td style="text-align:center;vertical-align:top;"> 10 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>long</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>long</code> </td> 
 <td style="text-align:center;vertical-align:top;"> BIGINT </td> 
 <td style="text-align:center;vertical-align:top;"> 19 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>double</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>double</code> </td> 
 <td style="text-align:center;vertical-align:top;"> DOUBLE </td> 
 <td style="text-align:center;vertical-align:top;"> 15 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>float</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>float</code> </td> 
 <td style="text-align:center;vertical-align:top;"> REAL </td> 
 <td style="text-align:center;vertical-align:top;"> 7 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>half_float</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>half_float</code> </td> 
 <td style="text-align:center;vertical-align:top;"> FLOAT </td> 
 <td style="text-align:center;vertical-align:top;"> 16 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/number.html" rel="nofollow"><code>scaled_float</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>scaled_float</code> </td> 
 <td style="text-align:center;vertical-align:top;"> FLOAT </td> 
 <td style="text-align:center;vertical-align:top;"> 19 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/keyword.html" rel="nofollow"><code>keyword</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>keyword</code> </td> 
 <td style="text-align:center;vertical-align:top;"> VARCHAR </td> 
 <td style="text-align:center;vertical-align:top;"> based on&nbsp;ignore_above </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/text.html" rel="nofollow"><code>text</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>text</code> </td> 
 <td style="text-align:center;vertical-align:top;"> VARCHAR </td> 
 <td style="text-align:center;vertical-align:top;"> 2,147,483,647 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/binary.html" rel="nofollow"><code>binary</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>binary</code> </td> 
 <td style="text-align:center;vertical-align:top;"> VARBINARY </td> 
 <td style="text-align:center;vertical-align:top;"> 2,147,483,647 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/date.html" rel="nofollow"><code>date</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>datetime</code> </td> 
 <td style="text-align:center;vertical-align:top;"> TIMESTAMP </td> 
 <td style="text-align:center;vertical-align:top;"> 29 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/ip.html" rel="nofollow"><code>ip</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>ip</code> </td> 
 <td style="text-align:center;vertical-align:top;"> VARCHAR </td> 
 <td style="text-align:center;vertical-align:top;"> 39 </td> 
 </tr> 
 <tr> 
 <td colspan="4" style="text-align:center;vertical-align:top;"> 复合数据类型 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/object.html" rel="nofollow"><code>object</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>object</code> </td> 
 <td style="text-align:center;vertical-align:top;"> STRUCT </td> 
 <td style="text-align:center;vertical-align:top;"> 0 </td> 
 </tr> 
 <tr> 
 <td style="text-align:center;vertical-align:top;"> <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.7/nested.html" rel="nofollow"><code>nested</code></a> </td> 
 <td style="text-align:center;vertical-align:top;"> <code>nested</code> </td> 
 <td style="text-align:center;vertical-align:top;"> STRUCT </td> 
 <td style="text-align:center;vertical-align:top;"> 0 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td colspan="3">ElasticSearch特有SQL类型</td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>date</code> </td> 
 <td style="vertical-align:top;"> 29 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_year</code> </td> 
 <td style="vertical-align:top;"> 7 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_month</code> </td> 
 <td style="vertical-align:top;"> 7 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_day</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_hour</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_minute</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_second</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_year_to_month</code> </td> 
 <td style="vertical-align:top;"> 7 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_day_to_hour</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_day_to_minute</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_day_to_second</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_hour_to_minute</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_hour_to_second</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td style="vertical-align:top;"> <code>interval_minute_to_second</code> </td> 
 <td style="vertical-align:top;"> 23 </td> 
 </tr> 
 </tbody> 
</table>

对人工智能感兴趣的同学，可以点击以下链接：

[现在人工智能非常火爆，很多朋友都想学，但是一般的教程都是为博硕生准备的，太难看懂了。最近发现了一个非常适合小白入门的教程，不仅通俗易懂而且还很风趣幽默。所以忍不住分享一下给大家。点这里可以跳转到教程。][Link 1]

[https://www.cbedai.net/u014646662][Link 1]

[Link 1]: https://www.cbedai.net/u014646662