Clickhouse: function for convert hex to number?

Created on 20 Jul 2018 · 5Comments · Source: ClickHouse/ClickHouse

is there a function?

question

Source

salisbury-espinosa

Most helpful comment

@salisbury-espinosa The last sentence of that article says how to convert those bytes to a number:

SELECT reinterpretAsInt64(reverse(unhex('123')))

┌─reinterpretAsInt64(reverse(unhex('123')))─┐
│                                       291 │
└───────────────────────────────────────────┘

% python
Python 2.7.6 (default, Oct 26 2016, 20:30:19)
[GCC 4.8.4] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> 0x123
291

blinkov on 24 Jul 2018

👍2

All 5 comments

See https://clickhouse.yandex/docs/en/query_language/functions/encoding_functions/#unhexstr

blinkov on 20 Jul 2018

@blinkov
unhex(str)
returns a string containing the corresponding bytes
it's not that

salisbury-espinosa on 24 Jul 2018

@salisbury-espinosa The last sentence of that article says how to convert those bytes to a number:

SELECT reinterpretAsInt64(reverse(unhex('123')))

┌─reinterpretAsInt64(reverse(unhex('123')))─┐
│                                       291 │
└───────────────────────────────────────────┘

% python
Python 2.7.6 (default, Oct 26 2016, 20:30:19)
[GCC 4.8.4] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> 0x123
291

blinkov on 24 Jul 2018

👍2

@blinkov oh, I saw this. thank you)

salisbury-espinosa on 25 Jul 2018

you're welcome

blinkov on 25 Jul 2018

Was this page helpful?

0 / 5 - 0 ratings