How Can I store the Hive query result in one file ?

[Matouk IFTISSEN]

Hello Hive users,
Is there a manner to store the Hive  query result (SELECT *.....) in a
specfique and alone file (given the file name) like (INSERT OVERWRITE LOCAL
DIRECTORY '/directory_path_name/')?
Thanks for your answers