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, how can I recover the tr

RE: MDAM has sparse and dense mode, for string column, is it possible to use dense mode?

Hi Dave and Ming, I am not sure I understand why we are not just simply using a probe asking for strictly greater in all cases>? Let say after "ABC", the next probe is where x > "ABC" limit 1? Eric From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Monday, October 23, 2017 11:35 AM To:

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?

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 mailto:eric.owh

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

or 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

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: alter table add constraint ? modify constraint?

From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Thursday, June 15, 2017 4:55 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: alter table add constraint ? modify constraint? TEXT table From: Eric Owhadi [mailto:eric.owh...@esgyn.com

RE: alter table add constraint ? modify constraint?

Subject: RE: alter table add constraint ? modify constraint? yes, you need to drop/add constraint. There is no support for modify constraint. constraint add/drop are transactionally protected. What kind of constraints are these? check, unique, RI? anoop From: Eric Owhadi [mailto:eric.owh

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

Re: Make "HBase options" as default setting?

+1 Sent from my Samsung Galaxy smartphone. Original message From: "Liu, Yuan (Yuan)" Date: 6/6/17 10:29 PM (GMT-06:00) To: user@trafodion.incubator.apache.org Subject: Make "HBase options" as default setting? Hi Trafodioners, As we know, for performance thinking, we always

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 k

RE: [Question]Does Trafodion support median() function as Oracle?

Some ways to compute median without support for dedicated aggregate function: http://sqlblog.com/blogs/adam_machanic/archive/2006/12/18/medians-row-numbers-and-performance.aspx Hope this helps, Eric From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Monday, May 8, 2017 11:25 AM To: user@tr

RE: issue wtih foreign keys

trafci... maybe 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 o

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 [ma

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 fo

RE: maximum column name size and maximum table name size?

. (Might be some fuzziness around delimited identifiers; you'd have to do a little experimentation.) So, for example, you could create a Trafodion table with catalog name TRAFODION and schema name SCH... (256 ascii characters), and table name TABLE... (256 ascii characters). Dave From:

maximum column name size and maximum table name size?

Hello Trafodioneers, I am working on a project involving dynamically creating tables. I am wondering if someone knows the max size for column name and table name (I assume index name is same as table name?). Thanks in advance for the help, Eric

RE: trafodion jdbc metadata related question

lumns_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:25 AM To: Kevi

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)" Date: 3/2/17 3:59 AM (GMT-06:00) To: Eric Owhadi Cc: user@trafodion.incubator.apache.org, d...@trafodion.incubator.apache.org Subject: RE:

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: question on using Batch for a select statement with jdbc

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

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

Am I doing something crazy? Or is there a CQD/param that would help prepare that statement containing 10 000 (?,?,?,?) , so 40 000 parameters in it? Eric From: Eric Owhadi Sent: Tuesday, January 17, 2017 2:47 PM To: user@trafodion.incubator.apache.org Subject: RE: question on using Batch for

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

using 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 O

question on using Batch for a select statement with jdbc

Hi Trafodioneers, Have following jdbc question: select x.a, d.a from (values (?,?,?,?)) as x(a,b,c,d) join directories d on x.b = d.b and x.c= d.c and x.d = d.d; I was thinking of using Batch to fill the list of values, but then I struggle with how to invoke the query. executeBatch does not retu

RE: jdbc rowset usage?

m and cannot use them to change behaviour directly. On Fri, Jan 13, 2017 at 11:20 PM, Eric Owhadi 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 not knowing the cardina

RE: jdbc rowset usage?

ecuteBatch(). Selva ____ From: Eric Owhadi 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> Subject: jdbc rowset usage? Hello, I am struggling to find the j

jdbc rowset usage?

Hello, I am struggling to find the jdbc syntax to set an dynamic array parameter: Assuming I prepared this statement s with "Insert into t (a,b,c) values( ?[1000], ?[1000], ?[1000])" How do I set each parameter? Assuming a is INT, b is CHAR[10], c is INT? Am I doing something not really support

RE: LIMIT and ORDER BY in sub-queries

t * from t1 where b in +> (select b from (select b,rank(b) from t1 sequence by b) as t2(b,r) +>where r <= 3); AB --- --- 22 11 48 --- 3 row(s) selected. >> From: Eric Owhadi [mailto:e

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

LIMIT and ORDER BY in sub-queries

Hello Trafodioneers, I see that we are not supporting LIMIT inside subqueries, and that ORDER BY inside subqueries are ignored. Is there a CQD to change this default behavior? Thanks in advance for the help, Eric

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: trafodion query optimization

bad, Eric *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, September 20, 2016 12:10 AM *To:* '乔彦克' ; 'user@trafodion.incubator.apache.org' < user@trafodion.incubator.apache.org> *Cc:* 'dev' ; Qifan Chen < qifan.c...@esgyn.com> *Subject:* R

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 ; Eric Owhadi < eric.owh...@esgyn.com>; Qifan Chen *Subject:* Re: trafodion query optimization Many than

RE: trafodion query optimization

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 wrote: Hello Qiao, When you say whatever the table ddl it limits things a lot, as table ddl will help define seve

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 u

RE: create table failed

Hi Qiao and Ming, I am wondering if it is not related to the max size of keys in bytes. I recall having seen it in the code, but would not bet that it was around 2K? Varchar in UTF8 stored as key is very wide because had to be stored explode. When using columns in PK, VARCHAR is not a good choic

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 Had

RE: problem with update statistics

e that something Trafodion did or said to HBase made it blush. J Dave *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com ] *Sent:* Thursday, March 24, 2016 2:32 PM *To:* user@trafodion.incubator.apache.org *Subject:* problem with update statistics Hi Trafodioneers, I am trying to create a 10M row

problem with update statistics

Hi Trafodioneers, I am trying to create a 10M row table, 1KB each row 10 partitions to test a new feature (parallelScan). But on my dev (so single node), I stumble on update statistics error: update statistics for table t132 on every column sample; *** ERROR[9200] UPDATE STATISTICS for table

RE: Upsert semantics

plementation. Thanks, Hans On Tue, Mar 15, 2016 at 3:41 PM, Dave Birdsall wrote: Not sure we want the logical semantics of an operation to depend on the physical layout of the row. Would be better to have different syntax for each. With an explanation that one works faster on one f

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 [mailto:anoop.sha...@esgyn.

align format and null indicator?

Hi Trafodioneers, I know that for regular format, the storage need for null indicator is 1 byte per null column. But what is it for aligned format? 1 bit per null column or 1 byte per null column? Thanks in advance for the help, Eric

RE: Logo Proposal

+1 option 4 *From:* Anuradha Hegde [mailto:anuradha.he...@esgyn.com] *Sent:* Thursday, February 11, 2016 4:57 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: Logo Proposal +1 option 4 *From:* Ken Holt [mailto:knhknhknh...@gmail.com] *Sent:* Thursday, February 11, 2016 2:51 PM *

serializable decimal/real format?

Hello Trafodioneers, I am doing some experimentation with TPCDS type queries, and realizes that float or decimal(7,2) are not serializable, therefore cannot push down predicates based on these. Is there a decimal format that is serializable in current version of Trafodion? Thanks in advance for t

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

ed (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...@esgyn.com] *Sent:* Wednesday, Februar

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

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...@esgyn.com] *Sent:* Wednesday, February 3, 2016 10:43 AM *To:* user

question on nullable column in primary key and impact on upsert

This following question is about checking if adding nullable columns on PK for the sake of data partitioning can be done without too much impact on initial PK uniqueness semantic… specially for upsert statements… If I have a composite primary key with column A and B. A nullable B non nullable

RE: cqd mode_seahive 'ON'

bles from 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 ] *Sent:* Wednesday, February 3, 2016 8:22 AM

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 f

RE: fixing/checking corrupted metadata?

5:05 PM, Eric Owhadi wrote: Great thanks for the info, very helpful. You mention Trafodion documentation, in what DOC is it described? I looked for it in Trafodion Command Interface Guide and Trafodion SQL Reference Manual with no luck? The other doc titles did not look promising? Eric

RE: fixing/checking corrupted metadata?

...@esgyn.com] *Sent:* Tuesday, February 2, 2016 2:41 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: fixing/checking corrupted metadata? You might want to try sqlci initialize trafodion, drop; initialize trafodion; *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday

fixing/checking corrupted metadata?

I have been playing on my dev environment with this DDL: create table Customer ( c_customer_sk int not null, c_customer_id char(16) CHARACTER SET UTF8 not null, c_current_cdemo_sk int, c_current_hdemo_sk int, c_current_addr_sk int,

RE: How to change default CQD?

at 12:34 PM, Eric Owhadi wrote: Thanks Anoop, So I will use the following insert statement: insert into "_MD_".defaults values ('MY_CQD', 'value of CQD', 'comment why it is inserted'); Eric *From:* Anoop Sharma [mailto:anoop.sha...@esgyn.com] *S

RE: nullable primary key index column?

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 am wondering if it is po

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

nullable primary key index column?

Dear Trafodioneers, I am wondering if it is possible to use a composite primary key with the first column making up the primary key composite being nullable? If yes, is there any restriction, like only one row can be null for that nullable column? Thanks in advance for the help, Eric

RE: How to change default CQD?

l need to restart dcs servers 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

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: Apache Trafodion release

Yes that is very impressive, Thanks a million Roberta. Eric *From:* Amanda Moran [mailto:amanda.mo...@esgyn.com] *Sent:* Wednesday, January 20, 2016 11:25 AM *To:* user@trafodion.incubator.apache.org *Subject:* Re: Apache Trafodion release Agreed!! Thanks for all the hardwork Roberta!!!