You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "Bhagwan S. Soni" <bh...@gmail.com> on 2015/04/24 18:25:43 UTC
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.
Re: create statement is not working
Posted by Eugene Koifman <ek...@hortonworks.com>.
assuming you have the same issue as HIVE-10242<https://issues.apache.org/jira/browse/HIVE-10242> you need to wait for next release (1.2) which includes a fix(which only applies if you are using DBTxnManager)
alternatively, you can disable concurrency if that is acceptable
Eugene
From: "Bhagwan S. Soni" <bh...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 24, 2015 at 4:42 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Subject: Re: create statement is not working
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 <ek...@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 <mi...@peridale.co.uk>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 24, 2015 at 2:49 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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:ekoifman@hortonworks.com]
Sent: 24 April 2015 22:39
To: user@hive.apache.org<ma...@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 <mi...@peridale.co.uk>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 24, 2015 at 1:20 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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:bhgwnssoni75@gmail.com]
Sent: 24 April 2015 21:05
To: user@hive.apache.org<ma...@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 <mi...@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:bhgwnssoni75@gmail.com<ma...@gmail.com>]
Sent: 24 April 2015 17:26
To: user@hive.apache.org<ma...@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.
Re: create statement is not working
Posted by "Bhagwan S. Soni" <bh...@gmail.com>.
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 <ek...@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 <mi...@peridale.co.uk>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Friday, April 24, 2015 at 2:49 PM
>
> To: "user@hive.apache.org" <us...@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:ekoifman@hortonworks.com
> <ek...@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 <mi...@peridale.co.uk>
> *Reply-To: *"user@hive.apache.org" <us...@hive.apache.org>
> *Date: *Friday, April 24, 2015 at 1:20 PM
> *To: *"user@hive.apache.org" <us...@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:bhgwnssoni75@gmail.com
> <bh...@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 <mi...@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:bhgwnssoni75@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.
>
>
>
Re: create statement is not working
Posted by Eugene Koifman <ek...@hortonworks.com>.
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 <mi...@peridale.co.uk>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 24, 2015 at 2:49 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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:ekoifman@hortonworks.com]
Sent: 24 April 2015 22:39
To: user@hive.apache.org<ma...@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 <mi...@peridale.co.uk>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 24, 2015 at 1:20 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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:bhgwnssoni75@gmail.com]
Sent: 24 April 2015 21:05
To: user@hive.apache.org<ma...@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 <mi...@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:bhgwnssoni75@gmail.com<ma...@gmail.com>]
Sent: 24 April 2015 17:26
To: user@hive.apache.org<ma...@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.
RE: create statement is not working
Posted by Mich Talebzadeh <mi...@peridale.co.uk>.
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:ekoifman@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 <mi...@peridale.co.uk>
Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
Date: Friday, April 24, 2015 at 1:20 PM
To: "user@hive.apache.org" <us...@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:bhgwnssoni75@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 <mi...@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:bhgwnssoni75@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.
Re: create statement is not working
Posted by Eugene Koifman <ek...@hortonworks.com>.
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 <mi...@peridale.co.uk>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 24, 2015 at 1:20 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@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:bhgwnssoni75@gmail.com]
Sent: 24 April 2015 21:05
To: user@hive.apache.org<ma...@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 <mi...@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:bhgwnssoni75@gmail.com<ma...@gmail.com>]
Sent: 24 April 2015 17:26
To: user@hive.apache.org<ma...@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.
RE: create statement is not working
Posted by Mich Talebzadeh <mi...@peridale.co.uk>.
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:bhgwnssoni75@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 <mi...@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:bhgwnssoni75@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.
Re: create statement is not working
Posted by "Bhagwan S. Soni" <bh...@gmail.com>.
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 <mi...@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:bhgwnssoni75@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.
>
RE: create statement is not working
Posted by Mich Talebzadeh <mi...@peridale.co.uk>.
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:bhgwnssoni75@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.
Re: create statement is not working
Posted by "Bhagwan S. Soni" <bh...@gmail.com>.
To be more specific, it happens occasionally .
On Fri, Apr 24, 2015 at 10:59 PM, Bhagwan S. Soni <bh...@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 <ga...@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.
>>
>>
>
Re: create statement is not working
Posted by "Bhagwan S. Soni" <bh...@gmail.com>.
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 <ga...@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.
>
>
Re: create statement is not working
Posted by gabriel balan <ga...@oracle.com>.
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.