Report question in Cloudera data analyst certification exam

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?


Practice hive on state of the art Big Data cluster - https://labs.itversity.com
You can sign up for our courses on Udemy using $10 coupons - Udemy Coupons - Big Data Courses