there is no syntax error, everything is in place which is required for this query. When I'm executing this statement it won't make any progress. some time it takes vary long time to complete it and sometime it just got hanged for undefined time.
On Fri, Apr 24, 2015 at 10:10 PM, gabriel balan <gabriel.ba...@oracle.com> wrote: > 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. > >
