I want to change my external table storage format from text file to ORC file. I already added partitions around 500 for the external table stored as 'TEXTFILE'. If I simply create another external table with 'ORC file' format, then i have to create all those partitions.
Instead Is it possible for me to change the storage format to ORC file without affecting the existing partitions for my table.