Question

Which of the following statement will create a column with varchar datatype?

(a) CREATE TABLE foo (bar CHAR(10))

(b) CREATE TABLE foo (bar VARCHAR(10))

(c) CREATE TABLE foo (bar CHARVARYING(10))

(d) All of the mentioned

This question was posed to me during an interview.

Question is taken from Querying Data with HiveQL topic in chapter Hive and HBase of Hadoop

Answer 1

Right option is (b) CREATE TABLE foo (bar VARCHAR(10))

Explanation: Varchar datatype was introduced in Hive 0.12.0