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
28 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
• 67,600 points
533 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
• 67,600 points
530 views
+1 vote
1 answer

Unable to create external table on HIVE

Hi @Ozer. The LOCATION is used to specify the ...READ MORE

answered Oct 14 in Big Data Hadoop by Kiran
63 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
• 67,600 points
1,586 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,690 points
3,055 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,690 points
341 views
0 votes
10 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
15,017 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,260 points
1,118 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,550 points
183 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
• 67,600 points
2,415 views