You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by "Xu, Kai-Hua (Kevin)" <ka...@esgyn.cn> on 2016/03/14 09:16:16 UTC
Got an error while create an existing schema with "if not exits"
Hi guys,
I'm trying to create an existing schema using "if not exists", but got the following error. Who could help? Thank you!
>>create schema if not exists T4_TEST;
*** ERROR[1390] Object TRAFODION.T4_TEST.SB_HISTOGRAMS already exists in Trafodion.
*** ERROR[8839] Transaction was aborted.
*** ERROR[1058] Unable to create histogram table SB_HISTOGRAMS.
--- SQL operation failed with errors.
Best Regards,
Kevin Xu
RE: Got an error while create an existing schema with "if not exits"
Posted by Anoop Sharma <an...@esgyn.com>.
fix is in trafodion branch.
which version/build were you running with?
anoop
-----Original Message-----
From: Jin, Jian (Seth) [mailto:Jian.jin@esgyn.cn]
Sent: Monday, March 14, 2016 7:52 AM
To: dev@trafodion.incubator.apache.org
Subject: Re: Got an error while create an existing schema with "if not
exits"
What is the related JIRA ID?
Br,
Seth
Sent from mobile device, pls excuse any typo.
在 2016年3月14日，下午10:34，Roberta Marton <ro...@esgyn.com> 写
道：
This is a known problem and a fix is imminent.
Roberta
-----Original Message-----
From: Xu, Kai-Hua (Kevin) [mailto:kaihua.xu@esgyn.cn]
Sent: Monday, March 14, 2016 1:16 AM
To: dev@trafodion.incubator.apache.org
Subject: Got an error while create an existing schema with "if not exits"
Hi guys,
I'm trying to create an existing schema using "if not exists", but got the
following error. Who could help? Thank you!
>> create schema if not exists T4_TEST;
*** ERROR[1390] Object TRAFODION.T4_TEST.SB_HISTOGRAMS already exists in
Trafodion.
*** ERROR[8839] Transaction was aborted.
*** ERROR[1058] Unable to create histogram table SB_HISTOGRAMS.
--- SQL operation failed with errors.
Best Regards,
Kevin Xu
Re: Got an error while create an existing schema with "if not exits"
Posted by "Jin, Jian (Seth)" <Ji...@esgyn.cn>.
What is the related JIRA ID?
Br,
Seth
Sent from mobile device, pls excuse any typo.
在 2016年3月14日，下午10:34，Roberta Marton <ro...@esgyn.com> 写道：
This is a known problem and a fix is imminent.
Roberta
-----Original Message-----
From: Xu, Kai-Hua (Kevin) [mailto:kaihua.xu@esgyn.cn]
Sent: Monday, March 14, 2016 1:16 AM
To: dev@trafodion.incubator.apache.org
Subject: Got an error while create an existing schema with "if not exits"
Hi guys,
I'm trying to create an existing schema using "if not exists", but got the
following error. Who could help? Thank you!
>> create schema if not exists T4_TEST;
*** ERROR[1390] Object TRAFODION.T4_TEST.SB_HISTOGRAMS already exists in
Trafodion.
*** ERROR[8839] Transaction was aborted.
*** ERROR[1058] Unable to create histogram table SB_HISTOGRAMS.
--- SQL operation failed with errors.
Best Regards,
Kevin Xu
RE: Got an error while create an existing schema with "if not exits"
Posted by Roberta Marton <ro...@esgyn.com>.
This is a known problem and a fix is imminent.
Roberta
-----Original Message-----
From: Xu, Kai-Hua (Kevin) [mailto:kaihua.xu@esgyn.cn]
Sent: Monday, March 14, 2016 1:16 AM
To: dev@trafodion.incubator.apache.org
Subject: Got an error while create an existing schema with "if not exits"
Hi guys,
I'm trying to create an existing schema using "if not exists", but got the
following error. Who could help? Thank you!
>>create schema if not exists T4_TEST;
*** ERROR[1390] Object TRAFODION.T4_TEST.SB_HISTOGRAMS already exists in
Trafodion.
*** ERROR[8839] Transaction was aborted.
*** ERROR[1058] Unable to create histogram table SB_HISTOGRAMS.
--- SQL operation failed with errors.
Best Regards,
Kevin Xu