in my case it just appeared as a hang. I understood the problem now i want to know how i can avoid this.
On Sat, Apr 25, 2015 at 3:24 AM, Eugene Koifman <ekoif...@hortonworks.com> wrote: > No, I was suggesting a possible explanation for why Create Table may be > blocked. > that was the issue in HIVE-10242, but there were no exceptions – it just > appeared as a hang. > > From: Mich Talebzadeh <m...@peridale.co.uk> > Reply-To: "user@hive.apache.org" <user@hive.apache.org> > Date: Friday, April 24, 2015 at 2:49 PM > > To: "user@hive.apache.org" <user@hive.apache.org> > Subject: RE: create statement is not working > > Hi Eugene, > > > > What this with regard to the following thread of mine? > > > > *org.apache.hadoop.hive.ql.lockmgr.LockException: No record of lock could > be found, may have timed out* > > > > Thanks > > > > Mich Talebzadeh > > > > http://talebzadehmich.wordpress.com > > > > Author of the books* "A Practitioner’s Guide to Upgrading to Sybase** ASE > 15", **ISBN 978-0-9563693-0-7*. > > co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN > 978-0-9759693-0-4* > > *Publications due shortly:* > > *Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and > Coherence Cache* > > *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, volume > one out shortly > > > > NOTE: The information in this email is proprietary and confidential. This > message is for the designated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in this > message shall not be understood as given or endorsed by Peridale Ltd, its > subsidiaries or their employees, unless expressly so stated. It is the > responsibility of the recipient to ensure that this email is virus free, > therefore neither Peridale Ltd, its subsidiaries nor their employees accept > any responsibility. > > > > *From:* Eugene Koifman [mailto:ekoif...@hortonworks.com > <ekoif...@hortonworks.com>] > *Sent:* 24 April 2015 22:39 > *To:* user@hive.apache.org > *Subject:* Re: create statement is not working > > > > Do you have hive.support.concurrency=true and long running insert > overwrite statements running concurrently? > > If so, you may be hitting something something like > https://issues.apache.org/jira/browse/HIVE-10242 > > > > *From: *Mich Talebzadeh <m...@peridale.co.uk> > *Reply-To: *"user@hive.apache.org" <user@hive.apache.org> > *Date: *Friday, April 24, 2015 at 1:20 PM > *To: *"user@hive.apache.org" <user@hive.apache.org> > *Subject: *RE: create statement is not working > > > > That is a valid point > > > > I just create a database called *table* in hive which IMO does not make > sense or should not be allowed > > > > hive> create database table; > > OK > > Time taken: 0.488 seconds > > > > Now try the same in Sybase given that *table *is keyword! > > > > 1> create database table on datadev01_HDD = 100 log on logdev01_HDD = 50 > > 2> go > > Msg 156, Level 15, State 2: > > Server 'SYB_157', Line 1: > > Incorrect syntax near the keyword 'table'. > > > > > > > > Mich Talebzadeh > > > > http://talebzadehmich.wordpress.com > > > > Author of the books* "A Practitioner’s Guide to Upgrading to Sybase ASE > 15", ISBN 978-0-9563693-0-7*. > > co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN > 978-0-9759693-0-4* > > *Publications due shortly:* > > *Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and > Coherence Cache* > > *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, > volume one out shortly > > > > NOTE: The information in this email is proprietary and confidential. This > message is for the designated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in this > message shall not be understood as given or endorsed by Peridale Ltd, its > subsidiaries or their employees, unless expressly so stated. It is the > responsibility of the recipient to ensure that this email is virus free, > therefore neither Peridale Ltd, its subsidiaries nor their employees accept > any responsibility. > > > > *From:* Bhagwan S. Soni [mailto:bhgwnsson...@gmail.com > <bhgwnsson...@gmail.com>] > *Sent:* 24 April 2015 21:05 > *To:* user@hive.apache.org > *Subject:* Re: create statement is not working > > > > This is the same which I'm trying to explain, there is nothing wrong in > create statement. This issue is related to infrastructure which I'm trying > to resolve and i need help if some has already faced this issue earlier. > > As create statement does not display any log so I'm not able to trace it. > > > > On Sat, Apr 25, 2015 at 1:08 AM, Mich Talebzadeh <m...@peridale.co.uk> > wrote: > > Hm > > > > It looks OK. However, I personally would not call a database “process”. It > could be reserved work somewhere or an application clashing with that word > (outside of Hive) > > > > > > hive> create database process; > > OK > > Time taken: 0.415 seconds > > hive> 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'; > > OK > > Time taken: 0.292 seconds > > hive> desc PROCESS.aggregated_rspns; > > OK > > id int > > dt string > > hour string > > rspns_count bigint > > highest_rspns_count bigint > > Time taken: 0.12 seconds, Fetched: 5 row(s) > > hive> quit; > > hduser@rhes564::/home/hduser/dba/bin> hdfs dfs -ls /xyz/pqr/ > > 15/04/24 20:43:30 WARN util.NativeCodeLoader: Unable to load native-hadoop > library for your platform... using builtin-java classes where applicable > > Found 1 items > > drwxr-xr-x - hduser supergroup 0 2015-04-24 20:42 > /xyz/pqr/aggregated_rspns > > > > HTH > > > > > > Mich Talebzadeh > > > > http://talebzadehmich.wordpress.com > > > > Author of the books* "A Practitioner’s Guide to Upgrading to Sybase ASE > 15", ISBN 978-0-9563693-0-7*. > > co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN > 978-0-9759693-0-4* > > *Publications due shortly:* > > *Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and > Coherence Cache* > > *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, > volume one out shortly > > > > NOTE: The information in this email is proprietary and confidential. This > message is for the designated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in this > message shall not be understood as given or endorsed by Peridale Ltd, its > subsidiaries or their employees, unless expressly so stated. It is the > responsibility of the recipient to ensure that this email is virus free, > therefore neither Peridale Ltd, its subsidiaries nor their employees accept > any responsibility. > > > > *From:* Bhagwan S. Soni [mailto:bhgwnsson...@gmail.com] > *Sent:* 24 April 2015 17:26 > *To:* user@hive.apache.org > *Subject:* create statement is not working > > > > 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. > > >