In Hive, you can create a table using the STORED AS clause to specify the file format in which the table data will be stored. Here are the steps to create a table using the STORED AS clause in Hive:
you could store the table data in ORC format by specifying STORED AS ORC.
In case you try to load the table(order_items), you will receive an error as it does not match the the File format of the destination table
