[jira] [Created] (TRAFODION-3228) support table alias in set clause in an UPDATE statement
liu ming created TRAFODION-3228: --- Summary: support table alias in set clause in an UPDATE statement Key: TRAFODION-3228 URL: https://issues.apache.org/jira/browse/TRAFODION-3228 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming to support: |update tt1 a set a.c0 = '0', a.c1='0091121', a.c2='9901', a.c3='20170601', a.c4='181605607' where a.c5 = '' and a.c6 = '000911210061' and a.c7 = '20170601' ;| -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3227) support ORDER options in sequence creation
liu ming created TRAFODION-3227: --- Summary: support ORDER options in sequence creation Key: TRAFODION-3227 URL: https://issues.apache.org/jira/browse/TRAFODION-3227 Project: Apache Trafodion Issue Type: New Feature Reporter: liu ming Assignee: liu ming >>CREATE SEQUENCE test_seq +>START WITH 1 +>INCREMENT BY 1 +>MINVALUE 1 +>MAXVALUE 999 +>CACHE 5000 +>CYCLE +>ORDER; -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3224) replication of small tables
liu ming created TRAFODION-3224: --- Summary: replication of small tables Key: TRAFODION-3224 URL: https://issues.apache.org/jira/browse/TRAFODION-3224 Project: Apache Trafodion Issue Type: New Feature Reporter: liu ming Assignee: liu ming For small tables, it will be beneifit to replicate it into all nodes in the cluster, when it has very few update, and most of read operation. This may not be helpful in HBase tables, but I record this requirement, and need to do more investigation to decide if Trafodion need this, and if this really can help. The use case: A big table join with 4 very small tables. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3213) add new Oracle to_date() function
liu ming created TRAFODION-3213: --- Summary: add new Oracle to_date() function Key: TRAFODION-3213 URL: https://issues.apache.org/jira/browse/TRAFODION-3213 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming The current TO_DATE() function is very strict and not very compatible with Oracle TO_DATE. This is an attempt to implement a new TO_DATE() function that be more compatible with Oracle -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3212) enhance fault tolerance of SCRATCH directories when disk fail
liu ming created TRAFODION-3212: --- Summary: enhance fault tolerance of SCRATCH directories when disk fail Key: TRAFODION-3212 URL: https://issues.apache.org/jira/browse/TRAFODION-3212 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming When there is disk failure, STFS directories is not accessible, so overflow operation will fail until disk fixed. Add logic to remove bad dir automaticlly, so queries can continue. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (TRAFODION-3033) optimize TRAFODION_UPDATE operator
[ https://issues.apache.org/jira/browse/TRAFODION-3033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-3033: --- Assignee: Anoop Sharma (was: Gu Haiyan) > optimize TRAFODION_UPDATE operator > -- > > Key: TRAFODION-3033 > URL: https://issues.apache.org/jira/browse/TRAFODION-3033 > Project: Apache Trafodion > Issue Type: New Feature >Reporter: liu ming >Assignee: Anoop Sharma >Priority: Major > > TRAFODION_UPDATE needs to read twice the row, it may be possible to reduce > one read from hbase. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (TRAFODION-3033) optimize TRAFODION_UPDATE operator
[ https://issues.apache.org/jira/browse/TRAFODION-3033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-3033: --- Assignee: Gu Haiyan (was: liu ming) > optimize TRAFODION_UPDATE operator > -- > > Key: TRAFODION-3033 > URL: https://issues.apache.org/jira/browse/TRAFODION-3033 > Project: Apache Trafodion > Issue Type: New Feature >Reporter: liu ming >Assignee: Gu Haiyan >Priority: Major > > TRAFODION_UPDATE needs to read twice the row, it may be possible to reduce > one read from hbase. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3035) install_local_hadoop script out of date
[ https://issues.apache.org/jira/browse/TRAFODION-3035?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3035. - Resolution: Fixed Fix Version/s: 2.4 > install_local_hadoop script out of date > --- > > Key: TRAFODION-3035 > URL: https://issues.apache.org/jira/browse/TRAFODION-3035 > Project: Apache Trafodion > Issue Type: Umbrella >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > The download link in install_local_hadoop no longer work for various disto > settings. > Default is working. Others need to fix one by one. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3038) fix HDP download link
[ https://issues.apache.org/jira/browse/TRAFODION-3038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3038. - Resolution: Fixed Fix Version/s: 2.4 > fix HDP download link > - > > Key: TRAFODION-3038 > URL: https://issues.apache.org/jira/browse/TRAFODION-3038 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > When HBASE_DISTRO=HDP, it doesn't work. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-2174) sometime sqstop hang and cannot stop system
[ https://issues.apache.org/jira/browse/TRAFODION-2174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming closed TRAFODION-2174. --- Resolution: Won't Fix > sometime sqstop hang and cannot stop system > --- > > Key: TRAFODION-2174 > URL: https://issues.apache.org/jira/browse/TRAFODION-2174 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > this issue occurred randomly, not very clear what is the consequence. People > use Ctrl+C and then ckillall, not sure if this is safe. > File jira to track it, next time meet this, we may need to gather more debug > info. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3038) fix HDP download link
[ https://issues.apache.org/jira/browse/TRAFODION-3038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3038 started by liu ming. --- > fix HDP download link > - > > Key: TRAFODION-3038 > URL: https://issues.apache.org/jira/browse/TRAFODION-3038 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > When HBASE_DISTRO=HDP, it doesn't work. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3205) add skip conflict flag into Trafodion
liu ming created TRAFODION-3205: --- Summary: add skip conflict flag into Trafodion Key: TRAFODION-3205 URL: https://issues.apache.org/jira/browse/TRAFODION-3205 Project: Apache Trafodion Issue Type: Sub-task Reporter: liu ming Assignee: liu ming To solve the fake update conflict, we need the skip conflict bypass feature first. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3201) revert wrong fix in trafodion-3175
[ https://issues.apache.org/jira/browse/TRAFODION-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3201. - Resolution: Fixed Fix Version/s: 2.4 > revert wrong fix in trafodion-3175 > -- > > Key: TRAFODION-3201 > URL: https://issues.apache.org/jira/browse/TRAFODION-3201 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > There was a misunderstanding of the code, a wrong 'fix' was checked in for > TRAFODION-3175, should fix it asap. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-3203) revert a change of sequence retry number to 10
[ https://issues.apache.org/jira/browse/TRAFODION-3203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming closed TRAFODION-3203. --- Resolution: Won't Fix > revert a change of sequence retry number to 10 > -- > > Key: TRAFODION-3203 > URL: https://issues.apache.org/jira/browse/TRAFODION-3203 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > The Trafodion main branch test fail, revert a previous change to see if it > helps. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3203) revert a change of sequence retry number to 10
liu ming created TRAFODION-3203: --- Summary: revert a change of sequence retry number to 10 Key: TRAFODION-3203 URL: https://issues.apache.org/jira/browse/TRAFODION-3203 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming Assignee: liu ming The Trafodion main branch test fail, revert a previous change to see if it helps. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3201) revert wrong fix in trafodion-3175
liu ming created TRAFODION-3201: --- Summary: revert wrong fix in trafodion-3175 Key: TRAFODION-3201 URL: https://issues.apache.org/jira/browse/TRAFODION-3201 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming Assignee: liu ming There was a misunderstanding of the code, a wrong 'fix' was checked in for TRAFODION-3175, should fix it asap. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3201) revert wrong fix in trafodion-3175
[ https://issues.apache.org/jira/browse/TRAFODION-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3201 started by liu ming. --- > revert wrong fix in trafodion-3175 > -- > > Key: TRAFODION-3201 > URL: https://issues.apache.org/jira/browse/TRAFODION-3201 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > There was a misunderstanding of the code, a wrong 'fix' was checked in for > TRAFODION-3175, should fix it asap. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-2136) union all can't work efficiently
[
https://issues.apache.org/jira/browse/TRAFODION-2136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming closed TRAFODION-2136.
---
Resolution: Duplicate
duplicated and handled by another task
> union all can't work efficiently
>
>
> Key: TRAFODION-2136
> URL: https://issues.apache.org/jira/browse/TRAFODION-2136
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
>Affects Versions: any
>Reporter: Joshua Liu
>Assignee: liu ming
>Priority: Major
>
> there is one query called a
> the first time we run
> a;
> and get the elapsed time time1
> reconnect the database;
> the second time we run
> a union all a;
> and get another elapsed time.time2
> here time2 ≈ time1*2
> -
> see below for detailed info
> a is
> select count(*)
> from F_INCOME_DAY_RH a left join D_IN_SORTCODE_NEW b
> on (A.INCOMESORTCODE_N = B.CODE1)
> where (((a.BBQ >= date '2014-01-01') AND (a.BBQ <= date '2014-12-31')) AND
> ((a.BUDGETLEVEL = '3') AND
> ((a.TAXORGCODE in ('1', '2', '3', '4', '5'))) AND
> (a.DISTRICT_CO_CODE like 'A%' or
> a.DISTRICT_CO_CODE like 'B%')) AND
> ((a.INCOMESORTCODE_N LIKE 'A%') OR
> (a.INCOMESORTCODE_N LIKE 'B%') OR
> (a.INCOMESORTCODE_N LIKE 'C%') OR
> (a.INCOMESORTCODE_N LIKE 'F%') OR
> (a.INCOMESORTCODE_N LIKE 'G%')))
> group by b.CODE5
> -
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 7.8root 6.00E+000
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
> SQL>set statistics on;
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>53722
> 5573
> --- 5 row(s) selected.
>
> Start Time 2016/07/30 09:47:50.913298
> End Time 2016/07/30 09:48:05.018125
> Elapsed Time 00:00:14.104827
> Compile Time 00:00:05.641437
> Execution Time00:00:14.104827
> ---
> reconnect database and run a union all a;
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 15 .16 root 1.20E+001
> 714 15 merge_union 1.20E+001
> 13 .14 hash_partial_groupby 6.00E+000
> 12 .13 esp_exchange1:16(hash2) 6.00E+000
> 11 .12 hash_partial_groupby 6.00E+000
> 10 911 left_hybrid_hash_joi 1.06E+006
> ..10 trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 8.9esp_exchange16(rep-b):1 (m) 7.24E+002
> ..8trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
>
> Start Time 2016/07/30 09:48:28.230061
> End Time 2016/07/30 09:48:45.506429
> Elapsed Time 00:00:17.276368
> Compile Time 00:00:17.276368
> Execution Time00:00:00.00
>
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>53722
>
[jira] [Commented] (TRAFODION-2136) union all can't work efficiently
[
https://issues.apache.org/jira/browse/TRAFODION-2136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608281#comment-16608281
]
liu ming commented on TRAFODION-2136:
-
TRAFODION-3192 treat this issue. Thanks Sandhya.
> union all can't work efficiently
>
>
> Key: TRAFODION-2136
> URL: https://issues.apache.org/jira/browse/TRAFODION-2136
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
>Affects Versions: any
>Reporter: Joshua Liu
>Assignee: liu ming
>Priority: Major
>
> there is one query called a
> the first time we run
> a;
> and get the elapsed time time1
> reconnect the database;
> the second time we run
> a union all a;
> and get another elapsed time.time2
> here time2 ≈ time1*2
> -
> see below for detailed info
> a is
> select count(*)
> from F_INCOME_DAY_RH a left join D_IN_SORTCODE_NEW b
> on (A.INCOMESORTCODE_N = B.CODE1)
> where (((a.BBQ >= date '2014-01-01') AND (a.BBQ <= date '2014-12-31')) AND
> ((a.BUDGETLEVEL = '3') AND
> ((a.TAXORGCODE in ('1', '2', '3', '4', '5'))) AND
> (a.DISTRICT_CO_CODE like 'A%' or
> a.DISTRICT_CO_CODE like 'B%')) AND
> ((a.INCOMESORTCODE_N LIKE 'A%') OR
> (a.INCOMESORTCODE_N LIKE 'B%') OR
> (a.INCOMESORTCODE_N LIKE 'C%') OR
> (a.INCOMESORTCODE_N LIKE 'F%') OR
> (a.INCOMESORTCODE_N LIKE 'G%')))
> group by b.CODE5
> -
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 7.8root 6.00E+000
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
> SQL>set statistics on;
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>53722
> 5573
> --- 5 row(s) selected.
>
> Start Time 2016/07/30 09:47:50.913298
> End Time 2016/07/30 09:48:05.018125
> Elapsed Time 00:00:14.104827
> Compile Time 00:00:05.641437
> Execution Time00:00:14.104827
> ---
> reconnect database and run a union all a;
> SQL>explain options 'f' s1;
>
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> -
>
> 15 .16 root 1.20E+001
> 714 15 merge_union 1.20E+001
> 13 .14 hash_partial_groupby 6.00E+000
> 12 .13 esp_exchange1:16(hash2) 6.00E+000
> 11 .12 hash_partial_groupby 6.00E+000
> 10 911 left_hybrid_hash_joi 1.06E+006
> ..10 trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 8.9esp_exchange16(rep-b):1 (m) 7.24E+002
> ..8trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> 6.7hash_partial_groupby 6.00E+000
> 5.6esp_exchange1:16(hash2) 6.00E+000
> 4.5hash_partial_groupby 6.00E+000
> 324left_hybrid_hash_joi 1.06E+006
> ..3trafodion_scan F_INCOME_DAY_RH 1.06E+006
> 1.2esp_exchange16(rep-b):1 (m) 7.24E+002
> ..1trafodion_scan D_IN_SORTCODE_NEW 7.24E+002
> --- SQL operation complete.
>
> Start Time 2016/07/30 09:48:28.230061
> End Time 2016/07/30 09:48:45.506429
> Elapsed Time 00:00:17.276368
> Compile Time 00:00:17.276368
> Execution Time00:00:00.00
>
> SQL>execute s1;
> (EXPR)
>
> 977626
>16080
>34817
>
[jira] [Commented] (TRAFODION-3181) enhance ExeCliInterface fetchAllRows to get more than 100 rows
[ https://issues.apache.org/jira/browse/TRAFODION-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16607313#comment-16607313 ] liu ming commented on TRAFODION-3181: - I misunderstand the code. It is not 100 rows, but 100 columns. > enhance ExeCliInterface fetchAllRows to get more than 100 rows > -- > > Key: TRAFODION-3181 > URL: https://issues.apache.org/jira/browse/TRAFODION-3181 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > At present, FetchAllRows can only retrieve not more than 100 rows. > Should break this limitation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3193) update reference manual about the new CQD
[ https://issues.apache.org/jira/browse/TRAFODION-3193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3193 started by liu ming. --- > update reference manual about the new CQD > - > > Key: TRAFODION-3193 > URL: https://issues.apache.org/jira/browse/TRAFODION-3193 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > TRAFODION-2952 introduce a new CQD -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3193) update reference manual about the new CQD
liu ming created TRAFODION-3193: --- Summary: update reference manual about the new CQD Key: TRAFODION-3193 URL: https://issues.apache.org/jira/browse/TRAFODION-3193 Project: Apache Trafodion Issue Type: Sub-task Reporter: liu ming Assignee: liu ming TRAFODION-2952 introduce a new CQD -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-2952) large amount of data will cause error in sequence generating
[ https://issues.apache.org/jira/browse/TRAFODION-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-2952. - Resolution: Fixed Fix Version/s: 2.4 > large amount of data will cause error in sequence generating > > > Key: TRAFODION-2952 > URL: https://issues.apache.org/jira/browse/TRAFODION-2952 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > insert error > ** ERROR[1583] Sequence metadata could not be updated. > create table test1 > (id LARGEINT not null > ) primary key(id) > SALT USING 48 PARTITIONS > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ); > create table test2 > (id LARGEINT not null > ) primary key(id) > SALT USING 48 PARTITIONS > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ); > create sequence seq ; > alter sequence seq cache 2; > upsert into test2 select seqnum(seq, next) from test1; > test1 table has about 4 billion rows. When error raised , next value of seq > is 531 > CREATE SEQUENCE TRAFODION.SEABASE.SEQ > START WITH 1 /* NEXT AVAILABLE VALUE 531 */ > INCREMENT BY 1 > MAXVALUE 9223372036854775806 > MINVALUE 1 > CACHE 2 > NO CYCLE > LARGEINT > ; -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-2968) update SQL manual for MySQL functions unix_timestamp, uuid, sleep etc
[ https://issues.apache.org/jira/browse/TRAFODION-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-2968. - Resolution: Fixed Fix Version/s: 2.4 > update SQL manual for MySQL functions unix_timestamp, uuid, sleep etc > - > > Key: TRAFODION-2968 > URL: https://issues.apache.org/jira/browse/TRAFODION-2968 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > update the SQL manual to clearly state the non-deterministic fashion of newly > added MySQL functions: > uuid > unix_timestamp > sleep -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3117) support Oracle (+) syntax for outer join
[ https://issues.apache.org/jira/browse/TRAFODION-3117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3117 started by liu ming. --- > support Oracle (+) syntax for outer join > > > Key: TRAFODION-3117 > URL: https://issues.apache.org/jira/browse/TRAFODION-3117 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > support Oracle (+) syntax for outer join > More details will be added later -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-2404) enhance REGEXP performance
[ https://issues.apache.org/jira/browse/TRAFODION-2404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-2404. - Resolution: Fixed Fix Version/s: 2.4 > enhance REGEXP performance > -- > > Key: TRAFODION-2404 > URL: https://issues.apache.org/jira/browse/TRAFODION-2404 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > There are rooms to enhance the performance of REGEXP from code review > comments by Dave Birdsall. More details will be added. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-2952) large amount of data will cause error in sequence generating
[ https://issues.apache.org/jira/browse/TRAFODION-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16588892#comment-16588892 ] liu ming commented on TRAFODION-2952: - I propose to add a CQD to control the sequence retry number and time. So for this kind of special case, there is a way to reduce the sequence error, which will interrupt the load process. > large amount of data will cause error in sequence generating > > > Key: TRAFODION-2952 > URL: https://issues.apache.org/jira/browse/TRAFODION-2952 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > insert error > ** ERROR[1583] Sequence metadata could not be updated. > create table test1 > (id LARGEINT not null > ) primary key(id) > SALT USING 48 PARTITIONS > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ); > create table test2 > (id LARGEINT not null > ) primary key(id) > SALT USING 48 PARTITIONS > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ); > create sequence seq ; > alter sequence seq cache 2; > upsert into test2 select seqnum(seq, next) from test1; > test1 table has about 4 billion rows. When error raised , next value of seq > is 531 > CREATE SEQUENCE TRAFODION.SEABASE.SEQ > START WITH 1 /* NEXT AVAILABLE VALUE 531 */ > INCREMENT BY 1 > MAXVALUE 9223372036854775806 > MINVALUE 1 > CACHE 2 > NO CYCLE > LARGEINT > ; -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-2062) Query fails with SQL ERROR[1583] when the Hive Metastore Server Instance process is killed
[ https://issues.apache.org/jira/browse/TRAFODION-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming closed TRAFODION-2062. --- Resolution: Won't Fix > Query fails with SQL ERROR[1583] when the Hive Metastore Server Instance > process is killed > -- > > Key: TRAFODION-2062 > URL: https://issues.apache.org/jira/browse/TRAFODION-2062 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general >Affects Versions: 2.0-incubating, 2.1-incubating >Reporter: Atanu Mishra >Assignee: liu ming >Priority: Major > > Below test scenarios for multi threads program enhanced test, and tried it > several times, > HMSI - Hive Metastore Server Instance > Step 0. HMSI is running. > Step 1. Start multi threads program > Step 2. Total 32 mxosrvr(s) connected in multi threads program. > Step 3. Stop HMSI. > Step 4. Back to multi threads program, it still running, waiting it completed. >At the same time, after HMSI stopped completely, 32 mxosrvr(s) still > connected, that’s expected. > Step 5. Check multi threads program output and the log file. > > DEBUG: plan to delete total rows is 291488 > DEBUG: remaining rows to delete is 291400 > DEBUG: Remaining rows 310909 > DEBUG: Total rows 311000 > DEBUG: Deleted rows 88 > DEBUG: Missing insertion rows 3# please note that here 3 is > not fixed, if you run several times, it will be changed other number. > Total Tests=1 Failed=1 > > In the log file we can see the error below, which is not expected. > > 13:46:52 ***ERROR: SQLExecDirect: Expected: SQL_SUCCESS Actual: SQL_ERROR >File: ../../../../src/coast/coast_unified/src/jmtload.c Line: 187 > # please note that here 187 line is used to insert a row > into table >State: X01G7 >Native Error: 4294965713 >Error: [Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** > ERROR[1583] Sequence metadata could not be updated. [2016-06-07 13:46:52] > > If skip step 3, this error does not show up, > > DEBUG: plan to delete total rows is 145895 > DEBUG: remaining rows to delete is 145809 > DEBUG: Remaining rows 310914 > DEBUG: Total rows 311000 > DEBUG: Deleted rows 86 > DEBUG: Missing insertion rows 0 > Total Tests=1 Failed=0 > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-2404) enhance REGEXP performance
[ https://issues.apache.org/jira/browse/TRAFODION-2404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2404 started by liu ming. --- > enhance REGEXP performance > -- > > Key: TRAFODION-2404 > URL: https://issues.apache.org/jira/browse/TRAFODION-2404 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > There are rooms to enhance the performance of REGEXP from code review > comments by Dave Birdsall. More details will be added. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3182) clean useless Monitor log ERROR information
[ https://issues.apache.org/jira/browse/TRAFODION-3182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3182. - Resolution: Fixed Fix Version/s: 2.4 > clean useless Monitor log ERROR information > --- > > Key: TRAFODION-3182 > URL: https://issues.apache.org/jira/browse/TRAFODION-3182 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > In mornitor log, there are a lot of error messages: > 2018-04-19 14:29:41,708, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=59 > 2018-04-19 14:29:46,492, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=64 > 2018-04-19 14:30:46,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=67 > 2018-04-19 14:31:51,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin > pipe fd=55 > 2018-04-19 14:31:55,358, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin > pipe fd=59 > 2018-04-19 14:32:07,891, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[500714]. Closing stdin > pipe fd=55 > > These are harmless ERRORs, but it will flood the log file and make the > administrator very confusing, we should remove them. > > > > > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3175) enhance ExeCliInterface get interface to return null indicator
[ https://issues.apache.org/jira/browse/TRAFODION-3175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3175. - Resolution: Fixed > enhance ExeCliInterface get interface to return null indicator > -- > > Key: TRAFODION-3175 > URL: https://issues.apache.org/jira/browse/TRAFODION-3175 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > It will be helpful that this interface get method can return null indicator. > It is now no way to tell a value is null or not. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-2968) update SQL manual for MySQL functions unix_timestamp, uuid, sleep etc
[ https://issues.apache.org/jira/browse/TRAFODION-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2968 started by liu ming. --- > update SQL manual for MySQL functions unix_timestamp, uuid, sleep etc > - > > Key: TRAFODION-2968 > URL: https://issues.apache.org/jira/browse/TRAFODION-2968 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > update the SQL manual to clearly state the non-deterministic fashion of newly > added MySQL functions: > uuid > unix_timestamp > sleep -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-1881) Follow up TRAFODION-1858 , need a better fix
[ https://issues.apache.org/jira/browse/TRAFODION-1881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-1881. - Resolution: Fixed Fix Version/s: 2.4 > Follow up TRAFODION-1858 , need a better fix > > > Key: TRAFODION-1881 > URL: https://issues.apache.org/jira/browse/TRAFODION-1881 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > TRAFODION-1858 is now fixed using a temp method. A better and complete > solution is required. > But to solve it entirely, it requires a more throughout refactor of many > related parts of code. > It is a real customer blocking issue, so we fix it with the temp solution and > using this JIRA to follow up. > The solution in TRAFODION-1858 is to add a new method to check the string > name of a given column to tell if it is SALT column, or DIVSION column. The > checking method is hardcoding the naming conversion, which may change and > break the function. > However, to use NAColumn's built-in helper checking methods, it needs the SQL > compiler to generate correct constraint info from begining and change all the > intermediate objects along the path. It may also need to change the METATABLE > which contains information about constraints. > So we use this JIRA to track, and need a longer time to find a good solution > to solve TRAFODION-1858. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3182) clean useless Monitor log ERROR information
[ https://issues.apache.org/jira/browse/TRAFODION-3182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3182 started by liu ming. --- > clean useless Monitor log ERROR information > --- > > Key: TRAFODION-3182 > URL: https://issues.apache.org/jira/browse/TRAFODION-3182 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > In mornitor log, there are a lot of error messages: > 2018-04-19 14:29:41,708, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=59 > 2018-04-19 14:29:46,492, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=64 > 2018-04-19 14:30:46,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=67 > 2018-04-19 14:31:51,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin > pipe fd=55 > 2018-04-19 14:31:55,358, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin > pipe fd=59 > 2018-04-19 14:32:07,891, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[500714]. Closing stdin > pipe fd=55 > > These are harmless ERRORs, but it will flood the log file and make the > administrator very confusing, we should remove them. > > > > > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-1881) Follow up TRAFODION-1858 , need a better fix
[ https://issues.apache.org/jira/browse/TRAFODION-1881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-1881 started by liu ming. --- > Follow up TRAFODION-1858 , need a better fix > > > Key: TRAFODION-1881 > URL: https://issues.apache.org/jira/browse/TRAFODION-1881 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > TRAFODION-1858 is now fixed using a temp method. A better and complete > solution is required. > But to solve it entirely, it requires a more throughout refactor of many > related parts of code. > It is a real customer blocking issue, so we fix it with the temp solution and > using this JIRA to follow up. > The solution in TRAFODION-1858 is to add a new method to check the string > name of a given column to tell if it is SALT column, or DIVSION column. The > checking method is hardcoding the naming conversion, which may change and > break the function. > However, to use NAColumn's built-in helper checking methods, it needs the SQL > compiler to generate correct constraint info from begining and change all the > intermediate objects along the path. It may also need to change the METATABLE > which contains information about constraints. > So we use this JIRA to track, and need a longer time to find a good solution > to solve TRAFODION-1858. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3175) enhance ExeCliInterface get interface to return null indicator
[ https://issues.apache.org/jira/browse/TRAFODION-3175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3175 started by liu ming. --- > enhance ExeCliInterface get interface to return null indicator > -- > > Key: TRAFODION-3175 > URL: https://issues.apache.org/jira/browse/TRAFODION-3175 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > It will be helpful that this interface get method can return null indicator. > It is now no way to tell a value is null or not. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Reopened] (TRAFODION-3175) enhance ExeCliInterface get interface to return null indicator
[ https://issues.apache.org/jira/browse/TRAFODION-3175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reopened TRAFODION-3175: - Sorry it is still an issue for FetchAllRows > enhance ExeCliInterface get interface to return null indicator > -- > > Key: TRAFODION-3175 > URL: https://issues.apache.org/jira/browse/TRAFODION-3175 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > It will be helpful that this interface get method can return null indicator. > It is now no way to tell a value is null or not. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (TRAFODION-3181) enhance ExeCliInterface fetchAllRows to get more than 100 rows
[ https://issues.apache.org/jira/browse/TRAFODION-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-3181: --- Assignee: liu ming > enhance ExeCliInterface fetchAllRows to get more than 100 rows > -- > > Key: TRAFODION-3181 > URL: https://issues.apache.org/jira/browse/TRAFODION-3181 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > At present, FetchAllRows can only retrieve not more than 100 rows. > Should break this limitation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-3175) enhance ExeCliInterface get interface to return null indicator
[ https://issues.apache.org/jira/browse/TRAFODION-3175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming closed TRAFODION-3175. --- Resolution: Invalid Fix Version/s: 2.4 Not an issue. It is my mistake, the interface support null indicator > enhance ExeCliInterface get interface to return null indicator > -- > > Key: TRAFODION-3175 > URL: https://issues.apache.org/jira/browse/TRAFODION-3175 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > It will be helpful that this interface get method can return null indicator. > It is now no way to tell a value is null or not. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3182) clean useless Monitor log ERROR information
[ https://issues.apache.org/jira/browse/TRAFODION-3182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16574844#comment-16574844 ] liu ming commented on TRAFODION-3182: - And these: 2018-08-08 20:08:52,964, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=11295 for stdin data request. 2018-08-08 20:08:53,970, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=11311 for stdin data request. 2018-08-08 20:14:44,147, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=25537 for stdin data request. 2018-08-08 20:26:11,812, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=13843 for stdin data request. 2018-08-08 20:26:11,812, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=13844 for stdin data request. 2018-08-08 20:28:27,847, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=14022 for stdin data request. 2018-08-08 20:28:27,847, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=14023 for stdin data request. 2018-08-08 21:33:19,501, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=29616 for stdin data request. 2018-08-08 21:33:19,516, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=29617 for stdin data request. 2018-08-08 21:37:40,943, INFO, MON, Node Number: 0,, PIN: 11057 , Process Name: $MONITOR,,, TID: 11057, Message ID: 101010609, [CCluster::HandleOtherNodeMsg], Can't find process nid=1, pid=31108 for stdin data request. > clean useless Monitor log ERROR information > --- > > Key: TRAFODION-3182 > URL: https://issues.apache.org/jira/browse/TRAFODION-3182 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > In mornitor log, there are a lot of error messages: > 2018-04-19 14:29:41,708, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=59 > 2018-04-19 14:29:46,492, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=64 > 2018-04-19 14:30:46,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin > pipe fd=67 > 2018-04-19 14:31:51,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin > pipe fd=55 > 2018-04-19 14:31:55,358, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin > pipe fd=59 > 2018-04-19 14:32:07,891, ERROR, MON, Node Number: 0,, PIN: 18578 , Process > Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], > unable to obtain file info for stdin file, file=pipe:[500714]. Closing stdin > pipe fd=55 > > These are harmless ERRORs, but it will flood the log file and make the > administrator very confusing, we should remove them. > > > > > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3182) clean useless Monitor log ERROR information
liu ming created TRAFODION-3182: --- Summary: clean useless Monitor log ERROR information Key: TRAFODION-3182 URL: https://issues.apache.org/jira/browse/TRAFODION-3182 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming In mornitor log, there are a lot of error messages: 2018-04-19 14:29:41,708, ERROR, MON, Node Number: 0,, PIN: 18578 , Process Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin pipe fd=59 2018-04-19 14:29:46,492, ERROR, MON, Node Number: 0,, PIN: 18578 , Process Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin pipe fd=64 2018-04-19 14:30:46,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], unable to obtain file info for stdin file, file=pipe:[469099]. Closing stdin pipe fd=67 2018-04-19 14:31:51,340, ERROR, MON, Node Number: 0,, PIN: 18578 , Process Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin pipe fd=55 2018-04-19 14:31:55,358, ERROR, MON, Node Number: 0,, PIN: 18578 , Process Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], unable to obtain file info for stdin file, file=pipe:[498421]. Closing stdin pipe fd=59 2018-04-19 14:32:07,891, ERROR, MON, Node Number: 0,, PIN: 18578 , Process Name: $MONITOR,,, TID: 18650, Message ID: 101130601, [CRedirector::stdinFd], unable to obtain file info for stdin file, file=pipe:[500714]. Closing stdin pipe fd=55 These are harmless ERRORs, but it will flood the log file and make the administrator very confusing, we should remove them. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3181) enhance ExeCliInterface fetchAllRows to get more than 100 rows
liu ming created TRAFODION-3181: --- Summary: enhance ExeCliInterface fetchAllRows to get more than 100 rows Key: TRAFODION-3181 URL: https://issues.apache.org/jira/browse/TRAFODION-3181 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming At present, FetchAllRows can only retrieve not more than 100 rows. Should break this limitation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3172) add documentation for sys_guid function
[ https://issues.apache.org/jira/browse/TRAFODION-3172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3172. - Resolution: Fixed Fix Version/s: 2.4 > add documentation for sys_guid function > --- > > Key: TRAFODION-3172 > URL: https://issues.apache.org/jira/browse/TRAFODION-3172 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > update the manual -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3173) enhance ExeCliInterface fetchAllRows to save the data type
[ https://issues.apache.org/jira/browse/TRAFODION-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3173. - Resolution: Fixed Fix Version/s: 2.4 > enhance ExeCliInterface fetchAllRows to save the data type > -- > > Key: TRAFODION-3173 > URL: https://issues.apache.org/jira/browse/TRAFODION-3173 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > At present ExeCliInterface method fetchAllRows will not save the data type of > each column, since the current usage is always for string type. > To implement some new features, I found I need this method to save the data > type and later the OutputInfo class get method should also be enhanced to get > the data type back. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3168) add a sqshell cmd to show env var value
[ https://issues.apache.org/jira/browse/TRAFODION-3168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3168. - Resolution: Fixed Fix Version/s: 2.4 > add a sqshell cmd to show env var value > --- > > Key: TRAFODION-3168 > URL: https://issues.apache.org/jira/browse/TRAFODION-3168 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > To detect the STFS configuration in ms.env. It will be helpful if there is a > sqshell command to show that value, instead of a script to parse it, since it > may not be identical with the real process get. > And this will also be a helpful cmd itself when do trouble-shooting of > Trafodion. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3163) add tools for trouble-shooting
[ https://issues.apache.org/jira/browse/TRAFODION-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3163. - Resolution: Fixed Fix Version/s: 2.4 > add tools for trouble-shooting > -- > > Key: TRAFODION-3163 > URL: https://issues.apache.org/jira/browse/TRAFODION-3163 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.4 > > > This will be an umbrella JIRA, from this JIRA, I will add a script to check > the health of STFS. > I suggest we can add more tools from the field experience and enhance the > trouble-shooting capability of Trafodion. > > For this case, we found SQL run into error, but the error message didn't tell > anything about STFS. After a long time debugging, it turns out STFS > configuration is wrong. > > So I want to add a tool to check the STFS status.The tool is very simple, ssh > to each node, and for each STFS dir, touch a file, if not able to touch a > file, report error. > > If we meet some other useful trouble shooting cases, and it will good to put > a tool, so we can have a tool-set to run to help debug real issues. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3176) add support for charIndex function
liu ming created TRAFODION-3176: --- Summary: add support for charIndex function Key: TRAFODION-3176 URL: https://issues.apache.org/jira/browse/TRAFODION-3176 Project: Apache Trafodion Issue Type: Sub-task Reporter: liu ming Assignee: liu ming add SQL Server function charIndex() described: [https://docs.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-2017] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3175) enhance ExeCliInterface get interface to return null indicator
liu ming created TRAFODION-3175: --- Summary: enhance ExeCliInterface get interface to return null indicator Key: TRAFODION-3175 URL: https://issues.apache.org/jira/browse/TRAFODION-3175 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming It will be helpful that this interface get method can return null indicator. It is now no way to tell a value is null or not. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3173) enhance ExeCliInterface fetchAllRows to save the data type
[ https://issues.apache.org/jira/browse/TRAFODION-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3173 started by liu ming. --- > enhance ExeCliInterface fetchAllRows to save the data type > -- > > Key: TRAFODION-3173 > URL: https://issues.apache.org/jira/browse/TRAFODION-3173 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > At present ExeCliInterface method fetchAllRows will not save the data type of > each column, since the current usage is always for string type. > To implement some new features, I found I need this method to save the data > type and later the OutputInfo class get method should also be enhanced to get > the data type back. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3173) enhance ExeCliInterface fetchAllRows to save the data type
liu ming created TRAFODION-3173: --- Summary: enhance ExeCliInterface fetchAllRows to save the data type Key: TRAFODION-3173 URL: https://issues.apache.org/jira/browse/TRAFODION-3173 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming At present ExeCliInterface method fetchAllRows will not save the data type of each column, since the current usage is always for string type. To implement some new features, I found I need this method to save the data type and later the OutputInfo class get method should also be enhanced to get the data type back. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3163) add tools for trouble-shooting
[ https://issues.apache.org/jira/browse/TRAFODION-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3163 started by liu ming. --- > add tools for trouble-shooting > -- > > Key: TRAFODION-3163 > URL: https://issues.apache.org/jira/browse/TRAFODION-3163 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > This will be an umbrella JIRA, from this JIRA, I will add a script to check > the health of STFS. > I suggest we can add more tools from the field experience and enhance the > trouble-shooting capability of Trafodion. > > For this case, we found SQL run into error, but the error message didn't tell > anything about STFS. After a long time debugging, it turns out STFS > configuration is wrong. > > So I want to add a tool to check the STFS status.The tool is very simple, ssh > to each node, and for each STFS dir, touch a file, if not able to touch a > file, report error. > > If we meet some other useful trouble shooting cases, and it will good to put > a tool, so we can have a tool-set to run to help debug real issues. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3165) HDFS storage option not work well if table use namespace
[ https://issues.apache.org/jira/browse/TRAFODION-3165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3165 started by liu ming. --- > HDFS storage option not work well if table use namespace > > > Key: TRAFODION-3165 > URL: https://issues.apache.org/jira/browse/TRAFODION-3165 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > If the table is under a namespace, the current code logic will find wrong path -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work stopped] (TRAFODION-3167) add central maven url for sql pom.xml
[ https://issues.apache.org/jira/browse/TRAFODION-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3167 stopped by liu ming. --- > add central maven url for sql pom.xml > - > > Key: TRAFODION-3167 > URL: https://issues.apache.org/jira/browse/TRAFODION-3167 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > Current maven dependency alluxio is configured to download from cloudera > repository. It is not accessible stably sometimes. Add Maven central > repository URL. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3168) add a sqshell cmd to show env var value
[ https://issues.apache.org/jira/browse/TRAFODION-3168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3168 started by liu ming. --- > add a sqshell cmd to show env var value > --- > > Key: TRAFODION-3168 > URL: https://issues.apache.org/jira/browse/TRAFODION-3168 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > To detect the STFS configuration in ms.env. It will be helpful if there is a > sqshell command to show that value, instead of a script to parse it, since it > may not be identical with the real process get. > And this will also be a helpful cmd itself when do trouble-shooting of > Trafodion. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3167) add central maven url for sql pom.xml
[ https://issues.apache.org/jira/browse/TRAFODION-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3167. - Resolution: Fixed Fix Version/s: 2.3 > add central maven url for sql pom.xml > - > > Key: TRAFODION-3167 > URL: https://issues.apache.org/jira/browse/TRAFODION-3167 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > Current maven dependency alluxio is configured to download from cloudera > repository. It is not accessible stably sometimes. Add Maven central > repository URL. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3167) add central maven url for sql pom.xml
[ https://issues.apache.org/jira/browse/TRAFODION-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3167 started by liu ming. --- > add central maven url for sql pom.xml > - > > Key: TRAFODION-3167 > URL: https://issues.apache.org/jira/browse/TRAFODION-3167 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > Current maven dependency alluxio is configured to download from cloudera > repository. It is not accessible stably sometimes. Add Maven central > repository URL. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3167) add central maven url for sql pom.xml
liu ming created TRAFODION-3167: --- Summary: add central maven url for sql pom.xml Key: TRAFODION-3167 URL: https://issues.apache.org/jira/browse/TRAFODION-3167 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming Assignee: liu ming Current maven dependency alluxio is configured to download from cloudera repository. It is not accessible stably sometimes. Add Maven central repository URL. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-482) LP Bug: 1349985 - add support for sequence numbers
[ https://issues.apache.org/jira/browse/TRAFODION-482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming closed TRAFODION-482. -- Resolution: Fixed Fix Version/s: 1.3-incubating > LP Bug: 1349985 - add support for sequence numbers > -- > > Key: TRAFODION-482 > URL: https://issues.apache.org/jira/browse/TRAFODION-482 > Project: Apache Trafodion > Issue Type: Wish > Components: sql-exe >Reporter: Anoop Sharma >Assignee: Anoop Sharma >Priority: Minor > Fix For: 1.3-incubating, 1.0 (pre-incubation) > > > Need support for sequence objects that could be used to generate sequence > numbers. > Enhance and add create/drop/alter sequence statements. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3165) HDFS storage option not work well if table use namespace
liu ming created TRAFODION-3165: --- Summary: HDFS storage option not work well if table use namespace Key: TRAFODION-3165 URL: https://issues.apache.org/jira/browse/TRAFODION-3165 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming Assignee: liu ming If the table is under a namespace, the current code logic will find wrong path -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3163) add tools for trouble-shooting
liu ming created TRAFODION-3163: --- Summary: add tools for trouble-shooting Key: TRAFODION-3163 URL: https://issues.apache.org/jira/browse/TRAFODION-3163 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming This will be an umbrella JIRA, from this JIRA, I will add a script to check the health of STFS. I suggest we can add more tools from the field experience and enhance the trouble-shooting capability of Trafodion. For this case, we found SQL run into error, but the error message didn't tell anything about STFS. After a long time debugging, it turns out STFS configuration is wrong. So I want to add a tool to check the STFS status.The tool is very simple, ssh to each node, and for each STFS dir, touch a file, if not able to touch a file, report error. If we meet some other useful trouble shooting cases, and it will good to put a tool, so we can have a tool-set to run to help debug real issues. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3162) fix sql regression due to trafodion-3101
[ https://issues.apache.org/jira/browse/TRAFODION-3162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3162. - Resolution: Fixed Fix Version/s: 2.3 > fix sql regression due to trafodion-3101 > - > > Key: TRAFODION-3162 > URL: https://issues.apache.org/jira/browse/TRAFODION-3162 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > Some regression test not update well -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3162) fix sql regression due to trafodion-3101
[ https://issues.apache.org/jira/browse/TRAFODION-3162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3162 started by liu ming. --- > fix sql regression due to trafodion-3101 > - > > Key: TRAFODION-3162 > URL: https://issues.apache.org/jira/browse/TRAFODION-3162 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > Some regression test not update well -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (TRAFODION-3122) For each table, add a label file, for some use case can use this label file to read stats
[ https://issues.apache.org/jira/browse/TRAFODION-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming closed TRAFODION-3122. --- Resolution: Invalid not a good idea, close this JIRA > For each table, add a label file, for some use case can use this label file > to read stats > - > > Key: TRAFODION-3122 > URL: https://issues.apache.org/jira/browse/TRAFODION-3122 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > Add a label file in HDFS for each trafodion table, it can be used to save > basic stats for a given table. > For example, after load, update the label file with rows loaded. > If later, the table is not updated, when user issue count(*), can use this > label file to get count, to improve the count performance. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3162) fix sql regression due to trafodion-3101
liu ming created TRAFODION-3162: --- Summary: fix sql regression due to trafodion-3101 Key: TRAFODION-3162 URL: https://issues.apache.org/jira/browse/TRAFODION-3162 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming Assignee: liu ming Some regression test not update well -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3145) Make "hbase_options" as default setting and use cqd to change the default setting
[ https://issues.apache.org/jira/browse/TRAFODION-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3145. - Resolution: Fixed Fix Version/s: 2.3 > Make "hbase_options" as default setting and use cqd to change the default > setting > - > > Key: TRAFODION-3145 > URL: https://issues.apache.org/jira/browse/TRAFODION-3145 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > As we know, for performance thinking, we always need to add below syntax in > “create table” syntax. And I know in latest version, we have made “ATTRIBUTES > ALIGNED FORMAT” as default, do we have a plan that make > HBASE_OPTIONS(including ENCODING、COMPRESSION、MEMESTORE) as the default > setting when creating table? I think this will be easier for end users? > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ) > ; -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3137) speed up count(*) by read row count from stats in special use cases
[ https://issues.apache.org/jira/browse/TRAFODION-3137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551754#comment-16551754 ] liu ming commented on TRAFODION-3137: - This is only for the very first count star without any predicate. In other words, after data loading, and update stats, when at this time, run select count ( * ) from t; Then, it is possible to get the exact row count from stats, since it is accurate. However, I still cannot find a way to tell the last modified time for a hbase table. HBase doesn't support it. So this feature is blocking. I am thinking of WAL, but it is also not very easy to tell the last WAL for a given table, HBase seems to save WAL per region not per table. So I still cannot find a way to do this now. The value is : a lot of users do a count star after data loading to check how many rows loaded. In many cases, if load 10 billions rows, the count star took hours, and it is a bad impression. In this case, read from stat is valid. > speed up count(*) by read row count from stats in special use cases > --- > > Key: TRAFODION-3137 > URL: https://issues.apache.org/jira/browse/TRAFODION-3137 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > If the table is bulkload once and no change, and finish update statistics. > When doing count(*), there is no need to scan the whole table, but to read > row count from stats -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3161) support STUFF function
[ https://issues.apache.org/jira/browse/TRAFODION-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551753#comment-16551753 ] liu ming commented on TRAFODION-3161: - Yes, Anoop. One of a user is using SQL Server and migrate to Trafodion, and wish to support this function. It is simple since Trafodion has similar function, so I create this Jira to support it. If it is part of ANSI overplay function, please take it as part of the task. Thanks, Ming > support STUFF function > -- > > Key: TRAFODION-3161 > URL: https://issues.apache.org/jira/browse/TRAFODION-3161 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: Anoop Sharma >Priority: Major > > support STUFF function for SQL Server -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (TRAFODION-3161) support STUFF function
[ https://issues.apache.org/jira/browse/TRAFODION-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-3161: --- Assignee: Anoop Sharma (was: liu ming) > support STUFF function > -- > > Key: TRAFODION-3161 > URL: https://issues.apache.org/jira/browse/TRAFODION-3161 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: Anoop Sharma >Priority: Major > > support STUFF function for SQL Server -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (TRAFODION-3161) support STUFF function
[ https://issues.apache.org/jira/browse/TRAFODION-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-3161: --- Assignee: liu ming (was: Anoop Sharma) > support STUFF function > -- > > Key: TRAFODION-3161 > URL: https://issues.apache.org/jira/browse/TRAFODION-3161 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > support STUFF function for SQL Server -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3101) enhance the 'get table' utility to return number of rows
[ https://issues.apache.org/jira/browse/TRAFODION-3101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3101. - Resolution: Fixed Fix Version/s: 2.3 > enhance the 'get table' utility to return number of rows > > > Key: TRAFODION-3101 > URL: https://issues.apache.org/jira/browse/TRAFODION-3101 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > when run 'get tables' command, it is desired to show the number of rows -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3161) support STUFF function
liu ming created TRAFODION-3161: --- Summary: support STUFF function Key: TRAFODION-3161 URL: https://issues.apache.org/jira/browse/TRAFODION-3161 Project: Apache Trafodion Issue Type: Sub-task Reporter: liu ming Assignee: liu ming support STUFF function for SQL Server -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3147) add sys_guid function
[ https://issues.apache.org/jira/browse/TRAFODION-3147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3147 started by liu ming. --- > add sys_guid function > - > > Key: TRAFODION-3147 > URL: https://issues.apache.org/jira/browse/TRAFODION-3147 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > add sys_guid as alias of UUID -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3147) add sys_guid function
liu ming created TRAFODION-3147: --- Summary: add sys_guid function Key: TRAFODION-3147 URL: https://issues.apache.org/jira/browse/TRAFODION-3147 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming add sys_guid as alias of UUID -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3146) Add SQL Server functions
liu ming created TRAFODION-3146: --- Summary: Add SQL Server functions Key: TRAFODION-3146 URL: https://issues.apache.org/jira/browse/TRAFODION-3146 Project: Apache Trafodion Issue Type: Umbrella Reporter: liu ming Assignee: liu ming To support SQL Server functions -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3145) Make "hbase_options" as default setting and use cqd to change the default setting
[ https://issues.apache.org/jira/browse/TRAFODION-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3145 started by liu ming. --- > Make "hbase_options" as default setting and use cqd to change the default > setting > - > > Key: TRAFODION-3145 > URL: https://issues.apache.org/jira/browse/TRAFODION-3145 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > As we know, for performance thinking, we always need to add below syntax in > “create table” syntax. And I know in latest version, we have made “ATTRIBUTES > ALIGNED FORMAT” as default, do we have a plan that make > HBASE_OPTIONS(including ENCODING、COMPRESSION、MEMESTORE) as the default > setting when creating table? I think this will be easier for end users? > ATTRIBUTES ALIGNED FORMAT > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ) > ; -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3145) Make "hbase_options" as default setting and use cqd to change the default setting
liu ming created TRAFODION-3145: --- Summary: Make "hbase_options" as default setting and use cqd to change the default setting Key: TRAFODION-3145 URL: https://issues.apache.org/jira/browse/TRAFODION-3145 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming As we know, for performance thinking, we always need to add below syntax in “create table” syntax. And I know in latest version, we have made “ATTRIBUTES ALIGNED FORMAT” as default, do we have a plan that make HBASE_OPTIONS(including ENCODING、COMPRESSION、MEMESTORE) as the default setting when creating table? I think this will be easier for end users? ATTRIBUTES ALIGNED FORMAT HBASE_OPTIONS ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY', MEMSTORE_FLUSH_SIZE = '1073741824' ) ; -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3137) speed up count(*) by read row count from stats in special use cases
liu ming created TRAFODION-3137: --- Summary: speed up count(*) by read row count from stats in special use cases Key: TRAFODION-3137 URL: https://issues.apache.org/jira/browse/TRAFODION-3137 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming If the table is bulkload once and no change, and finish update statistics. When doing count(*), there is no need to scan the whole table, but to read row count from stats -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3101) enhance the 'get table' utility to return number of rows
[ https://issues.apache.org/jira/browse/TRAFODION-3101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16528684#comment-16528684 ] liu ming commented on TRAFODION-3101: - Hi, Anoop, Sorry that my statement is too vague. This enhancement is not to get count(*) for each table, but the number of tables that 'get tables' returns. For example, there are 4 tables under sch1, 'get tables' will return 4 tables, so the count is 4. Ming > enhance the 'get table' utility to return number of rows > > > Key: TRAFODION-3101 > URL: https://issues.apache.org/jira/browse/TRAFODION-3101 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > when run 'get tables' command, it is desired to show the number of rows -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3026) add create option storage policy
[ https://issues.apache.org/jira/browse/TRAFODION-3026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3026. - Resolution: Fixed Fix Version/s: 2.3 > add create option storage policy > > > Key: TRAFODION-3026 > URL: https://issues.apache.org/jira/browse/TRAFODION-3026 > Project: Apache Trafodion > Issue Type: New Feature >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > HDFS support HSM, it is possible to specify the storage policy in HBase > column family attribute, so it can use the underlying storage policy -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3117) support Oracle (+) syntax for outer join
liu ming created TRAFODION-3117: --- Summary: support Oracle (+) syntax for outer join Key: TRAFODION-3117 URL: https://issues.apache.org/jira/browse/TRAFODION-3117 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming support Oracle (+) syntax for outer join More details will be added later -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (TRAFODION-2793) pagination function as mysql
[ https://issues.apache.org/jira/browse/TRAFODION-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-2793: --- Assignee: liu ming > pagination function as mysql > > > Key: TRAFODION-2793 > URL: https://issues.apache.org/jira/browse/TRAFODION-2793 > Project: Apache Trafodion > Issue Type: Improvement > Components: sql-general >Affects Versions: any >Reporter: Yuan Liu >Assignee: liu ming >Priority: Major > Fix For: any > > > [Yuan] > We have been asked several times about pagination function in Trafodion. As I > know, the only way we can do about pagination is as below, > select * from (select *,row_number() over() as rn from test) as t where t.rn > between 1 and 10; > But MYSQL and DB2 all have more graceful way, > • MYSQL > Select * from test limit 0,5; > • DB2 > Select * from test offset 0 rows fetch next 5 rows; > I am wondering that is it possible that we also suport such function? I am > not sure how much work it may take, just a suggestion~ > [Hans] > We don't have it right now, but it should be fairly easy to support the MySQL > syntax. > One thing that EsgynDB users will need to watch is that we have a parallel > DMBS where the rows don't always get returned in the same order. So, it is > important to add an ORDER BY to the query. > It is not too hard to support this syntax, but to really do this well, we > could add some more performance optimizations that would be harder to do: > • Favor nested joins for this type of queries > • Favor indexes that provide a natural order for this type of queries > • Possibly even cache some results -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3111) new checkin broken CentOS 7 code building
[ https://issues.apache.org/jira/browse/TRAFODION-3111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3111. - Resolution: Fixed Fix Version/s: 2.3 > new checkin broken CentOS 7 code building > - > > Key: TRAFODION-3111 > URL: https://issues.apache.org/jira/browse/TRAFODION-3111 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > Some new code checking broke the CentOS 7 build. > This will be a continuous task until we setup daily build on CentOS 7 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3113) filter out system tables for various get meta utilities
liu ming created TRAFODION-3113: --- Summary: filter out system tables for various get meta utilities Key: TRAFODION-3113 URL: https://issues.apache.org/jira/browse/TRAFODION-3113 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming Trafodion supports various GET utility, like get schemas; get tables; etc.. One requirement is to not display the SYSTEM objects, like when issue 'get tables', not showing the histogram tables. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3111) new checkin broken CentOS 7 code building
[ https://issues.apache.org/jira/browse/TRAFODION-3111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3111 started by liu ming. --- > new checkin broken CentOS 7 code building > - > > Key: TRAFODION-3111 > URL: https://issues.apache.org/jira/browse/TRAFODION-3111 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > Some new code checking broke the CentOS 7 build. > This will be a continuous task until we setup daily build on CentOS 7 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3111) new checkin broken CentOS 7 code building
liu ming created TRAFODION-3111: --- Summary: new checkin broken CentOS 7 code building Key: TRAFODION-3111 URL: https://issues.apache.org/jira/browse/TRAFODION-3111 Project: Apache Trafodion Issue Type: Sub-task Reporter: liu ming Assignee: liu ming Some new code checking broke the CentOS 7 build. This will be a continuous task until we setup daily build on CentOS 7 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3101) enhance the 'get table' utility to return number of rows
[ https://issues.apache.org/jira/browse/TRAFODION-3101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3101 started by liu ming. --- > enhance the 'get table' utility to return number of rows > > > Key: TRAFODION-3101 > URL: https://issues.apache.org/jira/browse/TRAFODION-3101 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > when run 'get tables' command, it is desired to show the number of rows -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3101) enhance the 'get table' utility to return number of rows
liu ming created TRAFODION-3101: --- Summary: enhance the 'get table' utility to return number of rows Key: TRAFODION-3101 URL: https://issues.apache.org/jira/browse/TRAFODION-3101 Project: Apache Trafodion Issue Type: Improvement Reporter: liu ming Assignee: liu ming when run 'get tables' command, it is desired to show the number of rows -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3025) order by clause in subquery does not work
[ https://issues.apache.org/jira/browse/TRAFODION-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3025. - Resolution: Fixed Fix Version/s: 2.3 > order by clause in subquery does not work > -- > > Key: TRAFODION-3025 > URL: https://issues.apache.org/jira/browse/TRAFODION-3025 > Project: Apache Trafodion > Issue Type: Task >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > CREATE TABLE TRAFODION.SEABASE.DT > ( > D1 DATE DEFAULT NULL NOT SERIALIZED > , T1 TIME(0) DEFAULT NULL NOT SERIALIZED > , TS1 TIMESTAMP(2) DEFAULT NULL NOT SERIALIZED > , TS2 TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED > ) > ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_RSRVD_3' > ; > insert into dt values(current_date,current_time,current_timestamp, > current_timestamp); > . > . > >>select * from dt; > D1 T1 TS1 TS2 > -- -- -- > 2018-03-27 14:44:36 2018-03-27 14:44:36.80 2018-03-27 14:44:36.808913 > 2018-04-16 12:08:37 2018-04-16 12:08:37.92 2018-04-16 12:08:37.922973 > 2018-04-16 12:08:39 2018-04-16 12:08:39.53 2018-04-16 12:08:39.530414 > 2018-04-16 12:08:40 2018-04-16 12:08:40.63 2018-04-16 12:08:40.634867 > 2018-04-16 12:08:42 2018-04-16 12:08:42.06 2018-04-16 12:08:42.069282 > 2018-04-16 12:08:42 2018-04-16 12:08:42.97 2018-04-16 12:08:42.971260 > 2018-04-16 12:08:43 2018-04-16 12:08:43.81 2018-04-16 12:08:43.812465 > 2018-04-16 12:08:44 2018-04-16 12:08:44.57 2018-04-16 12:08:44.578473 > 2018-04-16 12:08:45 2018-04-16 12:08:45.24 2018-04-16 12:08:45.240684 > 2018-04-16 12:08:45 2018-04-16 12:08:45.92 2018-04-16 12:08:45.923487 > 2018-04-16 12:08:46 2018-04-16 12:08:46.62 2018-04-16 12:08:46.623653 > --- 11 row(s) selected. > >>select * from dt order by ts1 desc; > D1 T1 TS1 TS2 > -- -- -- > 2018-04-16 12:08:46 2018-04-16 12:08:46.62 2018-04-16 12:08:46.623653 > 2018-04-16 12:08:45 2018-04-16 12:08:45.92 2018-04-16 12:08:45.923487 > 2018-04-16 12:08:45 2018-04-16 12:08:45.24 2018-04-16 12:08:45.240684 > 2018-04-16 12:08:44 2018-04-16 12:08:44.57 2018-04-16 12:08:44.578473 > 2018-04-16 12:08:43 2018-04-16 12:08:43.81 2018-04-16 12:08:43.812465 > 2018-04-16 12:08:42 2018-04-16 12:08:42.97 2018-04-16 12:08:42.971260 > 2018-04-16 12:08:42 2018-04-16 12:08:42.06 2018-04-16 12:08:42.069282 > 2018-04-16 12:08:40 2018-04-16 12:08:40.63 2018-04-16 12:08:40.634867 > 2018-04-16 12:08:39 2018-04-16 12:08:39.53 2018-04-16 12:08:39.530414 > 2018-04-16 12:08:37 2018-04-16 12:08:37.92 2018-04-16 12:08:37.922973 > 2018-03-27 14:44:36 2018-03-27 14:44:36.80 2018-03-27 14:44:36.808913 > --- 11 row(s) selected. > >>select * from (select * from dt order by ts1 desc); > D1 T1 TS1 TS2 > -- -- -- > 2018-03-27 14:44:36 2018-03-27 14:44:36.80 2018-03-27 14:44:36.808913 > 2018-04-16 12:08:37 2018-04-16 12:08:37.92 2018-04-16 12:08:37.922973 > 2018-04-16 12:08:39 2018-04-16 12:08:39.53 2018-04-16 12:08:39.530414 > 2018-04-16 12:08:40 2018-04-16 12:08:40.63 2018-04-16 12:08:40.634867 > 2018-04-16 12:08:42 2018-04-16 12:08:42.06 2018-04-16 12:08:42.069282 > 2018-04-16 12:08:42 2018-04-16 12:08:42.97 2018-04-16 12:08:42.971260 > 2018-04-16 12:08:43 2018-04-16 12:08:43.81 2018-04-16 12:08:43.812465 > 2018-04-16 12:08:44 2018-04-16 12:08:44.57 2018-04-16 12:08:44.578473 > 2018-04-16 12:08:45 2018-04-16 12:08:45.24 2018-04-16 12:08:45.240684 > 2018-04-16 12:08:45 2018-04-16 12:08:45.92 2018-04-16 12:08:45.923487 > 2018-04-16 12:08:46 2018-04-16 12:08:46.62 2018-04-16 12:08:46.623653 > --- 11 row(s) selected. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3053) seatrans pom files need to update
[ https://issues.apache.org/jira/browse/TRAFODION-3053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3053. - Resolution: Fixed Fix Version/s: 2.3 > seatrans pom files need to update > - > > Key: TRAFODION-3053 > URL: https://issues.apache.org/jira/browse/TRAFODION-3053 > Project: Apache Trafodion > Issue Type: Umbrella >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > To support various Hadoop version and distro, Trafodion created different pom > files. > The protoc part of the pom file not specify the version, so it always using > the latest version. > The current latest version of haddop plug-in is 3.0, which need JDK 1.8. So > some of the target cannot build. > Need to update pom files to reflect its own version of hadoop plug-in -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3076) update pom.xml.hdp for protobuf compile
[ https://issues.apache.org/jira/browse/TRAFODION-3076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3076. - Resolution: Fixed Fix Version/s: 2.3 > update pom.xml.hdp for protobuf compile > --- > > Key: TRAFODION-3076 > URL: https://issues.apache.org/jira/browse/TRAFODION-3076 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > hadoop-protobuf plugin is related to Hadoop version. > We need to make sure the Hadoop version is matching. > This is for HDP distro. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3025) order by clause in subquery does not work
[ https://issues.apache.org/jira/browse/TRAFODION-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16484029#comment-16484029 ] liu ming commented on TRAFODION-3025: - Hi, Anoop, The issue is the 'order by' will be eliminated. It is normal for most subquery, the only useful use case in my mind is 'order by' + 'limit n' in the sub-query. For example, to get top 10 result from a sub-query. All other requirement seems can be satisfied by move the order by out of sub-query, or just ignore it. So when there is a 'order by ' + 'first N' in the subquery, we may need to keep the sort , but I am not very enthusiastic to support this feature. But it is a good practice to understand the root and sub-query. So I will try to do it. Ming > order by clause in subquery does not work > -- > > Key: TRAFODION-3025 > URL: https://issues.apache.org/jira/browse/TRAFODION-3025 > Project: Apache Trafodion > Issue Type: Task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > CREATE TABLE TRAFODION.SEABASE.DT > ( > D1 DATE DEFAULT NULL NOT SERIALIZED > , T1 TIME(0) DEFAULT NULL NOT SERIALIZED > , TS1 TIMESTAMP(2) DEFAULT NULL NOT SERIALIZED > , TS2 TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED > ) > ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_RSRVD_3' > ; > insert into dt values(current_date,current_time,current_timestamp, > current_timestamp); > . > . > >>select * from dt; > D1 T1 TS1 TS2 > -- -- -- > 2018-03-27 14:44:36 2018-03-27 14:44:36.80 2018-03-27 14:44:36.808913 > 2018-04-16 12:08:37 2018-04-16 12:08:37.92 2018-04-16 12:08:37.922973 > 2018-04-16 12:08:39 2018-04-16 12:08:39.53 2018-04-16 12:08:39.530414 > 2018-04-16 12:08:40 2018-04-16 12:08:40.63 2018-04-16 12:08:40.634867 > 2018-04-16 12:08:42 2018-04-16 12:08:42.06 2018-04-16 12:08:42.069282 > 2018-04-16 12:08:42 2018-04-16 12:08:42.97 2018-04-16 12:08:42.971260 > 2018-04-16 12:08:43 2018-04-16 12:08:43.81 2018-04-16 12:08:43.812465 > 2018-04-16 12:08:44 2018-04-16 12:08:44.57 2018-04-16 12:08:44.578473 > 2018-04-16 12:08:45 2018-04-16 12:08:45.24 2018-04-16 12:08:45.240684 > 2018-04-16 12:08:45 2018-04-16 12:08:45.92 2018-04-16 12:08:45.923487 > 2018-04-16 12:08:46 2018-04-16 12:08:46.62 2018-04-16 12:08:46.623653 > --- 11 row(s) selected. > >>select * from dt order by ts1 desc; > D1 T1 TS1 TS2 > -- -- -- > 2018-04-16 12:08:46 2018-04-16 12:08:46.62 2018-04-16 12:08:46.623653 > 2018-04-16 12:08:45 2018-04-16 12:08:45.92 2018-04-16 12:08:45.923487 > 2018-04-16 12:08:45 2018-04-16 12:08:45.24 2018-04-16 12:08:45.240684 > 2018-04-16 12:08:44 2018-04-16 12:08:44.57 2018-04-16 12:08:44.578473 > 2018-04-16 12:08:43 2018-04-16 12:08:43.81 2018-04-16 12:08:43.812465 > 2018-04-16 12:08:42 2018-04-16 12:08:42.97 2018-04-16 12:08:42.971260 > 2018-04-16 12:08:42 2018-04-16 12:08:42.06 2018-04-16 12:08:42.069282 > 2018-04-16 12:08:40 2018-04-16 12:08:40.63 2018-04-16 12:08:40.634867 > 2018-04-16 12:08:39 2018-04-16 12:08:39.53 2018-04-16 12:08:39.530414 > 2018-04-16 12:08:37 2018-04-16 12:08:37.92 2018-04-16 12:08:37.922973 > 2018-03-27 14:44:36 2018-03-27 14:44:36.80 2018-03-27 14:44:36.808913 > --- 11 row(s) selected. > >>select * from (select * from dt order by ts1 desc); > D1 T1 TS1 TS2 > -- -- -- > 2018-03-27 14:44:36 2018-03-27 14:44:36.80 2018-03-27 14:44:36.808913 > 2018-04-16 12:08:37 2018-04-16 12:08:37.92 2018-04-16 12:08:37.922973 > 2018-04-16 12:08:39 2018-04-16 12:08:39.53 2018-04-16 12:08:39.530414 > 2018-04-16 12:08:40 2018-04-16 12:08:40.63 2018-04-16 12:08:40.634867 > 2018-04-16 12:08:42 2018-04-16 12:08:42.06 2018-04-16 12:08:42.069282 > 2018-04-16 12:08:42 2018-04-16 12:08:42.97 2018-04-16 12:08:42.971260 > 2018-04-16 12:08:43 2018-04-16 12:08:43.81 2018-04-16 12:08:43.812465 > 2018-04-16 12:08:44 2018-04-16 12:08:44.57 2018-04-16 12:08:44.578473 > 2018-04-16 12:08:45 2018-04-16 12:08:45.24 2018-04-16 12:08:45.240684 > 2018-04-16 12:08:45 2018-04-16 12:08:45.92 2018-04-16 12:08:45.923487 > 2018-04-16 12:08:46 2018-04-16 12:08:46.62 2018-04-16 12:08:46.623653 > --- 11 row(s) selected. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3015) retrieve a value from numeric type get no result if using xx='value'
[ https://issues.apache.org/jira/browse/TRAFODION-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-3015. - Resolution: Fixed Fix Version/s: (was: any) 2.3 > retrieve a value from numeric type get no result if using xx='value' > - > > Key: TRAFODION-3015 > URL: https://issues.apache.org/jira/browse/TRAFODION-3015 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general >Affects Versions: 2.2.0 >Reporter: Yuan Liu >Assignee: liu ming >Priority: Major > Fix For: 2.3 > > > select * from c_xkzsmgp_esg_5 where ticket_id = 27380468; returns one row. > select * from c_xkzsmgp_esg_5 where ticket_id = '27380468'; returns no row. > > Table DDL: > CREATE TABLE TRAFODION.SEABASE.C_XKZSMGP_ESG_5 > ( > TICKET_ID NUMERIC(19, 0) NO DEFAULT NOT NULL NOT > DROPPABLE NOT SERIALIZED > , CC VARCHAR(50 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , FCSJ TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED > , SEAT_NUM VARCHAR(10 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , DDZ VARCHAR(50 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , USERNAME VARCHAR(50 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , IDNUM VARCHAR(50 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , SPY VARCHAR(50 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , WD VARCHAR(50 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , SJLYSD VARCHAR(12 BYTES) CHARACTER SET UTF8 > COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED > , JLZLBS CHAR(1 CHAR) CHARACTER SET UTF8 COLLATE > DEFAULT DEFAULT _ISO88591'0' NOT NULL NOT DROPPABLE NOT SERIALIZED > , JLZXBS CHAR(1 CHAR) CHARACTER SET UTF8 COLLATE > DEFAULT DEFAULT _ISO88591'0' NOT SERIALIZED > , JLZXSJ TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED > , JLRKSJ TIMESTAMP(6) DEFAULT CURRENT NOT NULL NOT > DROPPABLE NOT SERIALIZED > , JLGXSJ TIMESTAMP(6) DEFAULT CURRENT NOT NULL NOT > DROPPABLE NOT SERIALIZED > , SFZJC NUMERIC(2, 0) DEFAULT NULL NOT SERIALIZED > , PRIMARY KEY (TICKET_ID ASC) > ) > SALT USING 5 PARTITIONS > ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_RSRVD_3' STORED DESC > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ) > ; > > query plans of two sqls are different: > select * from c_xkzsmgp_esg_5 where ticket_id = '27380468'; > begin_key .. (_SALT_ = (HashDistPartHash(( > 2.738046768E+007 narrow > \:_sys_ignored_CC_convErrorFlag)) Hash2Distrib > (cast(5) narrow > \:_sys_ignored_CC_convErrorFlag))) > , (TICKET_ID = 2.738046768E+007) > end_key (_SALT_ = (HashDistPartHash(( > 2.738046768E+007 narrow > \:_sys_ignored_CC_convErrorFlag)) Hash2Distrib (5 > narrow \:_sys_ignored_CC_convErrorFlag))), > (TICKET_ID = 2.738046768E+007) > > > select * from c_xkzsmgp_esg_5 where ticket_id = 27380468; > begin_key .. (_SALT_ = (HashDistPartHash(cast(%(27380468))) > Hash2Distrib (cast(5) narrow > \:_sys_ignored_CC_convErrorFlag))), > (TICKET_ID = %(27380468)) > end_key (_SALT_ = (HashDistPartHash((%(27380468) narrow > \:_sys_ignored_CC_convErrorFlag)) Hash2Distrib (5 > narrow \:_sys_ignored_CC_convErrorFlag))), > (TICKET_ID = %(27380468)) > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3078) SQL Regression fail on CentOS 7
[ https://issues.apache.org/jira/browse/TRAFODION-3078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3078 started by liu ming. --- > SQL Regression fail on CentOS 7 > --- > > Key: TRAFODION-3078 > URL: https://issues.apache.org/jira/browse/TRAFODION-3078 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > hive/TEST001 2018-05-20 15:46:03 00:00:08 ### FAIL (1521 lines) ### > hive/TEST005 2018-05-20 15:46:11 00:08:18 ### FAIL (87 lines) ### > hive/TEST009 2018-05-20 15:54:29 00:05:00 ### FAIL (103 lines) ### > hive/TEST015 2018-05-20 15:59:30 00:06:08 ### FAIL (465 lines) ### > udr/TEST002 2018-05-20 17:05:48 00:00:48 ### FAIL (36 lines) ### -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3079) basic test suite failures for CentOS 7
liu ming created TRAFODION-3079: --- Summary: basic test suite failures for CentOS 7 Key: TRAFODION-3079 URL: https://issues.apache.org/jira/browse/TRAFODION-3079 Project: Apache Trafodion Issue Type: Sub-task Reporter: liu ming Assignee: liu ming This sub-tasks covers those failures for basic Jenkins test -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3078) SQL Regression fail on CentOS 7
liu ming created TRAFODION-3078: --- Summary: SQL Regression fail on CentOS 7 Key: TRAFODION-3078 URL: https://issues.apache.org/jira/browse/TRAFODION-3078 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming Assignee: liu ming hive/TEST001 2018-05-20 15:46:03 00:00:08 ### FAIL (1521 lines) ### hive/TEST005 2018-05-20 15:46:11 00:08:18 ### FAIL (87 lines) ### hive/TEST009 2018-05-20 15:54:29 00:05:00 ### FAIL (103 lines) ### hive/TEST015 2018-05-20 15:59:30 00:06:08 ### FAIL (465 lines) ### udr/TEST002 2018-05-20 17:05:48 00:00:48 ### FAIL (36 lines) ### -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3077) dcsstart failed at CentOS7
[ https://issues.apache.org/jira/browse/TRAFODION-3077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3077 started by liu ming. --- > dcsstart failed at CentOS7 > -- > > Key: TRAFODION-3077 > URL: https://issues.apache.org/jira/browse/TRAFODION-3077 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: liu ming >Priority: Major > > On CentOS 7, sqstart cannot successfully start DCS. > But second run of dcsstart will start all proceses. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3034) support Oracle 'Start with connect by' feature
[
https://issues.apache.org/jira/browse/TRAFODION-3034?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-3034 started by liu ming.
---
> support Oracle 'Start with connect by' feature
> --
>
> Key: TRAFODION-3034
> URL: https://issues.apache.org/jira/browse/TRAFODION-3034
> Project: Apache Trafodion
> Issue Type: New Feature
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
>
> Oracle support hierarchy search , or recursive query. Syntax is 'connect by,
> start with'
>
> If a table contains hierarchical data, then you can select rows in a
> hierarchical order using the hierarchical query clause (START WITH
> condition1) CONNECT BY condition2
> The START WITH clause is optional and specifies the rows athat are the
> root(s) of the hierarchical query. If you omit this clause, then Oracle uses
> all rows in the table as root rows. The START WITH condition can contain a
> subquery, but it cannot contain a scalar subquery expression.
> The CONNECT BY clause specifies the relationship between parent rows and
> child rows of the hierarchy. The connect_by_condition can be any condition,
> however, it must use the PRIOR operator to refer to the parent row.
> Restriction on the CONNECT BY clause: The connect_by_condition cannot contain
> a regular subquery or a scalar subquery expression.
> The PRIOR operator to refer to the parent row can be used as following:
> Sample query on the employees table:
> SELECT employee_id, last_name, manager_id, LEVEL FROM employees CONNECT BY
> PRIOR employee_id = manager_id;
> shows employee_id, last_name, manager_id and level in the tree for the
> employee hierarchy.
> In Oracle 9i a new feature for hierarchical queries is added:
> sys_connect_by_path It returns the path of a column value from root to node,
> with column values separated by char for each row returned by CONNECT BY
> condition. Both column and char can be any of the datatypes CHAR, VARCHAR2,
> NCHAR, or NVARCHAR2. The string returned is of VARCHAR2 datatype and is in
> the same character set as column.
> Examples
> The following example returns the path of employee names from employee
> Kochhar to all employees of Kochhar (and their employees):
> SELECT LPAD(' ', 2*level-1)|| SYS_CONNECT_BY_PATH(last_name, '/') "Path" FROM
> employees CONNECT BY PRIOR employee_id = manager_id;
> In Oracle 10 3 new features for hierarchical queries are added:
> h3. connect_by_root
> CONNECT_BY_ROOT is a unary operator that is valid only in hierarchical
> queries. When you qualify a column with this operator, Oracle returns the
> column value using data from the root row. This operator extends the
> functionality of the CONNECT BY [PRIOR] condition of hierarchical queries.
> Restriction on CONNECT_BY_ROOT: You cannot specify this operator in the START
> WITH condition or the CONNECT BY condition. Example query:
> SELECT last_name "Employee", CONNECT_BY_ROOT last_name "Manager", LEVEL-1
> "Pathlen", SYS_CONNECT_BY_PATH(last_name, '/') "Path" FROM employees WHERE
> LEVEL > 1 and department_id = 110 CONNECT BY PRIOR employee_id = manager_id;
> h3. connect_by_isleaf
> The CONNECT_BY_ISLEAF pseudocolumn returns 1 if the current row is a leaf of
> the tree defined by the CONNECT BY condition. Otherwise it returns 0. This
> information indicates whether a given row can be further expanded to show
> more of the hierarchy. Example
> SELECT employee_id, last_name, manager_id, connect_by_isleaf "IsLeaf" FROM
> employees START WITH last_name = 'King' CONNECT BY PRIOR employee_id =
> manager_id;
> h3. connect_by_iscycle
> The CONNECT_BY_ISCYCLE pseudocolumn returns 1 if the current row has a child
> which is also its ancestor. Otherwise it returns 0.
> You can specify CONNECT_BY_ISCYCLE only if you have specified the NOCYCLE
> parameter of the CONNECT BY clause. NOCYCLE enables Oracle to return the
> results of a query that would otherwise fail because of a CONNECT BY loop in
> the data.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Created] (TRAFODION-3077) dcsstart failed at CentOS7
liu ming created TRAFODION-3077: --- Summary: dcsstart failed at CentOS7 Key: TRAFODION-3077 URL: https://issues.apache.org/jira/browse/TRAFODION-3077 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming Assignee: liu ming On CentOS 7, sqstart cannot successfully start DCS. But second run of dcsstart will start all proceses. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3076) update pom.xml.hdp for protobuf compile
[ https://issues.apache.org/jira/browse/TRAFODION-3076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3076 started by liu ming. --- > update pom.xml.hdp for protobuf compile > --- > > Key: TRAFODION-3076 > URL: https://issues.apache.org/jira/browse/TRAFODION-3076 > Project: Apache Trafodion > Issue Type: Sub-task >Reporter: liu ming >Assignee: liu ming >Priority: Major > > hadoop-protobuf plugin is related to Hadoop version. > We need to make sure the Hadoop version is matching. > This is for HDP distro. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3075) Installer needs to support RH7 / Centos7
[ https://issues.apache.org/jira/browse/TRAFODION-3075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3075 started by liu ming. --- > Installer needs to support RH7 / Centos7 > > > Key: TRAFODION-3075 > URL: https://issues.apache.org/jira/browse/TRAFODION-3075 > Project: Apache Trafodion > Issue Type: Improvement > Components: installer >Affects Versions: 2.3 >Reporter: Steve Varnau >Assignee: liu ming >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
