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.
Our use case needs many temporary tables needs to be created dynamically and we
are creating many unwanted dummy directories if the data not present on the
HDFS.
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
