To be more specific, it happens occasionally . On Fri, Apr 24, 2015 at 10:59 PM, Bhagwan S. Soni <bhgwnsson...@gmail.com> wrote:
> 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. >> >> >
