hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Valluri, Sathish" <>
Subject Hive unwanted location directory
Date Thu, 06 Mar 2014 14:12:15 GMT
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
LOCATION '/testdata/';


Sathish Valluri

View raw message