Groups
Groups
Sign in
Groups
Groups
ClickHouse: https://clickhouse.com/slack
Conversations
Labels
About
Send feedback
Help
Decimal data type
400 views
Skip to first unread message
Vitalijus Vidinevicius
unread,
Jun 17, 2016, 10:26:51 AM
6/17/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to ClickHouse
Hello,
does ClickHouse support a decimal(x,y) datatype? If not, are there any plans to add it?
man...@gmail.com
unread,
Jun 17, 2016, 5:38:57 PM
6/17/16
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to ClickHouse
ClickHouse currently doesn't support decimal data type.
It is recommended to store money in (for example) millionths parts of currency unit in Int64 type.
It is like NUMERIC/DECIMAL types, but you need to divide or multiply by
1000000
.
Reply all
Reply to author
Forward
0 new messages