this SQL file is used for creating a hive table to load the data from the HDFS directory

post39.sql

create table post39 (
id int,
name string,
gender string
)
row format delimited 
fields terminated by ','
stored as textfile;