The issue is resolved by adding Stored as textfile in the table creation query. CREATE External TABLE GeoIP2_ISP_Blocks_IPv4 ( Client string, ID int, Number int, Name string, ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' Stored as textfile    <---------------------- this new line needs to be added WITH SERDEPROPERTIES ( "separatorChar" = "\,", "quoteChar" = "\"" ) LOCATION 'hdfs:///user/hive/warehouse/tips/' tblproperties ("skip.header.line.count"="1");   Cloudera has changed the default file format from txt to parquet. So we need to specify this line for text files.   Thanks @mszurap  for the help.   ... View more