@ARVINDR ,   Yes, this is a default behaviour in Hive. When an empty value ( '' ) is passed for STRING datatype, it is taken as it is.    If you would like the null values for STRING to be treated as NULL instead of just empty, you can set this property - serialization.null.format for the table of your choice. For example, you can do this on a new table or to an existing table by running a statement like the below,    New Table: CREATE TABLE null_test_1 (service1end string, service1start string, service2end string, service2start string, firstlinemaintcost double) TBLPROPERTIES ( 'serialization.null.format'=''); Existing Table: alter table null_test set tblproperties ('serialization.null.format'='');  Once done, the empty values inserted for the columns with STRING datatype will be shown as NULL.    Hope this helps! ... View more

Hello,  Did you try performing this with the help of Hive queries which I think would be possible?   1. CREATE a new empty table with the columns with correct datatypes as per the requirement (meaning the final file's column structure) 2. INSERT data into this new table with a SELECT query with JOIN to join the data from both the views.  3. You will have the files present in the table's HDFS directory. This would be your final file.   Thanks! ... View more

Can you check if the short-circuit read is configured as per the Documentation HERE ? ... View more