Dear Indrajit,

Hope you are doing well.

Please confirm are you using edureka VM?

If you are using edureka VM:

1. First you have to copy the attached hive-site.xml to the bin folder of spark-1.5.2 and to the bin folder of hive.

2. Open the terminal:

My dataset:

kamini,mishra


Commands:

 ==> hive

==> CREATE TABLE IF NOT EXISTS Mycus (name String, lastname String) row format delimited fields terminated by ',';

==>LOAD DATA local INPATH '/home/edureka/Desktop/input' INTO TABLE Mycus;

==> quit;

==> spark-shell

==>sqlContext.sql("select * from Mycus").foreach(println)




Please try once and let us know if you face any issue.