[jira] [Updated] (TRAFODION-3157) Add support for BINARY/VARBINARY datatype to Trafodion

2019-02-21 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma updated TRAFODION-3157: Attachment: BinaryDatatype.docx > Add support for BINARY/VARBINARY datatype to

[jira] [Commented] (TRAFODION-3173) enhance ExeCliInterface fetchAllRows to save the data type

2018-08-09 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16575243#comment-16575243 ] Anoop Sharma commented on TRAFODION-3173: - shouldnt questions/comments asked in a Jira be

[jira] [Commented] (TRAFODION-3181) enhance ExeCliInterface fetchAllRows to get more than 100 rows

2018-08-09 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16575239#comment-16575239 ] Anoop Sharma commented on TRAFODION-3181: - How did you determine that fetchAllRows can only

[jira] [Commented] (TRAFODION-3173) enhance ExeCliInterface fetchAllRows to save the data type

2018-08-05 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16569583#comment-16569583 ] Anoop Sharma commented on TRAFODION-3173: - * ExeCliInterface::fetchAllRows calls method

[jira] [Updated] (TRAFODION-3161) Support ANSI OVERLAY function

2018-08-02 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma updated TRAFODION-3161: Description: OVERLAY modifies a source string by replacing a given substring of the

[jira] [Commented] (TRAFODION-3161) support STUFF function

2018-07-21 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551745#comment-16551745 ] Anoop Sharma commented on TRAFODION-3161: - STUFF seems to be the same as ANSI OVERLAY

[jira] [Assigned] (TRAFODION-3161) support STUFF function

2018-07-21 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-3161: --- Assignee: Anoop Sharma (was: liu ming) > support STUFF function >

[jira] [Created] (TRAFODION-3157) Add support for BINARY/VARBINARY datatype to Trafodion

2018-07-19 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-3157: --- Summary: Add support for BINARY/VARBINARY datatype to Trafodion Key: TRAFODION-3157 URL: https://issues.apache.org/jira/browse/TRAFODION-3157 Project: Apache

[jira] [Commented] (TRAFODION-3155) New feture: Implementing the OVERLAPS predicate

2018-07-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549647#comment-16549647 ] Anoop Sharma commented on TRAFODION-3155: - Could you provide more details and examples on

[jira] [Commented] (TRAFODION-3137) speed up count(*) by read row count from stats in special use cases

2018-07-11 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16540622#comment-16540622 ] Anoop Sharma commented on TRAFODION-3137: - Does update stats always keeps the exact count or

[jira] [Commented] (TRAFODION-3129) round(m,n) function does not cut the value to n digits precision

2018-07-06 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16535136#comment-16535136 ] Anoop Sharma commented on TRAFODION-3129: - precision and scale of round result depends on the

[jira] [Commented] (TRAFODION-3127) to_char enhancement

2018-07-01 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16529372#comment-16529372 ] Anoop Sharma commented on TRAFODION-3127: - Could you provide details on what enhancement is

[jira] [Commented] (TRAFODION-3109) comment can not transfer single quote normally in comment string

2018-06-21 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16519360#comment-16519360 ] Anoop Sharma commented on TRAFODION-3109: - Lei, this change has caused traf compGeneral

[jira] [Commented] (TRAFODION-3101) enhance the 'get table' utility to return number of rows

2018-06-20 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16518651#comment-16518651 ] Anoop Sharma commented on TRAFODION-3101: - Count for Traf tables is returned by issuing a

[jira] [Work started] (TRAFODION-3115) Support nanoseconds(9) precision for Timestamp columns

2018-06-20 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3115 started by Anoop Sharma. --- > Support nanoseconds(9) precision for Timestamp columns >

[jira] [Created] (TRAFODION-3115) Support nanoseconds(9) precision for Timestamp columns

2018-06-20 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-3115: --- Summary: Support nanoseconds(9) precision for Timestamp columns Key: TRAFODION-3115 URL: https://issues.apache.org/jira/browse/TRAFODION-3115 Project: Apache

[jira] [Commented] (TRAFODION-1782) Error 1135 for a primary key column not declared NOT NULL

2018-06-13 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511773#comment-16511773 ] Anoop Sharma commented on TRAFODION-1782: - - Changes to support automatic assignment of NOT

[jira] [Updated] (TRAFODION-3086) Traf support for DDL operations directly on Hive objects

2018-06-04 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma updated TRAFODION-3086: Attachment: HiveDDL.docx > Traf support for DDL operations directly on Hive objects

[jira] [Created] (TRAFODION-3086) Traf support for DDL operations directly on Hive objects

2018-05-24 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-3086: --- Summary: Traf support for DDL operations directly on Hive objects Key: TRAFODION-3086 URL: https://issues.apache.org/jira/browse/TRAFODION-3086 Project:

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

2018-05-24 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16489433#comment-16489433 ] Anoop Sharma commented on TRAFODION-3070: - See  comments in trafodion-3084 regarding

[jira] [Commented] (TRAFODION-3084) Cannot create comment on HBASE table

2018-05-24 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16489429#comment-16489429 ] Anoop Sharma commented on TRAFODION-3084: - comment can be added on an object which has an

[jira] [Work started] (TRAFODION-1782) Error 1135 for a primary key column not declared NOT NULL

2018-05-18 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-1782 started by Anoop Sharma. --- > Error 1135 for a primary key column not declared NOT NULL >

[jira] [Commented] (TRAFODION-3015) retrieve a value from numeric type get no result if using xx='value'

2018-05-13 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16473760#comment-16473760 ] Anoop Sharma commented on TRAFODION-3015: - When a NUMERIC datatype precision is > 18, it is

[jira] [Commented] (TRAFODION-3025) order by clause in subquery does not work

2018-04-27 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16456616#comment-16456616 ] Anoop Sharma commented on TRAFODION-3025: - you can try:   select * from (select [first 10] *

[jira] [Created] (TRAFODION-3027) Enhance jenkins check tests to include more tests

2018-04-18 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-3027: --- Summary: Enhance jenkins check tests to include more tests Key: TRAFODION-3027 URL: https://issues.apache.org/jira/browse/TRAFODION-3027 Project: Apache

[jira] [Assigned] (TRAFODION-2979) Enhance to_date and support transfering string to timestamp with millseconds

2018-03-09 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2979: --- Assignee: Anoop Sharma > Enhance to_date and support transfering string to

[jira] [Assigned] (TRAFODION-2980) Add build-in function instr as Oracle

2018-03-06 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2980: --- Assignee: Anoop Sharma > Add build-in function instr as Oracle >

[jira] [Commented] (TRAFODION-2494) support listagg function

2018-02-14 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16365154#comment-16365154 ] Anoop Sharma commented on TRAFODION-2494: - It will be good to add some details about functions

[jira] [Commented] (TRAFODION-1969) support Oracle's TRUNCATE TABLE syntax

2018-02-14 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16365151#comment-16365151 ] Anoop Sharma commented on TRAFODION-1969: - trafodion currently supports 'truncate table'