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<mailto:m...@peridale.co.uk>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Friday, April 24, 2015 at 1:20 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto: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] Sent: 24 April 2015 21:05 To: user@hive.apache.org<mailto: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<mailto: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<mailto:bhgwnsson...@gmail.com>] Sent: 24 April 2015 17:26 To: user@hive.apache.org<mailto: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.