Unable to create table in Hive

Question

Below are the statements I tried to run

Create table airports (Airport_ID int, Name string, City string, Country string, IATA_FAA varchar(3), ICAO varchar(4), latitude decimal(6,3), longitude decimal(6,3), altitude int, timezone double, DST varchar(1), timez string) row format delimited fields terminated by ",";

and 

create table nyse (Xchange String,stock_symbol String,stock_date String,stock_price_open double, stock_price_high double, stock_price_low double, stock_price_close double, stock_volume double, stock_price_adj_close double) row format delimited fields terminated by ",";

Answer 1

It is looking like your Hadoop daemons are not running. Please share with us the screenshot after executing the below commands that will help us to provide you the best possible solution:

sudo service hadoop-master restart

sudo jps

hive

Create table airports (Airport_ID int, Name string, City string, Country string, IATA_FAA varchar(3), ICAO varchar(4), latitude decimal(6,3), longitude decimal(6,3), altitude int, timezone double, DST varchar(1), timez string) row format delimited fields terminated by ",";