create statement is not working

[Bhagwan S. Soni]

Hi Hive Users,


I'm using Hive's 13th Cloudera version.
I'm facing an issue while running any of the create statement. Other
operations like DML and drop, alter are working fine. below is the sample
statement which i'm trying to run

CREATE EXTERNAL TABLE IF NOT EXISTS PROCESS.aggregated_rspns
(
id int,
dt string,
hour string,
rspns_count bigint,
highest_rspns_count bigint
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\001'
LOCATION '/xyz/pqr/aggregated_rspns';

Could someone help me resolve this issue.
Please let me know if any further information required.