答复: when a query will be cancelled?

2016-06-07 Thread Liu, Ming (Ming)
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

答复: how to reference a column from a TMUDF?

2016-06-01 Thread 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,

RMS questions

2016-02-27 Thread Liu, Ming (Ming)
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'

how to use BLOB/CLOB in Trafodion?

2016-02-16 Thread Liu, Ming (Ming)
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

答复: [VOTE] Apache Trafodion Logo Proposal

2016-02-18 Thread Liu, Ming (Ming)
+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

DDL column DEFAULT question

2016-03-14 Thread Liu, Ming (Ming)
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',

答复: DDL column DEFAULT question

2016-03-14 Thread Liu, Ming (Ming)
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

答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Liu, Ming (Ming)
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.

答复: 答复: Anyway to start Trafodion without sqstart

2016-03-15 Thread Liu, Ming (Ming)
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

答复: Apache Trafodion At San Jose Strata + Hadoop World Developer Showcase!

2016-03-08 Thread Liu, Ming (Ming)
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

how to tell the most time-consuming part for a given Trafodion query plan?

2016-03-08 Thread Liu, Ming (Ming)
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

答复: Trafodion support of TO_DATE

2016-03-19 Thread Liu, Ming (Ming)
’) 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

答复: how to tell the most time-consuming part for a given Trafodion query plan?

2016-03-09 Thread Liu, Ming (Ming)
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

How to specify default charset of column in DDL create table?

2016-04-06 Thread Liu, Ming (Ming)
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

Trafodion support of TO_DATE

2016-03-19 Thread Liu, Ming (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)

How to implement a TO_DATE UDF in Trafodion

2016-03-19 Thread Liu, Ming (Ming)
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

答复: How to implement a TO_DATE UDF in Trafodion

2016-03-23 Thread Liu, Ming (Ming)
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

答复: Does Trafodion support to use 'order by' in a subquery

2016-03-24 Thread Liu, Ming (Ming)
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

答复: 答复: RMS questions

2016-03-02 Thread Liu, Ming (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

converting INTEGER to CHAR in Trafodion

2016-03-30 Thread Liu, Ming (Ming)
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

Re: converting INTEGER to CHAR in Trafodion

2016-03-30 Thread Liu, Ming (Ming)
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 (

How DCS will response if a connected client crash?

2016-03-29 Thread Liu, Ming (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

答复: MDAM on index

2016-03-28 Thread Liu, Ming (Ming)
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

答复: add a comment to a table

2016-04-01 Thread Liu, Ming (Ming)
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

答复: HDFS/HBase/Zookeeper Settings set by Installer

2016-05-03 Thread Liu, Ming (Ming)
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:

RE: install trafodion on 2 nodes cluster

2016-08-08 Thread Liu, Ming (Ming)
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

RE: create table failed

2016-08-17 Thread Liu, Ming (Ming)
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]

RE: command

2016-09-12 Thread Liu, Ming (Ming)
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

RE: Load with log error rows gets Trafodion not work

2016-09-08 Thread Liu, Ming (Ming)
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

RE: Trafodion meta table region in hbase cannot be opened

2016-09-22 Thread Liu, Ming (Ming)
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

how to setup/enable/disable AQR

2017-08-08 Thread Liu, Ming (Ming)
Hi, all, I want to disable AQR in Trafodion , is this possible? Or how should I disable AQR for specific SQL error? Thanks, Ming

RE: how to setup/enable/disable AQR

2017-08-09 Thread Liu, Ming (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

RE: Error 8413 shows source hex value?

2017-08-04 Thread Liu, Ming (Ming)
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

RE: auto generated primary keys

2017-05-21 Thread Liu, Ming (Ming)
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

RE: docker

2017-05-21 Thread Liu, Ming (Ming)
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

does trafodion have null value in the index?

2017-06-01 Thread Liu, Ming (Ming)
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

RE: [NEWS]: We got noticed!!!

2017-05-06 Thread Liu, Ming (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@

RE: trafodion odbc driver dump

2017-06-27 Thread Liu, Ming (Ming)
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:

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

2017-10-20 Thread Liu, Ming (Ming)
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