Problem Scenario 29:  You have been given below patient data information in a file called patient.csv

First Name|Last Name|Address|Mobile|Phone|ZipCode
Amit|Jain|A-646, Cheru Nagar, Chennai|999999999|98989898|600020
Sumit|Saxena|D-100, Connaught Place, Delhi|1111111111|82828282|110001
Ajit|Chaube|M-101, Dwarka puri, Jaipur|2222222222|32323232|302016
Ramu|Mishra|P-101,Ahiyapur, Patna|4444444444|12121212|801108

Please accomplish following activities
1. Load this csv file in hdfs. 
2. Create database in Hive named as "PatientInfo"
3. Create a Hive table in following format name PatientDetail

Name < First Name, Last Name>
Address< HouseNo, LocalityName, City, Zip>
Phone < Mobile,Landline>

4. Make sure hive table store data in a Sequence File format.
5. Location of data , file created should be 
/user/hive/warehouse/patient/
 

cca159problemscenario29_Screen_Stream.avi



http://www.hadoopexam.com/Cloudera_Certification/CCPDE575/CCP_DE575_Hadoop_Cloudera_Data_Enginer_Questions_Dumps_Practice_Test.html

ApacheSpark Interview Questions

·         Apache Spark InterviewQuestions-1

·         Apache Spark Interview Questions-2

·         Apache Spark Interview Questions-3

·         Apache Spark Interview Questions-4

·         Apache Spark Interview Questions-5

·         Apache Spark Interview Questions-6 

          Apache Spark Interview Questions-7


http://www.hadoopexam.com/cloudera_certification/cca175/cca_175_hadoop_cloudera_spark_certification_questions_dumps_practice_test.html