Creating a New Table in HIVE

Creating a new table in HIVE



CREATE TABLE IF NOT EXISTS mydb.employee (empid int, firstname String, salary String)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

Where mydb is my database name and employee is table name.

[Error] Terminal initialization failed, falling backl to unsupported java.lang.incompatibleClassChange

While configuring Apache Hive on top of Hadoop, we may get the below error meesage: 
[Error] Terminal initialization failed, falling backl to unsupported java.lang.incompatible
ClassChange


To fix this got to "hive-config.sh" file and add below text.

export HADOOP_USER_CLASSPATH_FIRST=true

Hive: How to View Column Header with Resultset

In general, when we query in Hive, it displays result set without column names. To over come this execute below command:

execute set hive.cli.print.header=true;