reading data from s3

[Hitesh Goyal]

Hi team,
I want to read the text file from s3. I am doing it using DataFrame. Like 
below:-
DataFrame d=sql.read().text("s3://my_first_text_file.txt");
              d.registerTempTable("table1");
              DataFrame d1=sql.sql("Select * from table1");
              d1.printSchema();
              d1.show();

But it is not registering the text file as a temp table so that I  can make SQL 
 queries on that. Can't I do this on a text file ?? Or if I can, suggest any 
way to do.
Like if I try to do it by JSON file, it is successful.

Regards,
Hitesh Goyal
Simpli5d Technologies
Cont No.: 9996588220