[Presto] Data type

Boolean

• BOOLEAN

---

Integer

• TINYINT : 8bit
• SMALLINT : 16bit
• INTEGER : 32bit
• BIGINT : 64bit

---

Floating-Point

• REAL : 32bit
• DOUBLE : 64bit

---

Fixed-Precision

• DECIMAL : 최대 38자리까지 지원하지만, 최대 18자리일 때 성능이 가장 좋음

---

String

• VARCHAR : 가변길이 문자 데이터
• CHAR : 고정길이 문자 데이터
• VARBINARY : 가변길이 이진 데이터
• JSON : true, false, null

---

Date and Time

• DATE : 'yyyy-mm-dd'
• TIME : 'hh:mm:ss.ms'
• TIME WITH TIME ZONE : 'hh:mm:ss.ms country/local
• TIMESTAMP : 'yyyy-mm-dd hh:mm:ss.ms'
• TIMESTAMP WITH TIME ZONE : 'yyyy-mm-dd hh:mm:ss.ms country/local'
• INTERVAL YEAR TO MONTH 
• INTERVAL DAY TO SECOND

---

Structural

• ARRAY : ARRAY[1, 2, 3]
• MAP : MAP(ARRAY['A', 'B'], ARRAY[1, 2]
• ROW : CAST(ROW(1, 2.0) AS ROW(X BIGINT, Y DOUBLE))

---

Network Address

• IPADDRESS
• IPPREFIX

---

HyperLogLog

• HyperLogLog

---

KHyperLogLog

• KHyperLogLog

---

Qiantile Digest

• QDigest