[jira] [Created] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-13 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-3107: - Summary: selct count(0) with long varchar hitting jvm OOM error Key: TRAFODION-3107 URL: https://issues.apache.org/jira/browse/TRAFODION-3107

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-13 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511470#comment-16511470 ] Sandhya Sundaresan commented on TRAFODION-3107: --- Explain plan shows the 16MB columns

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-13 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511465#comment-16511465 ] Sandhya Sundaresan commented on TRAFODION-3107: --- |n sqlci: select * from

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-13 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511464#comment-16511464 ] Sandhya Sundaresan commented on TRAFODION-3107: --- 1.cqd traf_clob_as_varchar 'on'

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-15 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16514313#comment-16514313 ] Sandhya Sundaresan commented on TRAFODION-3107: --- Fixing this by limiting the number of

[jira] [Commented] (TRAFODION-3092) Incorrect rowcount reported after commit conflict error

2018-06-15 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16514324#comment-16514324 ] Sandhya Sundaresan commented on TRAFODION-3092: --- The fix is to capture the diags area

[jira] [Commented] (TRAFODION-3004) SQL dense buffers structure contain a size limit due to an incorrect cast

2018-06-15 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16514333#comment-16514333 ] Sandhya Sundaresan commented on TRAFODION-3004: --- {color:#00}The symptom of this is

[jira] [Created] (TRAFODION-3092) Incorrect rowcount reported after commit conflict error

2018-05-30 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-3092: - Summary: Incorrect rowcount reported after commit conflict error Key: TRAFODION-3092 URL: https://issues.apache.org/jira/browse/TRAFODION-3092

[jira] [Updated] (TRAFODION-2946) LOB : Locking/transaction support needed for LOB files for DDL and IUD operations

2018-05-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan updated TRAFODION-2946: -- Summary: LOB : Locking/transaction support needed for LOB files for DDL

[jira] [Updated] (TRAFODION-2946) LOB : DTM support needed for LOB files for DDL and IUD operations

2018-05-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan updated TRAFODION-2946: -- Component/s: sql-general > LOB : DTM support needed for LOB files for DDL

[jira] [Assigned] (TRAFODION-2946) LOB : DTM support needed for LOB files for DDL and IUD operations

2018-05-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan reassigned TRAFODION-2946: - Assignee: Sandhya Sundaresan > LOB : DTM support needed for LOB

[jira] [Commented] (TRAFODION-2946) LOB : Locking/transaction support needed for LOB files for DDL and IUD operations

2018-05-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16494222#comment-16494222 ] Sandhya Sundaresan commented on TRAFODION-2946: --- To address the locking issue during

[jira] [Commented] (TRAFODION-2949) LOB: Address performance issues related to inserts/extracts in tables containing LOB columns

2018-06-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16502036#comment-16502036 ] Sandhya Sundaresan commented on TRAFODION-2949: --- Additional issue uncovered  on driver

[jira] [Assigned] (TRAFODION-2949) LOB: Address performance issues related to inserts/extracts in tables containing LOB columns

2018-06-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan reassigned TRAFODION-2949: - Assignee: taian.wei (was: Sandhya Sundaresan) > LOB: Address

[jira] [Resolved] (TRAFODION-3004) SQL dense buffers structure contain a size limit due to an incorrect cast

2018-06-19 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-3004. --- Resolution: Fixed Fix Version/s: 2.3 > SQL dense buffers

[jira] [Resolved] (TRAFODION-3092) Incorrect rowcount reported after commit conflict error

2018-06-19 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-3092. --- Resolution: Fixed Fix Version/s: 2.3 > Incorrect rowcount

[jira] [Resolved] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-19 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-3107. --- Resolution: Fixed > selct count(0) with long varchar hitting jvm OOM

[jira] [Commented] (TRAFODION-2917) Refactor Trafodion implementation of hdfs scan for text formatted hive tables

2018-01-18 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16331099#comment-16331099 ] Sandhya Sundaresan commented on TRAFODION-2917: --- Description of the current flow is

[jira] [Commented] (TRAFODION-2832) LOB: Insert hangs with a mutli-row insertion that requires internal stringtolob() conversion

2018-01-12 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16324399#comment-16324399 ] Sandhya Sundaresan commented on TRAFODION-2832: --- WIthout the next fix the query failed

[jira] [Commented] (TRAFODION-2832) LOB: Insert hangs with a mutli-row insertion that requires internal stringtolob() conversion

2018-01-12 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16324358#comment-16324358 ] Sandhya Sundaresan commented on TRAFODION-2832: --- Adding another fix to this. In case of

[jira] [Updated] (TRAFODION-2742) Linux and Windows ODBC need to support LOB

2018-02-01 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan updated TRAFODION-2742: -- Issue Type: Technical task (was: Sub-task) > Linux and Windows ODBC need

[jira] [Commented] (TRAFODION-2874) LOB: Add syntax to return filename of a LOB data file for external LOBs.

2018-01-31 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16347351#comment-16347351 ] Sandhya Sundaresan commented on TRAFODION-2874: --- Also ensured tis syntax will also work

[jira] [Commented] (TRAFODION-2874) LOB: Add syntax to return filename of a LOB data file for external LOBs.

2018-01-31 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16347337#comment-16347337 ] Sandhya Sundaresan commented on TRAFODION-2874: --- Added syntax to return both filename

[jira] [Created] (TRAFODION-2947) LOB:Create utility to compact and do GC on LOB data files

2018-02-01 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-2947: - Summary: LOB:Create utility to compact and do GC on LOB data files Key: TRAFODION-2947 URL: https://issues.apache.org/jira/browse/TRAFODION-2947

[jira] [Updated] (TRAFODION-2873) LOB:Cleanup usage of LOBLoad which is deprecated and LobGlobals

2018-02-14 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan updated TRAFODION-2873: -- Summary: LOB:Cleanup usage of LOBLoad which is deprecated and LobGlobals

[jira] [Created] (TRAFODION-2873) LOB:Cleanup usage of LOBLoad which si deprecated and LobGlobals

2018-01-02 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-2873: - Summary: LOB:Cleanup usage of LOBLoad which si deprecated and LobGlobals Key: TRAFODION-2873 URL: https://issues.apache.org/jira/browse/TRAFODION-2873

[jira] [Created] (TRAFODION-2874) LOB: Add syntax to return filename of a LOB data file for external LOBs.

2018-01-02 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-2874: - Summary: LOB: Add syntax to return filename of a LOB data file for external LOBs. Key: TRAFODION-2874 URL: https://issues.apache.org/jira/browse/TRAFODION-2874

[jira] [Commented] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

2018-08-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16596658#comment-16596658 ] Sandhya Sundaresan commented on TRAFODION-3192: --- |Need to check why queue resizing is

[jira] [Created] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

2018-08-29 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-3192: - Summary: UNION ALL up and down queue size default value too small, or not dynamically adjusted Key: TRAFODION-3192 URL:

[jira] [Commented] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

2018-08-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16596668#comment-16596668 ] Sandhya Sundaresan commented on TRAFODION-3192: --- Here are my findings.   Each TDB has

[jira] [Resolved] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-3192. --- Resolution: Fixed > UNION ALL up and down queue size default value too

[jira] [Closed] (TRAFODION-1151) LP Bug: 1442483 - SQL queries hang when Region Server goes down

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1151. - > LP Bug: 1442483 - SQL queries hang when Region Server goes down >

[jira] [Closed] (TRAFODION-1596) LOB: Insert after alter table adding LOB column crashes sqlci

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1596. - > LOB: Insert after alter table adding LOB column crashes sqlci >

[jira] [Closed] (TRAFODION-2008) Support for external file LOBs in Trafodion

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2008. - > Support for external file LOBs in Trafodion >

[jira] [Closed] (TRAFODION-1979) values clause gives incorrect results or crashes mxosrvr when called on the LOB type

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1979. - > values clause gives incorrect results or crashes mxosrvr when called on the >

[jira] [Closed] (TRAFODION-2570) Ambari RPMs need NOTICE ,LICENSE,DISCLAIMER files packaged in.

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2570. - > Ambari RPMs need NOTICE ,LICENSE,DISCLAIMER files packaged in. >

[jira] [Closed] (TRAFODION-2572) Remove misleading messages about necessary Hadoop versions from sqencom.sh

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2572. - > Remove misleading messages about necessary Hadoop versions from sqencom.sh >

[jira] [Closed] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-3107. - > selct count(0) with long varchar hitting jvm OOM error >

[jira] [Closed] (TRAFODION-1635) Scripts updates for lob persistent start and script for building sql messages

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1635. - > Scripts updates for lob persistent start and script for building sql messages

[jira] [Closed] (TRAFODION-1937) Trace and debug messages for tracing LOB operations

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1937. - > Trace and debug messages for tracing LOB operations >

[jira] [Closed] (TRAFODION-1883) Drop schema cascade fails when schema contains a table with LOB columns

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1883. - > Drop schema cascade fails when schema contains a table with LOB columns >

[jira] [Closed] (TRAFODION-1891) New SQL Get command to return LOB related information

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1891. - > New SQL Get command to return LOB related information >

[jira] [Closed] (TRAFODION-1848) LOB infrastructure changes to support GC and get rid of unneeded mxlobsrvr process

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1848. - > LOB infrastructure changes to support GC and get rid of unneeded mxlobsrvr >

[jira] [Closed] (TRAFODION-2528) Classpath spec for hadoop-hdfs-*.jar needs to be changed in Trafodion env

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2528. - > Classpath spec for hadoop-hdfs-*.jar needs to be changed in Trafodion env >

[jira] [Closed] (TRAFODION-2554) JDBC T2 build changes needed for Trafodion release

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2554. - > JDBC T2 build changes needed for Trafodion release >

[jira] [Closed] (TRAFODION-2766) HIVE: Inserted row into a hive table has gone missing

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2766. - > HIVE: Inserted row into a hive table has gone missing >

[jira] [Closed] (TRAFODION-2873) LOB:Cleanup usage of LOBLoad which is deprecated and LobGlobals

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2873. - > LOB:Cleanup usage of LOBLoad which is deprecated and LobGlobals >

[jira] [Closed] (TRAFODION-2832) LOB: Insert hangs with a mutli-row insertion that requires internal stringtolob() conversion

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2832. - > LOB: Insert hangs with a mutli-row insertion that requires internal >

[jira] [Closed] (TRAFODION-2874) LOB: Add syntax to return filename of a LOB data file for external LOBs.

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2874. - > LOB: Add syntax to return filename of a LOB data file for external LOBs. >

[jira] [Closed] (TRAFODION-2770) "Table not found" errors not being handled correctly by AQR for hive access

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2770. - > "Table not found" errors not being handled correctly by AQR for hive access >

[jira] [Closed] (TRAFODION-1604) LOB: Lob handle with a schema name longer than 8 characters crashes sqlci at malloc()

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1604. - > LOB: Lob handle with a schema name longer than 8 characters crashes sqlci at

[jira] [Closed] (TRAFODION-1625) Trafodion delete on large table is treated as a unique delete

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1625. - > Trafodion delete on large table is treated as a unique delete >

[jira] [Closed] (TRAFODION-1712) TPCDS install_hadoop_regr_test_env fails to create multiple level directories

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1712. - > TPCDS install_hadoop_regr_test_env fails to create multiple level directories

[jira] [Closed] (TRAFODION-2516) Enhance stringtolob builtin function to take varchar/char columns as parameter

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2516. - > Enhance stringtolob builtin function to take varchar/char columns as parameter

[jira] [Closed] (TRAFODION-3004) SQL dense buffers structure contain a size limit due to an incorrect cast

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-3004. - > SQL dense buffers structure contain a size limit due to an incorrect cast >

[jira] [Closed] (TRAFODION-3092) Incorrect rowcount reported after commit conflict error

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-3092. - > Incorrect rowcount reported after commit conflict error >

[jira] [Commented] (TRAFODION-909) LP Bug: 1412641 - log4cpp -- Node number in master*.log is always 0

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604957#comment-16604957 ] Sandhya Sundaresan commented on TRAFODION-909: -- This was fixed so the node number is same

[jira] [Closed] (TRAFODION-2408) Support for empty_blob() and update syntax using lobhandle

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2408. - > Support for empty_blob() and update syntax using lobhandle >

[jira] [Closed] (TRAFODION-2097) Retry logic needed for methods that do hdfs reads

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2097. - > Retry logic needed for methods that do hdfs reads >

[jira] [Closed] (TRAFODION-2495) HDFS connection issue during LOB creation

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2495. - > HDFS connection issue during LOB creation >

[jira] [Closed] (TRAFODION-2146) Use of CQD to set scratch directory locations

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2146. - > Use of CQD to set scratch directory locations >

[jira] [Closed] (TRAFODION-2091) hdfsFS filesystem usage causies abnormal behavior in Trafodion

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2091. - > hdfsFS filesystem usage causies abnormal behavior in Trafodion >

[jira] [Resolved] (TRAFODION-909) LP Bug: 1412641 - log4cpp -- Node number in master*.log is always 0

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-909. -- Resolution: Fixed Fix Version/s: 2.3 > LP Bug: 1412641 - log4cpp --

[jira] [Closed] (TRAFODION-1598) LOB: lobtofile functionality are not consistent with syntax/documentation in some cases

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1598. - > LOB: lobtofile functionality are not consistent with syntax/documentation in

[jira] [Closed] (TRAFODION-1603) LOB: Insert into volatile table with LOB columns crashes sqlci

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1603. - > LOB: Insert into volatile table with LOB columns crashes sqlci >

[jira] [Closed] (TRAFODION-1599) LOB: select LOB columns with sample returns illegible output

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1599. - > LOB: select LOB columns with sample returns illegible output >

[jira] [Closed] (TRAFODION-1941) LOB datatype should take length token

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1941. - > LOB datatype should take length token > -

[jira] [Closed] (TRAFODION-1892) Trace support for LOB operations

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1892. - > Trace support for LOB operations > > >

[jira] [Closed] (TRAFODION-2083) Executor/TEST130 fails in Jenkins enironment with hangs during drop, create or inserts

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2083. - > Executor/TEST130 fails in Jenkins enironment with hangs during drop, create >

[jira] [Closed] (TRAFODION-1065) LP Bug: 1433882 - Hdfs access causes a potential filesystem handle resource leak

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-1065. - > LP Bug: 1433882 - Hdfs access causes a potential filesystem handle resource

[jira] [Closed] (TRAFODION-2724) JDBC LOB tests show symptoms of a leaked statement handle

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2724. - > JDBC LOB tests show symptoms of a leaked statement handle >

[jira] [Closed] (TRAFODION-2598) Insert Select to/from Trafodion tables containing LOB columns

2018-09-05 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan closed TRAFODION-2598. - > Insert Select to/from Trafodion tables containing LOB columns >

[jira] [Commented] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

2018-08-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16596673#comment-16596673 ] Sandhya Sundaresan commented on TRAFODION-3192: --- A CQD DYN_QUEUE_RESIZE_OVERRIDE  is

[jira] [Commented] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

2018-08-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16596659#comment-16596659 ] Sandhya Sundaresan commented on TRAFODION-3192: --- |The union operator was not

[jira] [Commented] (TRAFODION-3192) UNION ALL up and down queue size default value too small, or not dynamically adjusted

2018-08-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16596661#comment-16596661 ] Sandhya Sundaresan commented on TRAFODION-3192: --- |an old email showing other queue

[jira] [Commented] (TRAFODION-909) LP Bug: 1412641 - log4cpp -- Node number in master*.log is always 0

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388666#comment-16388666 ] Sandhya Sundaresan commented on TRAFODION-909: -- The issue still exists but is a more minor

[jira] [Commented] (TRAFODION-1099) LP Bug: 1437384 - sqenvcom.sh. Our CLASSPATH is too big.

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388651#comment-16388651 ] Sandhya Sundaresan commented on TRAFODION-1099: --- There have been no issues with the

[jira] [Commented] (TRAFODION-179) LP Bug: 1274962 - EXECUTE.BATCH update creates core-file

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388672#comment-16388672 ] Sandhya Sundaresan commented on TRAFODION-179: -- JDBC regression tests which test batch

[jira] [Resolved] (TRAFODION-179) LP Bug: 1274962 - EXECUTE.BATCH update creates core-file

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-179. -- Resolution: Cannot Reproduce > LP Bug: 1274962 - EXECUTE.BATCH update

[jira] [Resolved] (TRAFODION-1099) LP Bug: 1437384 - sqenvcom.sh. Our CLASSPATH is too big.

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-1099. --- Resolution: Won't Fix > LP Bug: 1437384 - sqenvcom.sh.Our CLASSPATH

[jira] [Commented] (TRAFODION-245) LP Bug: 1315527 - JDBC T2 : Batch execute with prepared insert stmt containing multiple rows fails

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388683#comment-16388683 ] Sandhya Sundaresan commented on TRAFODION-245: -- Batch Updates and inserts are working fine

[jira] [Commented] (TRAFODION-1151) LP Bug: 1442483 - SQL queries hang when Region Server goes down

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16388647#comment-16388647 ] Sandhya Sundaresan commented on TRAFODION-1151: --- This issue has been addressed by

[jira] [Resolved] (TRAFODION-1151) LP Bug: 1442483 - SQL queries hang when Region Server goes down

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-1151. --- Resolution: Fixed Fix Version/s: 2.2.0 > LP Bug: 1442483 - SQL

[jira] [Assigned] (TRAFODION-2982) JNI HDFS interface should support varied sized large buffers for read/write

2018-03-06 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan reassigned TRAFODION-2982: - Assignee: Selvaganesan Govindarajan > JNI HDFS interface should

[jira] [Created] (TRAFODION-2982) JNI HDFS interface should support varied sized large buffers for read/write

2018-03-06 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-2982: - Summary: JNI HDFS interface should support varied sized large buffers for read/write Key: TRAFODION-2982 URL:

[jira] [Resolved] (TRAFODION-2832) LOB: Insert hangs with a mutli-row insertion that requires internal stringtolob() conversion

2018-03-27 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-2832. --- Resolution: Fixed > LOB: Insert hangs with a mutli-row insertion that

[jira] [Resolved] (TRAFODION-2874) LOB: Add syntax to return filename of a LOB data file for external LOBs.

2018-03-27 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-2874. --- Resolution: Fixed > LOB: Add syntax to return filename of a LOB data

[jira] [Commented] (TRAFODION-2949) LOB: Address performance issues related to inserts in tables containing LOB columns

2018-03-27 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16416027#comment-16416027 ] Sandhya Sundaresan commented on TRAFODION-2949: --- Making a few fixes in this area. # LOB

[jira] [Commented] (TRAFODION-2949) LOB: Address performance issues related to inserts in tables containing LOB columns

2018-03-27 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16416031#comment-16416031 ] Sandhya Sundaresan commented on TRAFODION-2949: --- TBD as part of this JIRA. The

[jira] [Resolved] (TRAFODION-2873) LOB:Cleanup usage of LOBLoad which is deprecated and LobGlobals

2018-04-02 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-2873. --- Resolution: Fixed > LOB:Cleanup usage of LOBLoad which is deprecated and

[jira] [Created] (TRAFODION-3217) Mechanism to drop obsolete cached SPJ library/jar files

2018-09-27 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-3217: - Summary: Mechanism to drop obsolete cached SPJ library/jar files Key: TRAFODION-3217 URL: https://issues.apache.org/jira/browse/TRAFODION-3217

[jira] [Created] (TRAFODION-3216) SPJ libraries need to be stored in metadata table as a blob

2018-09-27 Thread Sandhya Sundaresan (JIRA)
Sandhya Sundaresan created TRAFODION-3216: - Summary: SPJ libraries need to be stored in metadata table as a blob Key: TRAFODION-3216 URL: https://issues.apache.org/jira/browse/TRAFODION-3216

[jira] [Commented] (TRAFODION-3216) SPJ libraries need to be stored in metadata table as a blob

2018-09-27 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16631328#comment-16631328 ] Sandhya Sundaresan commented on TRAFODION-3216: --- The changes include a change that will

[jira] [Assigned] (TRAFODION-3217) Mechanism to drop obsolete cached SPJ library/jar files

2018-09-27 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan reassigned TRAFODION-3217: - Assignee: Hans Zeller > Mechanism to drop obsolete cached SPJ

[jira] [Updated] (TRAFODION-3216) SPJ libraries need to be stored in metadata table as a blob

2018-09-27 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan updated TRAFODION-3216: -- Attachment: Support for LOB storage in metadata for UDR libraries.docx >

[jira] [Updated] (TRAFODION-3216) UDR libraries need to be stored in metadata table as a blob

2018-09-28 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan updated TRAFODION-3216: -- Summary: UDR libraries need to be stored in metadata table as a blob (was:

[jira] [Reopened] (TRAFODION-2287) LOB support in JDBC

2018-09-29 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan reopened TRAFODION-2287: --- > LOB support in JDBC > --- > > Key:

[jira] [Assigned] (TRAFODION-2948) LOB: Support for inlined LOBs

2018-11-30 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan reassigned TRAFODION-2948: - Assignee: xiaozhong.wang (was: Sandhya Sundaresan) > LOB: Support

[jira] [Resolved] (TRAFODION-3216) UDR libraries need to be stored in metadata table as a blob

2018-11-30 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-3216. --- Resolution: Fixed > UDR libraries need to be stored in metadata table as

[jira] [Reopened] (TRAFODION-2408) Support for empty_blob() and update syntax using lobhandle

2018-11-30 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan reopened TRAFODION-2408: --- > Support for empty_blob() and update syntax using lobhandle >

  1   2   >