Unable to create table in Hive

0 votes

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 ",";
Aug 6 in Big Data Hadoop by Tina
34 views

1 answer to this question.

0 votes

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 ","; 
answered Aug 6 by Yogi

Related Questions In Big Data Hadoop

0 votes
1 answer

How to create a managed table in Hive?

You can use this command: create table employee(Name ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 68,180 points
668 views
0 votes
1 answer

How to create a Hive table from sequence file stored in HDFS?

There are two SerDe for SequenceFile as ...READ MORE

answered Dec 17, 2018 in Big Data Hadoop by Omkar
• 68,180 points
697 views
+1 vote
2 answers

Unable to create external table on HIVE

Hi @Ozer, This error occurred because there is ...READ MORE

answered Nov 6 in Big Data Hadoop by Richa
173 views
0 votes
1 answer

How to save Spark dataframe as dynamic partitioned table in Hive?

Hey, you can try something like this: df.write.partitionBy('year', ...READ MORE

answered Nov 6, 2018 in Big Data Hadoop by Omkar
• 68,180 points
2,138 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,760 points
3,536 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,760 points
436 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
17,991 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,280 points
1,300 views
0 votes
1 answer

How to create smaller table from big table in HIVE?

You could probably best use Hive's built-in sampling ...READ MORE

answered Sep 24, 2018 in Big Data Hadoop by digger
• 26,600 points
237 views
0 votes
1 answer

How to create a parquet table in hive and store data in it from a hive table?

Please use the code attached below for ...READ MORE

answered Jan 28 in Big Data Hadoop by Omkar
• 68,180 points
3,655 views