The SPJ is using Type 2 driver.
Thanks,
Ming
发件人: Venkat Muthuswamy [mailto:venkat.muthusw...@esgyn.com]
发送时间: 2016年6月8日 8:58
收件人: user@trafodion.incubator.apache.org
主题: RE: when a query will be cancelled?
Hi Ming,
Is your SPJ using type 2 jdbc or type 4 jdbc ?
Venkat
From: Liu, Ming (Ming
2 super-services
21233158559950 12.345.567.345
2 3 super-services
21233158559955 12.345.567.345
--- 4 row(s) selected.
>>
Notice how column names are in upper case in the output.
On Wed,
Hi, all,
I am trying to gather query's run-time statistics using RMS command 'get
statistics'. It works fine, but I have some questions below:
As I understand, RMS will save stats for a given query in shared memory, so it
cannot save all the history. It only save CURRENT running queries'
Hi, all,
I am interested about how can a user use BLOB/CLOB in Trafodion?
I see usage of stringtolob() and lobtostring() like this:
insert into tbl values(1,stringtolob('clob values'));
select lobtostring(c2,10) from tbl;
This is fine if I have not too long string, but if I have a big text file
+1 for 13
Very good drawing, looking forward the dragon to be born.
Thanks,
Ming
发件人: Roberta Marton [mailto:roberta.mar...@esgyn.com]
发送时间: 2016年2月19日 10:02
收件人: user@trafodion.incubator.apache.org
主题: [VOTE] Apache Trafodion Logo Proposal
There has been quite a lot of discussion on our user
Hi, all,
I need to create a table in Trafodion with columns having DEFAULT, but I cannot
make it work, any help will be very appreciated:
CREATE TABLE DBMARTA.ARPT_DIM_AUTORPT_PUB_MARK
(MARK_ID SMALLINTNOT NULL,
BEGIN_TIME DATENOT NULL DEFAULT date'2008-01-01',
From: "Liu, Ming (Ming)" <ming@esgyn.cn<mailto:ming@esgyn.cn>>
Date: 3/14/2016 9:01 AM (GMT-08:00)
To:
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: DDL column DEFAULT question
Hi, all,
I need to create a table in T
From my understanding, it is invalid to start trafodion on node by node mode.
Monitor simulate a single image of operating system from a bunch of nodes. One
process can be configured to be a pair: active and standby. So when start a
trafodion process, it will start two processes on two nodes.
hybrid model.
DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.
Gunnar
On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming)
<ming@esgyn.cn<mailto:ming@esgyn.cn>> wrote:
From my understandi
Great news and wish Trafodion can be known to more and more people!
发件人: Carol Pearson [mailto:carol.pearson...@gmail.com]
发送时间: 2016年3月9日 1:42
收件人: user@trafodion.incubator.apache.org
主题: Apache Trafodion At San Jose Strata + Hadoop World Developer Showcase!
Hi Trafodion Fans,
Great news if
Hi, all,
We have running some complex queries using Trafodion, and need to analyze the
performance. One question is, if we want to know which part of the plan take
longest time, is there any good tool/skills to answer this?
I can use 'get statistics for qid default' to get runtime stats. But
’)
anoop
From: Liu, Ming (Ming) [mailto:ming@esgyn.cn]
Sent: Wednesday, March 16, 2016 8:51 PM
To:
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: Trafodion support of TO_DATE
Hi, all,
I know there will be a new feature to support TO_DATE, cur
ing, analyzing and interpreting the output
from RMS is an art that you would develop over time and it is always difficult
to document every usage scenario. If you find something that needs to be added
or isn’t correct, please let us know.
Selva
From: Liu, Ming (Ming) [mailto:ming@esgyn
Hi, all,
When create a table in Trafodion, by default, CHAR/VARCHAR columns will have
ISO88591 as charset. Is there any way to change this default behavior, so by
default, create table will have UTF8 as charset,without explicitly specify in
DDL.
Thanks,
Ming
Hi, all,
I know there will be a new feature to support TO_DATE, currently, without this
feature, is there any way to migrate a query using TO_DATE?
Example:
insert into myTbl (staff_id,
orbat_code,operate_time,ip_arr,browser_version,orbat_desc)
Hi, all,
I just learned the support of TO_DATE will be avialbe in Trafodion in R2.0 from
Anoop, that is great! At present, due to the urgent requirement of current
migration project, we cannot wait, so I want to write a UDF to do the TO_DATE.
When I try to write it, I found it seems the UDF can
ll convert it to
the datetime type.
Sorry, I have not tested it but hope it will work.
Hans
On Thu, Mar 17, 2016 at 8:43 PM, Liu, Ming (Ming)
<ming@esgyn.cn<mailto:ming@esgyn.cn>> wrote:
Hi, all,
I just learned the support of TO_DATE will be avialbe in Trafodion in R2.0 from
give a
warning or ignore it, because other database allows this, but since itself is
wrong at first, so this ‘enhancement’ is not necessary, just if Trafodion could
do that, that seems more flexible.
Thanks,
Ming
发件人: Rohit [mailto:rohit.j...@esgyn.com]
发送时间: 2016年3月24日 18:12
收件人: Liu, Ming
incorporate it into this guide.
Thanks,
Gunnar
On Wed, Mar 2, 2016 at 3:37 PM, Liu, Ming (Ming)
<ming@esgyn.cn<mailto:ming@esgyn.cn>> wrote:
This is very clear and good answer, solve all my confusion! I am now
understanding how it works. Also understand the relationshi
Hi, all,
I know it will be much easier to do in C or Java after get the result set, but
the Oracle users are used to use to_char() function. Is there similar function
in Trafodion?
Or maybe we can write a UDF for it, but the problem of UDF is it cannot support
polymorphism, that is, one can
from numeric to string.
>>select to_char(date '2016-10-10', '/MM/DD') from (values(1)) X(a);
(EXPR)
--
2016/10/10
--- 1 row(s) selected.
>>select cast(123 as char(3)) from (values(1)) x(a);
(EXPR)
--
123
--- 1 row(s) selected.
>>
From: Liu, Ming (
Hi, all,
Say Trafodion configure to have maximum of 10 concurrent connections. That is:
10 mxosrvr.
Now, 10 clients connected, and 1 of them crashed due to some defect of its own,
so it doesn't call the normal connection close() operation. Will this
connection be reused by another new client
to the base table then it still may be good. Your mileage
will vary.
Dave
From: Liu, Ming (Ming) [mailto:ming@esgyn.cn<mailto:ming@esgyn.cn>]
Sent: Monday, March 28, 2016 5:12 AM
To:
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: MDAM on
Shall we file a JIRA to track this requirement?
Thanks,
Ming
发件人: Suresh Subbiah [mailto:suresh.subbia...@gmail.com]
发送时间: 2016年4月1日 11:54
收件人: user@trafodion.incubator.apache.org
主题: Re: add a comment to a table
Hi,
I do not think Trafodion currently supports Oracle's COMMENT ON syntax
Yes, this is very important topic.
I can confirm to remove two of them :
Name: hbase.bulkload.staging.dir
Value: /hbase-staging
Why:
Still Needed: NO
Name: hbase.regionserver.region.transactional.tlog
Value: true
Why:
Still Needed: NO
We need more test for :
Name:
Hi,
IMHO, 2 nodes is not a recommended configuration. But it is OK for study and
test.
For trafodion itself, all of its own components are peer to peer , except the
DCS master, and even that is rather transparent to end user. During
installation, you don’t need to explicitly specify which
Hi, Qiao,
This is a defect, would you please help to file a JIRA?
I can reproduce it, will make some investigation on this issue.
One workaround for you is to change the DDL a little:
uid VARCHAR(255) to VARCHAR(254)
Hope it works for you.
Thanks,
Ming
From: 乔彦克 [mailto:qya...@gmail.com]
Hi, Forling,
You can try to search in the system metadata, here is an example
select ROW_TOTAL_LENGTH , ROW_DATA_LENGTH from "_MD_".tables , "_MD_".objects
where “_MD_”.objects.OBJECT_UID = “_MD_”.tables.table_uid and
objects.OBJECT_NAME='your_table_name’;
and you can check other columns in
7 AM
To: d...@trafodion.incubator.apache.org; user@trafodion.incubator.apache.org
Cc: Amanda Moran <amanda.mo...@esgyn.com>; Selva Govindarajan
<selva.govindara...@esgyn.com>; Liu, Ming (Ming) <ming@esgyn.cn>
Subject: Re: Load with log error rows gets Trafodion not work
Thanks to Selva and
Hi, Qiao,
before this region fail to open, did you do a bulkload from hive?
I know you hit same issue several times before, but have different java error
stack before. So want to confirm with you.
And you paste the error stack from sqlci, is it possible to find what is the
error stack in Region
Hi, all,
I want to disable AQR in Trafodion , is this possible? Or how should I disable
AQR for specific SQL error?
Thanks,
Ming
it to 'OFF'.
If you want to disable it completely set it in the defaults table.
Sandhya
-Original Message-
From: Liu, Ming (Ming) [mailto:ming@esgyn.cn]
Sent: Tuesday, August 8, 2017 10:36 PM
To: d...@trafodion.incubator.apache.org; user@trafodion.incubator.apache.org
Subject: how
hi, yuan,
The reason for HEX displaying is it can display all character correctly, for
example Chinese character, in any terminal, or any encoding settings.
For example, the terminal is using UTF8, but the source is encoded in GBK, if
not display in HEX, the terminal will show unreadable
R2.1.0 support ‘Identity column’ as well. The documentation was not updated in
R2.1.
If you do not specify the primary key in the DDL, Trafodion will generate a
system hidden column ‘SYSKEY’ as the primary key (Anoop mentioned below).
However, it is a random unique number, you cannot use it in
Hi, Pieter,
There is no such plan as far as I know, please kindly help to file a JIRA if
you think it is useful. So developers will pick up the JIRA if it is high
priority.
@Zhang, Yi (Eason), what do you think?
thanks,
Ming
-Original Message-
From: pieter gmail
Hi, all,
I heard that database index cannot save null value, so if the predicate
contains 'is null' 'is not null', then the index will not be used. Is this true
for Trafodion as well?
thanks,
Ming
This is really exciting news! Thanks for advertising Trafodion :-) It worth
more attention.
thanks,
Ming
From: Pierre Smits [mailto:pierre.sm...@gmail.com]
Sent: Saturday, May 06, 2017 5:22 PM
To: user@trafodion.incubator.apache.org
Subject: Fwd: [NEWS]: We got noticed!!!
Forwarding to user@
Thanks Jack,
This seems like a defect.
Please help to file a JIRA, so we can track this issue when you have free time.
Otherwise, we will create a JIRA to track this issue.
thanks,
Ming
From: Huang, Jack [mailto:jack.hu...@dell.com]
Sent: Wednesday, June 28, 2017 9:34 AM
To:
Hi,
I know Trafodion can use MDAM to reduce scanned rows. For probe, there are two
ways: sparse and dense. If the column is INT, dense probe is just +1 operation,
if the column is VARCHAR or FLOAT, how to do dense probe? Or we should say
dense probe is only for INT data type?
thanks,
Ming
39 matches
Mail list logo