[jira] [Work started] (TRAFODION-2834) Streamline supported xn access modes

2017-12-08 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2834 started by Anoop Sharma. --- > Streamline supported xn access modes > --

[jira] [Created] (TRAFODION-2834) Streamline supported xn access modes

2017-12-08 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2834: --- Summary: Streamline supported xn access modes Key: TRAFODION-2834 URL: https://issues.apache.org/jira/browse/TRAFODION-2834 Project: Apache Trafodion I

[jira] [Created] (TRAFODION-2731) CodeCleanup: Remove obsolete, legacy and unused code

2017-09-06 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2731: --- Summary: CodeCleanup: Remove obsolete, legacy and unused code Key: TRAFODION-2731 URL: https://issues.apache.org/jira/browse/TRAFODION-2731 Project: Apache Trafo

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

2017-08-31 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16149300#comment-16149300 ] Anoop Sharma commented on TRAFODION-2730: - This issue causes regress/charsets/

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

2017-08-31 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2730: --- Summary: process loop when infer_charset cqd is ON and query invalidation is done Key: TRAFODION-2730 URL: https://issues.apache.org/jira/browse/TRAFODION-2730

[jira] [Created] (TRAFODION-2722) change purgedata to use hbase truncate api instead of drop/create

2017-08-18 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2722: --- Summary: change purgedata to use hbase truncate api instead of drop/create Key: TRAFODION-2722 URL: https://issues.apache.org/jira/browse/TRAFODION-2722 Project

[jira] [Commented] (TRAFODION-2680) CSV_FORMAT function

2017-07-11 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16082755#comment-16082755 ] Anoop Sharma commented on TRAFODION-2680: - Dave, it might be better to look at

[jira] [Created] (TRAFODION-2683) add a new explain option to mask variant fields in output

2017-07-11 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2683: --- Summary: add a new explain option to mask variant fields in output Key: TRAFODION-2683 URL: https://issues.apache.org/jira/browse/TRAFODION-2683 Project: Apache

[jira] [Commented] (TRAFODION-2680) CSV_FORMAT function

2017-07-10 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16080895#comment-16080895 ] Anoop Sharma commented on TRAFODION-2680: - trafodion command line interface tr

[jira] [Assigned] (TRAFODION-2624) cleanat does not drop TDDL table

2017-06-20 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2624: --- Assignee: Prashanth Vasudev > cleanat does not drop TDDL table >

[jira] [Assigned] (TRAFODION-2632) Performing update statistics on metadata tables causes issues

2017-06-03 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2632: --- Assignee: Anoop Sharma > Performing update statistics on metadata tables causes i

[jira] [Created] (TRAFODION-2621) Add support to create a trafodion table LIKE a native hive or HBase table

2017-05-23 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2621: --- Summary: Add support to create a trafodion table LIKE a native hive or HBase table Key: TRAFODION-2621 URL: https://issues.apache.org/jira/browse/TRAFODION-2621

[jira] [Assigned] (TRAFODION-2619) to_timestamp('2017/01/01 00:00:00') fail to convert

2017-05-20 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2619: --- Assignee: Anoop Sharma > to_timestamp('2017/01/01 00:00:00') fail to convert > --

[jira] [Created] (TRAFODION-2610) Add support to register HBase native tables in Traf metadata

2017-05-10 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2610: --- Summary: Add support to register HBase native tables in Traf metadata Key: TRAFODION-2610 URL: https://issues.apache.org/jira/browse/TRAFODION-2610 Project: Apa

[jira] [Assigned] (TRAFODION-2485) function support: Reverse()

2017-04-18 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2485: --- Assignee: Anoop Sharma > function support: Reverse() > --

[jira] [Assigned] (TRAFODION-2540) Drop column on table with generated always as identity column fail

2017-04-18 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2540: --- Assignee: Anoop Sharma > Drop column on table with generated always as identity c

[jira] [Assigned] (TRAFODION-2591) Creating INDEX on ADDED column gives corrupted results

2017-04-12 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2591: --- Assignee: Anoop Sharma > Creating INDEX on ADDED column gives corrupted results >

[jira] [Created] (TRAFODION-2584) Add support to register hive objects in trafodion metadata

2017-04-07 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2584: --- Summary: Add support to register hive objects in trafodion metadata Key: TRAFODION-2584 URL: https://issues.apache.org/jira/browse/TRAFODION-2584 Project: Apache

[jira] [Assigned] (TRAFODION-2582) Two timestamp minus and cannot cast to interval value

2017-04-05 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2582: --- Assignee: Anoop Sharma (was: Hans Zeller) > Two timestamp minus and cannot cast

[jira] [Created] (TRAFODION-2498) Add support to run hive DDL commands from trafodion interface

2017-02-23 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2498: --- Summary: Add support to run hive DDL commands from trafodion interface Key: TRAFODION-2498 URL: https://issues.apache.org/jira/browse/TRAFODION-2498 Project: Ap

[jira] [Created] (TRAFODION-2492) Add support to access native hive views from trafodion

2017-02-18 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2492: --- Summary: Add support to access native hive views from trafodion Key: TRAFODION-2492 URL: https://issues.apache.org/jira/browse/TRAFODION-2492 Project: Apache Tra

[jira] [Work started] (TRAFODION-2492) Add support to access native hive views from trafodion

2017-02-18 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2492 started by Anoop Sharma. --- > Add support to access native hive views from trafodion >

[jira] [Resolved] (TRAFODION-1843) Allow USER option(s) to be defined as defaults in a table column definition

2017-02-17 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1843. - Resolution: Fixed > Allow USER option(s) to be defined as defaults in a table column d

[jira] [Resolved] (TRAFODION-2181) allow incompatible operations in sql queries

2017-02-17 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-2181. - Resolution: Fixed > allow incompatible operations in sql queries > ---

[jira] [Resolved] (TRAFODION-2234) turn aligned row format for tables to ON by default

2017-02-17 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-2234. - Resolution: Fixed > turn aligned row format for tables to ON by default >

[jira] [Resolved] (TRAFODION-2225) Misc enhancements and fixes

2017-02-17 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-2225. - Resolution: Fixed > Misc enhancements and fixes > --- > >

[jira] [Resolved] (TRAFODION-2246) add support for GROUP BY ROLLUP feature

2017-02-17 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-2246. - Resolution: Fixed > add support for GROUP BY ROLLUP feature >

[jira] [Created] (TRAFODION-2457) regress/compGeneral/TEST042 shows non-deterministic results

2017-01-21 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2457: --- Summary: regress/compGeneral/TEST042 shows non-deterministic results Key: TRAFODION-2457 URL: https://issues.apache.org/jira/browse/TRAFODION-2457 Project: Apac

[jira] [Assigned] (TRAFODION-1637) seabase/TEST022 fails with PR #178

2017-01-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1637: --- Assignee: Anoop Sharma > seabase/TEST022 fails with PR #178 > ---

[jira] [Assigned] (TRAFODION-1766) columns_view should display columns of view and procedures also

2017-01-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1766: --- Assignee: Anoop Sharma > columns_view should display columns of view and procedur

[jira] [Assigned] (TRAFODION-1767) Add owner, create_time, modified_time columns to the metadata views

2017-01-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1767: --- Assignee: Anoop Sharma > Add owner, create_time, modified_time columns to the met

[jira] [Assigned] (TRAFODION-1796) Executor TEST131 fails with does not exist or is inaccessible error

2017-01-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1796: --- Assignee: Anoop Sharma > Executor TEST131 fails with does not exist or is inacce

[jira] [Assigned] (TRAFODION-2299) SQL statement type is not clear when using the WITH clause

2017-01-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2299: --- Assignee: Anoop Sharma > SQL statement type is not clear when using the WITH clau

[jira] [Assigned] (TRAFODION-2401) Creating Foreign Key constraint NOT ENFORCE still create system index

2017-01-17 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2401: --- Assignee: Anoop Sharma > Creating Foreign Key constraint NOT ENFORCE still create

[jira] [Created] (TRAFODION-2439) add/externalize support to create trafodion views on hive tables

2017-01-11 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2439: --- Summary: add/externalize support to create trafodion views on hive tables Key: TRAFODION-2439 URL: https://issues.apache.org/jira/browse/TRAFODION-2439 Project:

[jira] [Assigned] (TRAFODION-2416) HBASE OPTIONS on CREATE INDEX have no effect

2016-12-22 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2416: --- Assignee: Anoop Sharma > HBASE OPTIONS on CREATE INDEX have no effect > -

[jira] [Assigned] (TRAFODION-2413) row tatal length is wrongly calculated in Aligned format

2016-12-21 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2413: --- Assignee: Anoop Sharma > row tatal length is wrongly calculated in Aligned format

[jira] [Commented] (TRAFODION-2397) Inserting null into BOOLEAN column via trafci fails

2016-12-12 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15743781#comment-15743781 ] Anoop Sharma commented on TRAFODION-2397: - boolean support from odbc/jdbc is n

[jira] [Commented] (TRAFODION-2387) add unhex function to trafodion

2016-12-05 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15722811#comment-15722811 ] Anoop Sharma commented on TRAFODION-2387: - Traf has existing functions convert

[jira] [Created] (TRAFODION-2385) Add support in clients for boolean, tinyint, largeint unsigned datatypes

2016-12-01 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2385: --- Summary: Add support in clients for boolean, tinyint, largeint unsigned datatypes Key: TRAFODION-2385 URL: https://issues.apache.org/jira/browse/TRAFODION-2385

[jira] [Commented] (TRAFODION-2363) Add support to return metadata info about hive tables in relational format

2016-11-21 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15685122#comment-15685122 ] Anoop Sharma commented on TRAFODION-2363: - Hive MD info is returned in relatio

[jira] [Created] (TRAFODION-2363) Add support to return metadata info about hive tables in relational format

2016-11-21 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2363: --- Summary: Add support to return metadata info about hive tables in relational format Key: TRAFODION-2363 URL: https://issues.apache.org/jira/browse/TRAFODION-2363

[jira] [Commented] (TRAFODION-2312) Add support for GROUPING function for rollup aggregation

2016-11-07 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15645249#comment-15645249 ] Anoop Sharma commented on TRAFODION-2312: - In addition to GROUPING, also add s

[jira] [Created] (TRAFODION-2312) Add support for GROUPING function for rollup aggregation

2016-10-26 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2312: --- Summary: Add support for GROUPING function for rollup aggregation Key: TRAFODION-2312 URL: https://issues.apache.org/jira/browse/TRAFODION-2312 Project: Apache T

[jira] [Created] (TRAFODION-2290) add pcode support for exprs on aligned format tables with added cols

2016-10-18 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2290: --- Summary: add pcode support for exprs on aligned format tables with added cols Key: TRAFODION-2290 URL: https://issues.apache.org/jira/browse/TRAFODION-2290 Proj

[jira] [Created] (TRAFODION-2263) Move Similarity check for hive tables to master executor root operator

2016-10-04 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2263: --- Summary: Move Similarity check for hive tables to master executor root operator Key: TRAFODION-2263 URL: https://issues.apache.org/jira/browse/TRAFODION-2263 Pr

[jira] [Commented] (TRAFODION-2247) upsert on altered aligned format table with missing columns inserts incorrect values

2016-09-28 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15530096#comment-15530096 ] Anoop Sharma commented on TRAFODION-2247: - Another case where self referencing

[jira] [Created] (TRAFODION-2247) upsert on altered aligned format table with missing columns inserts incorrect values

2016-09-27 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2247: --- Summary: upsert on altered aligned format table with missing columns inserts incorrect values Key: TRAFODION-2247 URL: https://issues.apache.org/jira/browse/TRAFODION-2247

[jira] [Work started] (TRAFODION-2246) add support for GROUP BY ROLLUP feature

2016-09-26 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2246 started by Anoop Sharma. --- > add support for GROUP BY ROLLUP feature > ---

[jira] [Created] (TRAFODION-2246) add support for GROUP BY ROLLUP feature

2016-09-26 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2246: --- Summary: add support for GROUP BY ROLLUP feature Key: TRAFODION-2246 URL: https://issues.apache.org/jira/browse/TRAFODION-2246 Project: Apache Trafodion

[jira] [Work started] (TRAFODION-2234) turn aligned row format for tables to ON by default

2016-09-20 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2234 started by Anoop Sharma. --- > turn aligned row format for tables to ON by default > ---

[jira] [Created] (TRAFODION-2234) turn aligned row format for tables to ON by default

2016-09-20 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2234: --- Summary: turn aligned row format for tables to ON by default Key: TRAFODION-2234 URL: https://issues.apache.org/jira/browse/TRAFODION-2234 Project: Apache Trafod

[jira] [Created] (TRAFODION-2225) Misc enhancements and fixes

2016-09-15 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2225: --- Summary: Misc enhancements and fixes Key: TRAFODION-2225 URL: https://issues.apache.org/jira/browse/TRAFODION-2225 Project: Apache Trafodion Issue Type

[jira] [Updated] (TRAFODION-1755) MXOSRVR abends when doing an explain command

2016-09-09 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma updated TRAFODION-1755: Component/s: sql-exe > MXOSRVR abends when doing an explain command > --

[jira] [Assigned] (TRAFODION-1755) MXOSRVR abends when doing an explain command

2016-09-09 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1755: --- Assignee: Anoop Sharma (was: RuoYu Zuo) > MXOSRVR abends when doing an explain c

[jira] [Work started] (TRAFODION-2210) some operations on volatile and external tables return error is schema default is set to hive

2016-09-08 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2210 started by Anoop Sharma. --- > some operations on volatile and external tables return error is schem

[jira] [Created] (TRAFODION-2210) some operations on volatile and external tables return error is schema default is set to hive

2016-09-08 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2210: --- Summary: some operations on volatile and external tables return error is schema default is set to hive Key: TRAFODION-2210 URL: https://issues.apache.org/jira/browse/TRAFODI

[jira] [Created] (TRAFODION-2184) enable group by, order by and other features currently within special cqds

2016-08-24 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2184: --- Summary: enable group by, order by and other features currently within special cqds Key: TRAFODION-2184 URL: https://issues.apache.org/jira/browse/TRAFODION-2184

[jira] [Created] (TRAFODION-2181) allow incompatible operations in sql queries

2016-08-23 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2181: --- Summary: allow incompatible operations in sql queries Key: TRAFODION-2181 URL: https://issues.apache.org/jira/browse/TRAFODION-2181 Project: Apache Trafodion

[jira] [Created] (TRAFODION-2180) Enable and add support for various non-ansi sql syntax and functionality

2016-08-23 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2180: --- Summary: Enable and add support for various non-ansi sql syntax and functionality Key: TRAFODION-2180 URL: https://issues.apache.org/jira/browse/TRAFODION-2180

[jira] [Commented] (TRAFODION-2163) support MYSQL style function GROUP_CONCAT

2016-08-15 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15421151#comment-15421151 ] Anoop Sharma commented on TRAFODION-2163: - yes, pivot and pivot_group has the

[jira] [Created] (TRAFODION-2162) Enhance showplan output to show the expr instruction being generated

2016-08-14 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2162: --- Summary: Enhance showplan output to show the expr instruction being generated Key: TRAFODION-2162 URL: https://issues.apache.org/jira/browse/TRAFODION-2162 Proj

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

2016-08-04 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2141: --- Summary: Provide cluster view of region stats over all regions. Key: TRAFODION-2141 URL: https://issues.apache.org/jira/browse/TRAFODION-2141 Project: Apache Tra

[jira] [Created] (TRAFODION-2137) Improve metadata access time during query compilation

2016-08-02 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2137: --- Summary: Improve metadata access time during query compilation Key: TRAFODION-2137 URL: https://issues.apache.org/jira/browse/TRAFODION-2137 Project: Apache Traf

[jira] [Assigned] (TRAFODION-1843) Allow USER option(s) to be defined as defaults in a table column definition

2016-07-13 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1843: --- Assignee: Anoop Sharma > Allow USER option(s) to be defined as defaults in a tabl

[jira] [Assigned] (TRAFODION-2106) to_char() can't compare with one date

2016-07-13 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-2106: --- Assignee: Anoop Sharma > to_char() can't compare with one date >

[jira] [Created] (TRAFODION-2099) add support for boolean datatype

2016-07-07 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2099: --- Summary: add support for boolean datatype Key: TRAFODION-2099 URL: https://issues.apache.org/jira/browse/TRAFODION-2099 Project: Apache Trafodion Issue

[jira] [Work started] (TRAFODION-2099) add support for boolean datatype

2016-07-07 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2099 started by Anoop Sharma. --- > add support for boolean datatype > >

[jira] [Commented] (TRAFODION-1673) Implement the WITH clause in Trafodion SQL for simple use cases

2016-07-06 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15365622#comment-15365622 ] Anoop Sharma commented on TRAFODION-1673: - when a make is done, the parser com

[jira] [Commented] (TRAFODION-2086) Add support for largeint unsigned datatype

2016-06-23 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15346985#comment-15346985 ] Anoop Sharma commented on TRAFODION-2086: - Support for largeint unsigned will

[jira] [Work started] (TRAFODION-2086) Add support for largeint unsigned datatype

2016-06-22 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2086 started by Anoop Sharma. --- > Add support for largeint unsigned datatype >

[jira] [Created] (TRAFODION-2086) Add support for largeint unsigned datatype

2016-06-22 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2086: --- Summary: Add support for largeint unsigned datatype Key: TRAFODION-2086 URL: https://issues.apache.org/jira/browse/TRAFODION-2086 Project: Apache Trafodion

[jira] [Work started] (TRAFODION-2084) inserting invalid data into a hive column does not return error

2016-06-21 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2084 started by Anoop Sharma. --- > inserting invalid data into a hive column does not return error > ---

[jira] [Created] (TRAFODION-2084) inserting invalid data into a hive column does not return error

2016-06-21 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2084: --- Summary: inserting invalid data into a hive column does not return error Key: TRAFODION-2084 URL: https://issues.apache.org/jira/browse/TRAFODION-2084 Project:

[jira] [Created] (TRAFODION-2072) long char columns cause non-deterministic behavior

2016-06-17 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2072: --- Summary: long char columns cause non-deterministic behavior Key: TRAFODION-2072 URL: https://issues.apache.org/jira/browse/TRAFODION-2072 Project: Apache Trafod

[jira] [Created] (TRAFODION-2060) Add support for native tinyint datatype

2016-06-11 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2060: --- Summary: Add support for native tinyint datatype Key: TRAFODION-2060 URL: https://issues.apache.org/jira/browse/TRAFODION-2060 Project: Apache Trafodion

[jira] [Work started] (TRAFODION-2060) Add support for native tinyint datatype

2016-06-11 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2060 started by Anoop Sharma. --- > Add support for native tinyint datatype > ---

[jira] [Created] (TRAFODION-2022) add support for purgedata command to remove hive data

2016-06-01 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2022: --- Summary: add support for purgedata command to remove hive data Key: TRAFODION-2022 URL: https://issues.apache.org/jira/browse/TRAFODION-2022 Project: Apache Traf

[jira] [Assigned] (TRAFODION-960) LP Bug: 1415248 - Update stats does not work for a volatile table

2016-05-31 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-960: -- Assignee: David Wayne Birdsall (was: Anoop Sharma) > LP Bug: 1415248 - Update stats

[jira] [Resolved] (TRAFODION-2013) Hive null values for string datatype are not being handled correctly

2016-05-31 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-2013. - Resolution: Fixed Fix Version/s: 2.1-incubating > Hive null values for string d

[jira] [Resolved] (TRAFODION-1961) An empty string in HIVE shouldn't be treated as NULL in Trafodion

2016-05-27 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1961. - Resolution: Fixed Fix Version/s: 2.1-incubating > An empty string in HIVE shou

[jira] [Commented] (TRAFODION-1961) An empty string in HIVE shouldn't be treated as NULL in Trafodion

2016-05-27 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15304419#comment-15304419 ] Anoop Sharma commented on TRAFODION-1961: - This will be handled as part of JIR

[jira] [Resolved] (TRAFODION-1164) LP Bug: 1443463 - '\N' and empty string are both treated as null when selecting hive table.

2016-05-27 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1164. - Resolution: Fixed > LP Bug: 1443463 - '\N' and empty string are both treated as null w

[jira] [Commented] (TRAFODION-1164) LP Bug: 1443463 - '\N' and empty string are both treated as null when selecting hive table.

2016-05-27 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15304413#comment-15304413 ] Anoop Sharma commented on TRAFODION-1164: - This is fixed as part of JIRA TRAFO

[jira] [Commented] (TRAFODION-2013) Hive null values for string datatype are not being handled correctly

2016-05-26 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15303489#comment-15303489 ] Anoop Sharma commented on TRAFODION-2013: - During create of a hive delimited t

[jira] [Assigned] (TRAFODION-1164) LP Bug: 1443463 - '\N' and empty string are both treated as null when selecting hive table.

2016-05-24 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1164: --- Assignee: Anoop Sharma (was: Selvaganesan Govindarajan) > LP Bug: 1443463 - '\N'

[jira] [Assigned] (TRAFODION-1961) An empty string in HIVE shouldn't be treated as NULL in Trafodion

2016-05-24 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma reassigned TRAFODION-1961: --- Assignee: Anoop Sharma (was: Selvaganesan Govindarajan) > An empty string in HIV

[jira] [Commented] (TRAFODION-2013) Hive null values for string datatype are not being handled correctly

2016-05-24 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15299274#comment-15299274 ] Anoop Sharma commented on TRAFODION-2013: - An error is being returned if a sin

[jira] [Work started] (TRAFODION-2013) Hive null values for string datatype are not being handled correctly

2016-05-24 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2013 started by Anoop Sharma. --- > Hive null values for string datatype are not being handled correctly

[jira] [Created] (TRAFODION-2013) Hive null values for string datatype are not being handled correctly

2016-05-24 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2013: --- Summary: Hive null values for string datatype are not being handled correctly Key: TRAFODION-2013 URL: https://issues.apache.org/jira/browse/TRAFODION-2013 Proj

[jira] [Created] (TRAFODION-2006) hive table structure and data modification is not detected

2016-05-22 Thread Anoop Sharma (JIRA)
Anoop Sharma created TRAFODION-2006: --- Summary: hive table structure and data modification is not detected Key: TRAFODION-2006 URL: https://issues.apache.org/jira/browse/TRAFODION-2006 Project: Apache

[jira] [Work started] (TRAFODION-2006) hive table structure and data modification is not detected

2016-05-22 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2006 started by Anoop Sharma. --- > hive table structure and data modification is not detected >

[jira] [Resolved] (TRAFODION-1807) Support ISO8601 timezone specification in datetime values

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1807. - Resolution: Fixed Fix Version/s: 2.0-incubating TZ diff specification has been

[jira] [Resolved] (TRAFODION-1994) enable alter table support change column default value

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1994. - Resolution: Fixed > enable alter table support change column default value > -

[jira] [Resolved] (TRAFODION-1638) Transaction should be used even for select statement in read uncommitted access when it is done within a transaction

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1638?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1638. - Resolution: Fixed Fix Version/s: 2.0-incubating Fixed: >>select * from t for

[jira] [Resolved] (TRAFODION-1645) Add sql support to retrieve region space and access stats for trafodion tables

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1645. - Resolution: Fixed Fix Version/s: 2.0-incubating > Add sql support to retrieve r

[jira] [Resolved] (TRAFODION-1256) LP Bug: 1461134 - ALTER TABLE DROP COLUMN does not check for dependent objects

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1256. - Resolution: Fixed > LP Bug: 1461134 - ALTER TABLE DROP COLUMN does not check for depen

[jira] [Resolved] (TRAFODION-1793) GET commands that report usage information should return 3 or 2 part ansi object names

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1793. - Resolution: Fixed Fix Version/s: 2.0-incubating Fixed: >>create view v as sele

[jira] [Resolved] (TRAFODION-1849) Add support to rename column in an existing table

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1849. - Resolution: Fixed Fix Version/s: 2.0-incubating Fixed: >>invoke t; -- Definit

[jira] [Resolved] (TRAFODION-1808) Query caching is not treating datetime values with fractional precision correctly

2016-05-19 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anoop Sharma resolved TRAFODION-1808. - Resolution: Fixed Fix Version/s: 2.0-incubating Fixed: >>select time '10:12:23

  1   2   >