ClickHouse / ClickHouse/ClickHouse

Support for Mac address datatype, similar to UUID support

Open
#76,309 0 comments 1 reaction 0 assignees View on GitHub
comp-data-types external feature
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

### Company or project name

_No response_

### Use case

Analogous to [macaddr ](https://www.postgresql.org/docs/current/datatype-net-types.html#DATATYPE-MACADDR)
Store MACs (such as 'aa:bb:cc:dd:ee:ff') in 48-bit (6-byte) type instead of the 17-byte string representation.
It save space in ~ 3 times. + LowCardinality support
More compact data. More performance.

### Describe the solution you'd like

Analogous to UUID.
Alias of FixedString(6), macaddr value represented as binary.

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.