[jira] [Reopened] (TRAFODION-2775) Insert does not raise duplicate row error for hbase format table with defaulted first column

2017-10-25 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah reopened TRAFODION-2775: --- Jenkins regressions failed once after this PR was merged.During "initialize

[jira] [Resolved] (TRAFODION-2776) Mdam plans with more than one disjunct sometimes cause either a compiler core or have an incorrect predicate

2017-10-19 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2776. --- Resolution: Fixed > Mdam plans with more than one disjunct sometimes cause either

[jira] [Resolved] (TRAFODION-2775) Insert does not raise duplicate row error for hbase format table with defaulted first column

2017-10-18 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2775. --- Resolution: Fixed > Insert does not raise duplicate row error for hbase format

[jira] [Created] (TRAFODION-2776) Mdam plans with more than one disjunct sometimes cause either a compiler core or have an incorrect predicate

2017-10-18 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2776: - Summary: Mdam plans with more than one disjunct sometimes cause either a compiler core or have an incorrect predicate Key: TRAFODION-2776 URL:

[jira] [Updated] (TRAFODION-2775) Insert does not raise duplicate row error for hbase format table with defaulted first column

2017-10-18 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2775: -- Description: This issue was found by Gunnar Tapper and Carol Pearson. With HBase

[jira] [Created] (TRAFODION-2775) Insert does not raise duplicate row error for hbase format table with defaulted first column

2017-10-18 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2775: - Summary: Insert does not raise duplicate row error for hbase format table with defaulted first column Key: TRAFODION-2775 URL:

[jira] [Resolved] (TRAFODION-1976) SQL reference manual should add description of the 'create unique index' syntax

2017-10-18 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-1976. --- Resolution: Fixed Fix Version/s: 2.0-incubating > SQL reference manual

[jira] [Closed] (TRAFODION-2767) Select count(*) from a renamed table should return error 4082 instead of error 8448

2017-10-09 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah closed TRAFODION-2767. - Resolution: Cannot Reproduce > Select count(*) from a renamed table should return

[jira] [Created] (TRAFODION-2767) Select count(*) from a renamed table should return error 4082 instead of error 8448

2017-10-05 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2767: - Summary: Select count(*) from a renamed table should return error 4082 instead of error 8448 Key: TRAFODION-2767 URL:

[jira] [Resolved] (TRAFODION-2764) LOAD and UNLOAD statements with LOB columns cause runtime errors

2017-10-05 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2764. --- Resolution: Fixed > LOAD and UNLOAD statements with LOB columns cause runtime

[jira] [Resolved] (TRAFODION-2763) Left join with non-equi join predicate in ON clause may cause corefiles

2017-10-05 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2763. --- Resolution: Fixed > Left join with non-equi join predicate in ON clause may cause

[jira] [Created] (TRAFODION-2763) Left join with non-equi join predicate in ON clause may cause corefiles

2017-10-04 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2763: - Summary: Left join with non-equi join predicate in ON clause may cause corefiles Key: TRAFODION-2763 URL: https://issues.apache.org/jira/browse/TRAFODION-2763

[jira] [Resolved] (TRAFODION-2758) Sort operator that uses TopN sort at runtime is not accurately determined at compile time

2017-10-03 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2758. --- Resolution: Fixed > Sort operator that uses TopN sort at runtime is not

[jira] [Resolved] (TRAFODION-2760) hbase cache blocks is OFF for broad table with narrow index

2017-10-03 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2760. --- Resolution: Fixed > hbase cache blocks is OFF for broad table with narrow index >

[jira] [Resolved] (TRAFODION-2759) Use of rowset with large memory leads to various errors at runtime

2017-10-03 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2759. --- Resolution: Fixed > Use of rowset with large memory leads to various errors at

[jira] [Resolved] (TRAFODION-2748) Slower upsert performance when source is a Hive scan

2017-10-02 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2748. --- Resolution: Fixed > Slower upsert performance when source is a Hive scan >

[jira] [Resolved] (TRAFODION-2730) process loop when infer_charset cqd is ON and query invalidation is done

2017-10-02 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2730. --- Resolution: Fixed > process loop when infer_charset cqd is ON and query

[jira] [Resolved] (TRAFODION-2747) Intermittent failure of regression test executor/test063

2017-10-02 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2747. --- Resolution: Fixed > Intermittent failure of regression test executor/test063 >

[jira] [Created] (TRAFODION-2760) hbase cache blocks is OFF for broad table with narrow index

2017-09-29 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2760: - Summary: hbase cache blocks is OFF for broad table with narrow index Key: TRAFODION-2760 URL: https://issues.apache.org/jira/browse/TRAFODION-2760 Project:

[jira] [Created] (TRAFODION-2759) Use of rowset with large memory leads to various errors at runtime

2017-09-29 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2759: - Summary: Use of rowset with large memory leads to various errors at runtime Key: TRAFODION-2759 URL: https://issues.apache.org/jira/browse/TRAFODION-2759

[jira] [Created] (TRAFODION-2758) Sort operator that uses TopN sort at runtime is not accurately determined at compile time

2017-09-29 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2758: - Summary: Sort operator that uses TopN sort at runtime is not accurately determined at compile time Key: TRAFODION-2758 URL:

[jira] [Updated] (TRAFODION-2748) Slower upsert performance when source is a Hive scan

2017-09-18 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2748: -- Summary: Slower upsert performance when source is a Hive scan (was: Upsert

[jira] [Created] (TRAFODION-2748) Upsert performance when source is a Hive scan

2017-09-18 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2748: - Summary: Upsert performance when source is a Hive scan Key: TRAFODION-2748 URL: https://issues.apache.org/jira/browse/TRAFODION-2748 Project: Apache

[jira] [Created] (TRAFODION-2747) Intermittent failure of regression test executor/test063

2017-09-18 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2747: - Summary: Intermittent failure of regression test executor/test063 Key: TRAFODION-2747 URL: https://issues.apache.org/jira/browse/TRAFODION-2747 Project:

[jira] [Resolved] (TRAFODION-2622) Left join with other_join_predicate on outer table alone is slow

2017-07-05 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2622. --- Resolution: Fixed > Left join with other_join_predicate on outer table alone is

[jira] [Closed] (TRAFODION-2674) Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength)

2017-07-04 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah closed TRAFODION-2674. - > Create index sees error 2006 internal assertion (keyColOffset == > totalKeyLength) >

[jira] [Resolved] (TRAFODION-2674) Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength)

2017-07-04 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2674. --- Resolution: Fixed > Create index sees error 2006 internal assertion (keyColOffset

[jira] [Updated] (TRAFODION-2622) Left join with other_join_predicate on outer table alone is slow

2017-07-03 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2622: -- Description: When a Left join has an equality predicate in the ON clause connecting

[jira] [Commented] (TRAFODION-2674) Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength)

2017-06-28 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067449#comment-16067449 ] Suresh Subbiah commented on TRAFODION-2674: --- Region boundaries for indexes were not being

[jira] [Created] (TRAFODION-2674) Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength)

2017-06-28 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2674: - Summary: Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength) Key: TRAFODION-2674 URL: https://issues.apache.org/jira/browse/TRAFODION-2674

[jira] [Created] (TRAFODION-2622) Left join with other_join_predicate on outer table alone is slow

2017-05-24 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2622: - Summary: Left join with other_join_predicate on outer table alone is slow Key: TRAFODION-2622 URL: https://issues.apache.org/jira/browse/TRAFODION-2622

[jira] [Resolved] (TRAFODION-2568) bypass the operator work if the predicate is FALSE

2017-05-24 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2568. --- Resolution: Fixed > bypass the operator work if the predicate is FALSE >

[jira] [Assigned] (TRAFODION-2179) Memory leak from long running mxosrvr

2017-05-24 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah reassigned TRAFODION-2179: - Assignee: Suresh Subbiah > Memory leak from long running mxosrvr >

[jira] [Closed] (TRAFODION-2512) index access with MDAM not chosen where predicate is range spec

2017-04-11 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah closed TRAFODION-2512. - Resolution: Fixed > index access with MDAM not chosen where predicate is range spec >

[jira] [Resolved] (TRAFODION-2586) UPSERT USING LOAD running slower than UPSERT with transactions disabled

2017-04-11 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2586. --- Resolution: Fixed > UPSERT USING LOAD running slower than UPSERT with

[jira] [Created] (TRAFODION-2586) UPSERT USING LOAD running slower than UPSERT with transactions disabled

2017-04-10 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2586: - Summary: UPSERT USING LOAD running slower than UPSERT with transactions disabled Key: TRAFODION-2586 URL: https://issues.apache.org/jira/browse/TRAFODION-2586

[jira] [Commented] (TRAFODION-2512) index access with MDAM not chosen where predicate is range spec

2017-04-07 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15961672#comment-15961672 ] Suresh Subbiah commented on TRAFODION-2512: --- This is the plan we get with a fix. The issue

[jira] [Commented] (TRAFODION-2568) bypass the operator work if the predicate is FALSE

2017-04-06 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15960243#comment-15960243 ] Suresh Subbiah commented on TRAFODION-2568: --- This is what we get with a fix. The base table

[jira] [Commented] (TRAFODION-2574) Index plan not chosen for UPDATE when WHERE clause and SET clause are on the same index column

2017-04-06 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15960188#comment-15960188 ] Suresh Subbiah commented on TRAFODION-2574: --- Here is the plan we now get for these four

[jira] [Created] (TRAFODION-2574) Index plan not chosen for UPDATE when WHERE clause and SET clause are on the same index column

2017-04-03 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2574: - Summary: Index plan not chosen for UPDATE when WHERE clause and SET clause are on the same index column Key: TRAFODION-2574 URL:

[jira] [Created] (TRAFODION-2573) Support Index hints in a DML statement

2017-04-03 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2573: - Summary: Support Index hints in a DML statement Key: TRAFODION-2573 URL: https://issues.apache.org/jira/browse/TRAFODION-2573 Project: Apache Trafodion

[jira] [Commented] (TRAFODION-2444) compile failed with 3 union alls

2017-03-20 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15933348#comment-15933348 ] Suresh Subbiah commented on TRAFODION-2444: --- There are correlated subqueries in the both

[jira] [Comment Edited] (TRAFODION-2444) compile failed with 3 union alls

2017-03-20 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15899841#comment-15899841 ] Suresh Subbiah edited comment on TRAFODION-2444 at 3/20/17 7:00 PM:

[jira] [Resolved] (TRAFODION-2535) Create index succeeds but resulting index is empty, if dop > 32

2017-03-16 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2535. --- Resolution: Fixed > Create index succeeds but resulting index is empty, if dop >

[jira] [Commented] (TRAFODION-1702) purgedata fails on table with delimited name

2017-03-15 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15926321#comment-15926321 ] Suresh Subbiah commented on TRAFODION-1702: --- Assigning to Anoop since PR 1009 addresses this

[jira] [Assigned] (TRAFODION-1702) purgedata fails on table with delimited name

2017-03-15 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah reassigned TRAFODION-1702: - Assignee: Anoop Sharma (was: taian.wei) > purgedata fails on table with

[jira] [Updated] (TRAFODION-2535) Create index succeeds but resulting index is empty, if dop > 32

2017-03-13 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2535: -- Description: If more than 32 HFiles are created for a single region of an index or

[jira] [Created] (TRAFODION-2535) Create index succeeds but resulting index is empty, if dop > 32

2017-03-13 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2535: - Summary: Create index succeeds but resulting index is empty, if dop > 32 Key: TRAFODION-2535 URL: https://issues.apache.org/jira/browse/TRAFODION-2535

[jira] [Resolved] (TRAFODION-2527) process abend when updating primary key with TRAF_RELOAD_NATABLE_CACHE 'ON'

2017-03-08 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2527. --- Resolution: Fixed > process abend when updating primary key with

[jira] [Created] (TRAFODION-2527) process abend when updating primary key with TRAF_RELOAD_NATABLE_CACHE 'ON'

2017-03-07 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2527: - Summary: process abend when updating primary key with TRAF_RELOAD_NATABLE_CACHE 'ON' Key: TRAFODION-2527 URL: https://issues.apache.org/jira/browse/TRAFODION-2527

[jira] [Assigned] (TRAFODION-2444) compile failed with 3 union alls

2017-03-07 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah reassigned TRAFODION-2444: - Assignee: Suresh Subbiah (was: liu ming) > compile failed with 3 union alls

[jira] [Commented] (TRAFODION-2444) compile failed with 3 union alls

2017-03-07 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15899841#comment-15899841 ] Suresh Subbiah commented on TRAFODION-2444: --- DDL to reproduce cqd

[jira] [Resolved] (TRAFODION-2475) Create table/index or alter does not work with unavailable compression options

2017-03-06 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2475. --- Resolution: Fixed > Create table/index or alter does not work with unavailable

[jira] [Assigned] (TRAFODION-2512) index access with MDAM not chosen where predicate is range spec

2017-02-28 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah reassigned TRAFODION-2512: - Assignee: Suresh Subbiah > index access with MDAM not chosen where predicate

[jira] [Updated] (TRAFODION-2475) Create table/index or alter does not work with unavailable compression options

2017-02-16 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2475: -- Description: Create table/index option with HBASE_OPTIONS (COMPRESSION = '') does

[jira] [Created] (TRAFODION-2475) Create table/index or alter does not work with unavailable compression options

2017-02-08 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2475: - Summary: Create table/index or alter does not work with unavailable compression options Key: TRAFODION-2475 URL: https://issues.apache.org/jira/browse/TRAFODION-2475

[jira] [Resolved] (TRAFODION-2159) Unnest correlated subquery with explicit groupby

2016-11-01 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2159. --- Resolution: Fixed > Unnest correlated subquery with explicit groupby >

[jira] [Closed] (TRAFODION-2276) Complete list of memory leaks in SQL component due to NACollection objects being allocated in system heap

2016-11-01 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah closed TRAFODION-2276. - Resolution: Duplicate Duplicate of 2275 > Complete list of memory leaks in SQL

[jira] [Resolved] (TRAFODION-2266) Fix a few memory leaks

2016-11-01 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2266. --- Resolution: Fixed > Fix a few memory leaks > --- > >

[jira] [Created] (TRAFODION-2275) Complete list of memory leaks in SQL component due to NACollection objects being allocated in system heap

2016-10-10 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2275: - Summary: Complete list of memory leaks in SQL component due to NACollection objects being allocated in system heap Key: TRAFODION-2275 URL:

[jira] [Created] (TRAFODION-2276) Complete list of memory leaks in SQL component due to NACollection objects being allocated in system heap

2016-10-10 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2276: - Summary: Complete list of memory leaks in SQL component due to NACollection objects being allocated in system heap Key: TRAFODION-2276 URL:

[jira] [Assigned] (TRAFODION-2273) Predicate on "partition by" columns in sequence function should be pushed down

2016-10-10 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah reassigned TRAFODION-2273: - Assignee: Suresh Subbiah > Predicate on "partition by" columns in sequence

[jira] [Updated] (TRAFODION-2266) Fix a few memory leaks

2016-10-07 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2266: -- Description: In the sql component of Trafodion memory for most objects derive from

[jira] [Created] (TRAFODION-2266) Fix a few memory leaks

2016-10-07 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2266: - Summary: Fix a few memory leaks Key: TRAFODION-2266 URL: https://issues.apache.org/jira/browse/TRAFODION-2266 Project: Apache Trafodion Issue

[jira] [Resolved] (TRAFODION-2218) Memory leak from JVM used for TMUDF compile time interaction

2016-10-03 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2218. --- Resolution: Fixed > Memory leak from JVM used for TMUDF compile time interaction

[jira] [Resolved] (TRAFODION-2199) SELECT on Hive partitioned table causes timestamp mismatch error

2016-10-03 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2199. --- Resolution: Fixed > SELECT on Hive partitioned table causes timestamp mismatch

[jira] [Updated] (TRAFODION-2159) Unnest correlated subquery with explicit groupby

2016-10-03 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2159: -- Description: Correlated subqueries with the pattern shown on the left side of the

[jira] [Updated] (TRAFODION-2252) Memory leak during compile of certain insert statements

2016-09-28 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2252: -- Attachment: pprof64371.0.svg pprof64371.sym > Memory leak during

[jira] [Updated] (TRAFODION-2252) Memory leak during compile of certain insert statements

2016-09-28 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2252: -- Summary: Memory leak during compile of certain insert statements (was: Memory leak

[jira] [Created] (TRAFODION-2252) Memory leak during compile of insert statements

2016-09-28 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2252: - Summary: Memory leak during compile of insert statements Key: TRAFODION-2252 URL: https://issues.apache.org/jira/browse/TRAFODION-2252 Project: Apache

[jira] [Commented] (TRAFODION-2216) sometimes odb cannot copy all rows when the table is large

2016-09-12 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15484315#comment-15484315 ] Suresh Subbiah commented on TRAFODION-2216: --- We got this Transaction error in the failing

[jira] [Commented] (TRAFODION-2195) create Trafodion table with hbase options DATA_BLOCK_ENCODING and COMPRESSION together won't get all results when executing queries

2016-09-01 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15457336#comment-15457336 ] Suresh Subbiah commented on TRAFODION-2195: --- Thank you. I was able to see the same problem

[jira] [Commented] (TRAFODION-2199) SELECT on Hive partitioned table causes timestamp mismatch error

2016-08-30 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15450708#comment-15450708 ] Suresh Subbiah commented on TRAFODION-2199: --- The problem may be hard to see. Typically

[jira] [Commented] (TRAFODION-2195) create Trafodion table with hbase options DATA_BLOCK_ENCODING and COMPRESSION together won't get all results when executing queries

2016-08-30 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15450301#comment-15450301 ] Suresh Subbiah commented on TRAFODION-2195: --- Hi, Could you please describe how the table

[jira] [Updated] (TRAFODION-2178) TM Recovery exception in HRegionInfo.readFields

2016-08-23 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2178: -- Assignee: Sean Broeder > TM Recovery exception in HRegionInfo.readFields >

[jira] [Commented] (TRAFODION-2159) Unnest correlated subquery with explicit groupby

2016-08-12 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419109#comment-15419109 ] Suresh Subbiah commented on TRAFODION-2159: --- The transformation will be done in the

[jira] [Updated] (TRAFODION-2159) Unnest correlated subquery with explicit groupby

2016-08-12 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2159: -- Attachment: GroupByUnnest.pdf > Unnest correlated subquery with explicit groupby >

[jira] [Created] (TRAFODION-2159) Unnest correlated subquery with explicit groupby

2016-08-12 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2159: - Summary: Unnest correlated subquery with explicit groupby Key: TRAFODION-2159 URL: https://issues.apache.org/jira/browse/TRAFODION-2159 Project: Apache

[jira] [Commented] (TRAFODION-2158) Various fixes, several related to tinyint

2016-08-12 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419002#comment-15419002 ] Suresh Subbiah commented on TRAFODION-2158: --- Resolved with

[jira] [Resolved] (TRAFODION-2141) Provide cluster view of region stats over all regions.

2016-08-12 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2141. --- Resolution: Fixed > Provide cluster view of region stats over all regions. >

[jira] [Resolved] (TRAFODION-2158) Various fixes, several related to tinyint

2016-08-12 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2158. --- Resolution: Fixed > Various fixes, several related to tinyint >

[jira] [Updated] (TRAFODION-2152) trafodion jdbc t4 isClosed method not correct

2016-08-09 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2152: -- Assignee: Alex Peng > trafodion jdbc t4 isClosed method not correct >

[jira] [Updated] (TRAFODION-2145) Column name returned by SQLColumn api when column type is interval

2016-08-09 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-2145: -- Assignee: Weiqing Xu > Column name returned by SQLColumn api when column type is

[jira] [Created] (TRAFODION-2147) showshape and CQS do not work for TMUDFs

2016-08-05 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2147: - Summary: showshape and CQS do not work for TMUDFs Key: TRAFODION-2147 URL: https://issues.apache.org/jira/browse/TRAFODION-2147 Project: Apache Trafodion

[jira] [Created] (TRAFODION-2138) Hive scan on wide tables can result in lost rows or error

2016-08-03 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2138: - Summary: Hive scan on wide tables can result in lost rows or error Key: TRAFODION-2138 URL: https://issues.apache.org/jira/browse/TRAFODION-2138 Project:

[jira] [Commented] (TRAFODION-1562) Changes in query tree when the upsert command is transformed into merge

2016-08-02 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15404914#comment-15404914 ] Suresh Subbiah commented on TRAFODION-1562: --- Comment from Hans. The OLAP function that

[jira] [Updated] (TRAFODION-1562) Changes in query tree when the upsert command is transformed into merge

2016-08-02 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah updated TRAFODION-1562: -- Attachment: BatchUpsertTransformation.pdf > Changes in query tree when the upsert

[jira] [Commented] (TRAFODION-2105) odb load lines with duplicate primary key failed, but didn't make any record

2016-07-12 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15373159#comment-15373159 ] Suresh Subbiah commented on TRAFODION-2105: --- With loadcmd=UL, this is the correct behaviour.

[jira] [Created] (TRAFODION-2094) ODB TRUNCATE option takes a long time

2016-07-05 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2094: - Summary: ODB TRUNCATE option takes a long time Key: TRAFODION-2094 URL: https://issues.apache.org/jira/browse/TRAFODION-2094 Project: Apache Trafodion

[jira] [Resolved] (TRAFODION-2039) Add support for ALTER LIBRARY FILE ''

2016-06-20 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2039. --- Resolution: Fixed > Add support for ALTER LIBRARY FILE '' >

[jira] [Closed] (TRAFODION-2039) Add support for ALTER LIBRARY FILE ''

2016-06-20 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah closed TRAFODION-2039. - > Add support for ALTER LIBRARY FILE '' >

[jira] [Closed] (TRAFODION-2038) ERROR[2006] Internal error: assertion failure ((Int32)outputDataLen >= 0) during compile

2016-06-16 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah closed TRAFODION-2038. - > ERROR[2006] Internal error: assertion failure ((Int32)outputDataLen >= 0) > during

[jira] [Resolved] (TRAFODION-2038) ERROR[2006] Internal error: assertion failure ((Int32)outputDataLen >= 0) during compile

2016-06-16 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-2038. --- Resolution: Fixed > ERROR[2006] Internal error: assertion failure

[jira] [Resolved] (TRAFODION-1799) create index failed with ERROR[3047]

2016-06-09 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah resolved TRAFODION-1799. --- Resolution: Fixed > create index failed with ERROR[3047] >

[jira] [Closed] (TRAFODION-1799) create index failed with ERROR[3047]

2016-06-09 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah closed TRAFODION-1799. - > create index failed with ERROR[3047] > - > >

[jira] [Created] (TRAFODION-2042) Index shall inherit compression and data_block_encoding HBase options from Table

2016-06-08 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2042: - Summary: Index shall inherit compression and data_block_encoding HBase options from Table Key: TRAFODION-2042 URL: https://issues.apache.org/jira/browse/TRAFODION-2042

[jira] [Assigned] (TRAFODION-2039) Add support for ALTER LIBRARY FILE ''

2016-06-08 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Subbiah reassigned TRAFODION-2039: - Assignee: Suresh Subbiah > Add support for ALTER LIBRARY FILE '' >

[jira] [Created] (TRAFODION-2039) Add support for ALTER LIBRARY FILE ''

2016-06-07 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2039: - Summary: Add support for ALTER LIBRARY FILE '' Key: TRAFODION-2039 URL: https://issues.apache.org/jira/browse/TRAFODION-2039 Project: Apache Trafodion

[jira] [Created] (TRAFODION-2038) ERROR[2006] Internal error: assertion failure ((Int32)outputDataLen >= 0) during compile

2016-06-07 Thread Suresh Subbiah (JIRA)
Suresh Subbiah created TRAFODION-2038: - Summary: ERROR[2006] Internal error: assertion failure ((Int32)outputDataLen >= 0) during compile Key: TRAFODION-2038 URL:

[jira] [Commented] (TRAFODION-1804) Raise an error early during CREATE TABLE if requested compression type is not available

2016-06-02 Thread Suresh Subbiah (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15312816#comment-15312816 ] Suresh Subbiah commented on TRAFODION-1804: --- An approach to resolving this may be to use the

  1   2   3   4   5   6   7   8   >