This looks like an Hive issue to me, Can anyone suggest other ways to overcome this.

[valluri sathish <va...@yahoo.com.INVALID>]

We are creating external
table in Hive and if the location path is not present in the HDFS say
/testdata(as shown below), Hive is creating the ‘/testdata’ dummy folder.
Is there any option in hive
or any way to stop creating dummy directories if the location folder not
exists.
So we end up  creating
many unwanted dummy directories if the data not present on the HDFS for many
partitions we add after creating table.
 
CREATE EXTERNAL TABLE
testTable ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' WITH
SERDEPROPERTIES ('avro.schema.literal'='{ <schema json literal>') STORED
AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' LOCATION '/testdata/';
 
Regards
Sathish Valluri