You should use CREATE TABLE AS SELECT (CTAS) statement to create a directory in HDFS with the files containing the results of the query. After that, you will have to export those files from HDFS to your regular disk and merge them into a single file.
You also might have to do some trickery to convert the files from '01' - delimited to CSV. You could use a custom CSV SerDe or post-process the extracted file.
You can also refer the following video for more information regarding the same: