Re: using hive with multiple schemas

2013-08-21 Thread Sanjay Subramanian
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

Re: using hive with multiple schemas

2013-08-21 Thread Stephen Sprague
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