Some ideas to get u started
CREATE EXTERNAL TABLE IF NOT EXISTS names(fullname STRING,address
STRING,phone STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
CREATE EXTERNAL TABLE IF NOT EXISTS names_detail(id BIGINT, fullname
STRING,address STRING,gender STRING, phone STRING) ROW FORMAT DE
yeah. database design is always subjective so everybody has an opinion
about it. but if you're just starting out i would recommend you kinda
follow the rules as you would in a traditional relational database system.
so two different datasets would mean two different tables in both Hive and
an Rdb d