I have a super large json file and I have created an external hive table to read the file which is partitioned by date and hour. However, I ran into out-of-memory error when pulling out data for just one day.  For now the output is stored in the text format. I learnt that I should convert it into ORC file.   INSERT OVERWRITE TABLE table_name_orc SELECT * FROM table_name   But in the code snippet above, SELECT * FROM table_name  does not work because I could not extract everything out of the external table due to the memory issue. Any help would be appreciated! ... View more