IPV4

description

IPv4 类型,以 UInt32 的形式存储在 4 个字节中,用于表示 IPv4 地址。 取值范围是 [‘0.0.0.0’, ‘255.255.255.255’]。

超出取值范围或者格式非法的输入将返回NULL

example

建表示例如下:

  1. CREATE TABLE ipv4_test (
  2. `id` int,
  3. `ip_v4` ipv4
  4. ) ENGINE=OLAP
  5. DISTRIBUTED BY HASH(`id`) BUCKETS 4
  6. PROPERTIES (
  7. "replication_allocation" = "tag.location.default: 1"
  8. );

插入数据示例:

  1. insert into ipv4_test values(1, '0.0.0.0');
  2. insert into ipv4_test values(2, '127.0.0.1');
  3. insert into ipv4_test values(3, '59.50.185.152');
  4. insert into ipv4_test values(4, '255.255.255.255');
  5. insert into ipv4_test values(5, '255.255.255.256'); // invalid data

查询数据示例:

  1. mysql> select * from ipv4_test order by id;
  2. +------+-----------------+
  3. | id | ip_v4 |
  4. +------+-----------------+
  5. | 1 | 0.0.0.0 |
  6. | 2 | 127.0.0.1 |
  7. | 3 | 59.50.185.152 |
  8. | 4 | 255.255.255.255 |
  9. | 5 | NULL |
  10. +------+-----------------+

keywords

IPV4