title: what's the best practice to create an external hive table based on a csv file on HDFS with 618 columns in header?
body: <p>This question is different than what I have found on stackoverflow due to the size of data, it is NOT duplicated.</p>
  
  <p>We are using Cloudera.</p>
  
  <p>I have seen solution for small xlsx files with only handful columns in header, in my case the csv file to be loaded into a new hive table has 618 columns. </p>
  
  <ol>
  <li><p>Would it be saved as parquet by default if I upload it (save it to csv first) through HUE-> File Browser? if not, where can I specify the file format?</p></li>
  <li><p>What would be the best way to create an external Impala table based on that location? It would definitely be unbelievable if I need to create the DDL/schema manually as there are so many columns.</p></li>
  </ol>
  
  <p>Thank you very much.</p>