title: create a hive table without specifying the column names and column types
body: <p>I have huge dataset with 1000 columns stored on HDFS. I want to create a hive table to filter and work on the data. </p>
  
  <pre><code>CREATE EXTERNAL TABLE IF NOT EXISTS tablename(
       var1 INT,var2 STRING, var2  STRING)
       COMMENT 'testbykasa'
       ROW FORMAT DELIMITED
       FIELDS TERMINATED BY ','
       STORED AS TEXTFILE
       LOCATION '/folder1/';
  </code></pre>
  
  <p>For smaller no. of columns(~ 5-10), I manually specify the column name and column type. Is there a way to get hive create the table by inferring the column name and datatype, without manually specifying it.  </p>