Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Document CHAR type

...

Misc Types

  • BOOLEAN
  • BINARY (Note: Only available starting with Hive 0.8.0)

...

Info
titleVersion

Varchar datatype was introduced in Hive 0.12.0 (HIVE-4844).

Char

Anchor
char
char

Char types are similar to Varchar but they are fixed-length meaning that values shorter than the specified length value are padded with spaces but trailing spaces are not important during comparisons. The maximum length is fixed at 255.

Code Block
sql
sql

CREATE TABLE foo (bar CHAR(10))

Timestamps

Anchor
timestamp
timestamp

...