I had question to write hive script to produce report. But location/file_name details were missing for the report.
Question: Create hive sql script file to create report (given cols and table details). All columns must be tab separated.
I wrote query to export report on HDFS location .
Insert overwrite directory ‘solution’ fields terminated by ‘\t’ select * from tab.
In test result I got Incorrect solution SQL comment.
What is the correct answer for this question?