Dear Learner,Hope you are doing great.Please have a look on the below details for your reference.Create table in hive for colours in flag
CREATE EXTERNAL TABLE country_flagcolour_count(
colourname string,
colourcount int
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LOCATION '/tmp/project/country/flagcolourcount';
--Find most common colour among flags from all countries.
SELECT colourname, colourcount FROM country_flagcolour_count JOIN (SELECT max(colourcount) AS maxcolourcount FROM country_flagcolour_count) maxcount WHERE maxcount.maxcolourcount = colourcount;
If you have any further query,please let us know.
Create table in hive for colours in flag Print
Modified on: Sat, 2 Apr, 2016 at 12:54 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.