Hi What's the error message?
if you get "FAILED: SemanticException [Error 10072]: Database does not exist: PROCESS" then run create schema if not exists process; After that the DDL is accepted just fine on my hive-0.13.1-cdh5.3.0. hth GB On 4/24/2015 12:25 PM, Bhagwan S. Soni wrote:
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.
-- The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.