How to change default CQD?

Hello Trafodioneers, I have seen in the code that there is a way to globally change the default Control Query Default values. But I can’t find it in the docs. Can someone help me on this? Regards, Eric

RE: How to change default CQD?

to pick up the new value. anoop *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 10:26 AM *To:* user@trafodion.incubator.apache.org *Subject:* How to change default CQD? Hello Trafodioneers, I have seen in the code that there is a way to globally change t

RE: nullable primary key index column?

Birdsall [mailto:dave.birds...@esgyn.com] *Sent:* Tuesday, February 2, 2016 1:51 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: nullable primary key index column? Hi Eric, Just curious: What is your use case? Why do you need a nullable primary key column? Dave *From:* Eric Owhadi

RE: nullable primary key index column?

@trafodion.incubator.apache.org *Subject:* RE: nullable primary key index column? cqd ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT ‘ON’; then create table with nullable pkey col. only one null value is allowed. *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 11

RE: nullable primary key index column?

ON’; then create table with nullable pkey col. only one null value is allowed. *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 11:27 AM *To:* user@trafodion.incubator.apache.org *Subject:* nullable primary key index column? Dear Trafodioneers, I a

RE: question on nullable column in primary key and impact on upsert

he non-primary-key value was supplied (e.g. through a WHERE clause or a VALUES clause). But you are going to run into this limitation anyway in your schema design. When you want the old primary key semantic, you’ll face similar performance issues. Dave *From:* Eric Owhadi [mailto:eric.owh...@esgy

RE: cqd mode_seahive 'ON'

trafodion. It was at that time used for testing and/or to enable hive access selectively. It is now on by default in traf code and doesn’t need to be set explicitly. anoop *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com <eric.owh...@esgyn.com>] *Sent:* Wednesday, February 3, 2016 8

cqd mode_seahive 'ON'

Hello, I am playing with trafodion hive access path, and I see in some of the regression test about hive a CQD mode_seahive ‘ON’. However, looking in the SQL reference manual, I don’t see this CQD in the hive CQD section. Is this CQD important? Or can I just forget about it? Thanks in advance

RE: Upsert semantics

Would there be a problem if we implemented the phoenix semantic for non align format, and the upsert semantic proposed by Hans in align format? This would allow speed optimization without having the user to know about subtle differences? Eric *From:* Anoop Sharma

RE: installation prerequisites

Hello Sharu, I don’t know if you are trying to install Trafodion binaries to use it as a user, or trying to build Trafodion code to contribute features, fixes etc. If the second option, then follow the “contribute” tab on Trafodion web site. The build environment include a local version of

RE: question on using Batch for a select statement with jdbc

Batch for a select statement with jdbc Hi Eric, Looking at the JDBC specification, I am guessing preparedStatement.setArray and using Array interface can do the trick. But, setArray is unsupported feature in Trafodion jdbc drivers. Selva From: Eric Owhadi

RE: question on using Batch for a select statement with jdbc

ion. Can we please try with say 1000 values and 4000 parameters? Thanks Suresh On Tue, Jan 17, 2017 at 4:53 PM, Eric Owhadi <eric.owh...@esgyn.com<mailto:eric.owh...@esgyn.com>> wrote: Trying this workaround but hitting a timeout exception at prepare time: final static String missin

RE: trafodion jdbc metadata related question

Thanks Kevin, That helps regards Eric Sent from my Samsung Galaxy smartphone. Original message From: "Xu, Kai-Hua (Kevin)" <kaihua...@esgyn.cn> Date: 3/2/17 3:59 AM (GMT-06:00) To: Eric Owhadi <eric.owh...@esgyn.com> Cc: user@trafodion.i

RE: trafodion query optimization

Hello Qiao, When you say whatever the table ddl it limits things a lot, as table ddl will help define several things that will drastically improve the degree of parallelism and the table size. The DOP (degree of parallelism) of the scan operator is constrained by the number of regions your table

RE: trafodion query optimization

he following from sqlci, and the plan is in text file mylog. 1. log mylog clear; 2. prepare xx from ; 3. explain xx; 4. explain options 'f' xx; 5. exit; Thanks --Qifan On Mon, Sep 12, 2016 at 8:21 AM, Eric Owhadi <eric.owh...@esgyn.com> wrote: Hello Qiao, When you say

RE: trafodion query optimization

memory pressure… Hope this helps, Eric *From:* 乔彦克 [mailto:qya...@gmail.com] *Sent:* Monday, September 19, 2016 11:38 PM *To:* user@trafodion.incubator.apache.org *Cc:* dev <d...@trafodion.incubator.apache.org>; Eric Owhadi < eric.owh...@esgyn.com>; Qifan Chen <qifan

RE: Trafodion meta table region in hbase cannot be opened

Hi Qiao, For big table you should use 'update statistics for table on every column sample’. This will perform sampling to compute the stats, That does not explain the problem, but just wanted to let you know, Regards, Eric *From:* 乔彦克 [mailto:qya...@gmail.com] *Sent:* Friday, September

RE: jdbc rowset usage?

quired rowset size PreparedStatement.executeBatch(). Selva ____ From: Eric Owhadi <eric.owh...@esgyn.com<mailto:eric.owh...@esgyn.com>> Sent: Friday, January 13, 2017 3:52 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subjec

RE: LIMIT and ORDER BY in sub-queries

-queries I do not know. I wonder, though, if you could reformulate your subquery as an OLAP query and add a predicate on RANK? That might have the effect you are looking for. From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Wednesday, December 21, 2016 12:18 PM To: user

RE: jdbc rowset usage?

and cannot use them to change behaviour directly. On Fri, Jan 13, 2017 at 11:20 PM, Eric Owhadi <eric.owh...@esgyn.com<mailto:eric.owh...@esgyn.com>> wrote: Hi Suresh, Arvin and Selva, I understand the addBatch method. But I have a hard time understanding how compiler can do a good job

RE: issue with a request

Hi Mathieu, Just a small comment: you are using UTF8 for storing UUID, on a VARCHAR. If this is just for testing functionality that’s OK. But for real production and high volume, if you want to optimize, please consider: CHAR(36) CHARACTER SET ISO88591 Trafodion would reserve 4 times more space

RE: issue wtih foreign keys

Are you saying that autocommit is off, and you are executing the 3 ddl statement then manual commit? Then you see the issue? Or autocommit is on, and you see the issue? When you perform the same ddl operation using command line with sqlci, you see no problem right? Eric From: mathieu ferlay

RE: issue wtih foreign keys

aybe the behavior is different? Dave From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 16, 2017 8:25 AM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: issue wtih foreign keys Are you saying that autocommit is off, and you are

trafodion jdbc metadata related question

Hello trafodioneers, I am trying to use jdbc metadata api to retrieve the equivalent of what a showddl or invoke would provide in sqlci or trafci. If I use DatabaseMetaData metadata = conn.getMetaData();

RE: trafodion jdbc metadata related question

5) from "_MD_".columns_view where table_name = >>'TPART'; (EXPR) A B _SALT --- 3 row(s) selected. >> Similarly select from keys_view will tell the keys for a table. anoop From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 2, 2017 6:

RE: is it possible to pass a sql statement to sqlci?

ubject: RE: is it possible to pass a sql statement to sqlci? I know you can run commands like this: sqlci << eof env; values (current_user); eof Roberta From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Friday, July 28, 2017 7:59 AM To: user@trafodion.

is it possible to pass a sql statement to sqlci?

Hi Trafodioneers, I know we can use sqlci -i filename And this will trigger an OBEY filename. But I was wondering if there is an option to directly pass the sql statement, without writing it to a file Sqlci -??? "select count(*) from tbl" Eric

RE: is there a way to disable a specific check constraint without dropping it?

if invoked. So someone thought about implementing ALTER TABLE DISABLE ALL CONSTRAINTS at one point but did not complete it. Just curious: What's the use case? Why does dropping and then recreating not work? Dave From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Friday, June 16, 2017 8:35 AM

RE: is there a way to disable a specific check constraint without dropping it?

is returned: >>alter table tc add constraint tc1 check (a < 10); *** ERROR[1083] Validation for constraint TRAFODION.SCH.TC1 failed; incompatible data exists in table. --- SQL operation failed with errors. >> anoop From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Monday, June

RE: is there a way to disable a specific check constraint without dropping it?

: Monday, June 19, 2017 2:19 PM To: user@trafodion.incubator.apache.org Subject: Re: is there a way to disable a specific check constraint without dropping it? Right, because re-enabling will have to recheck the constraint anyway. Rohit On Jun 19, 2017, at 1:26 PM, Eric Owhadi <eric.owh...@esgyn.

RE: auto generated primary keys

Hi Pieter, Did you look at section 5.11 Identity Column? Is it what you are looking for? Regards, Eric -Original Message- From: pieter gmail [mailto:pieter.mar...@gmail.com] Sent: Saturday, May 20, 2017 12:41 PM To: user@trafodion.incubator.apache.org Subject: RE: auto generated primary

alter table add constraint ? modify constraint?

Hi Trafodioneers, Looking at the doc, I don't see that there is syntax to modify a constraint. Should I assume that the only way to modify a constraint is to drop it first then add it back? Are these drop constraint, add constraint transactionaly protected? Thanks in advance for the help, Eric

is there a way to disable a specific check constraint without dropping it?

Hi Trafodioneers, I am wondering if there is a way to disable check constraint without dropping them? Is there? Thanks in advance for the help, Eric

Re: DCS is not started

did you try ckillall then sqstart? Eric Sent from my Samsung Galaxy smartphone. Original message From: "Huang, Jack" Date: 11/28/17 8:03 PM (GMT-06:00) To: user@trafodion.incubator.apache.org Subject: DCS is not started Hi, My trafodion env is down,