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

[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  
(was: LOB:Cleanup usage of LOBLoad which si deprecated and LobGlobals)

> LOB:Cleanup usage of LOBLoad which is deprecated and LobGlobals
> ---
>
> Key: TRAFODION-2873
> URL: https://issues.apache.org/jira/browse/TRAFODION-2873
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-exe
>Affects Versions: 2.3
>Reporter: Sandhya Sundaresan
>Assignee: Sandhya Sundaresan
>Priority: Major
>
> The LOBGlobals structure contains information relevant to LOBLoad which was 
> an operator initially designed to operate at the disk level. It is no longer 
> needed/relevant so cleaning up that code and simplifying the LOBGlobals 
> sturcture as well to keep only the relevant data members. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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

[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 that the Jira is being 
filed for and some examples showing what the usage is. That way one doesnt have 
to search and look for oracle doc on what it does. It will also help to list 
what functionality or subset of it is being proposed to be supported 

> support listagg function
> 
>
> Key: TRAFODION-2494
> URL: https://issues.apache.org/jira/browse/TRAFODION-2494
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
>
> to simulate Oracle's listagg function.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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

[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' command to truncate hive tables. 

It doesn't support 'truncate table' to remove data from traf tables. For that 
purgedata need to be used.

Truncate table could be enabled for traf tables.

 

> support Oracle's TRUNCATE TABLE syntax 
> ---
>
> Key: TRAFODION-1969
> URL: https://issues.apache.org/jira/browse/TRAFODION-1969
> Project: Apache Trafodion
>  Issue Type: Improvement
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
>
> Oracle 'TRUNCATE TABLE' is used to delete all data for a given table.
> It should be the same command in Trafodion 'purgedata'.
> It will be convenient that Trafodion directly support this syntax.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Assigned] (TRAFODION-2088) support null last and null first in ORDER BY

[liu ming (JIRA)]

 [ 
https://issues.apache.org/jira/browse/TRAFODION-2088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liu ming reassigned TRAFODION-2088:
---

Assignee: liu ming

> support null last and null first in ORDER BY
> 
>
> Key: TRAFODION-2088
> URL: https://issues.apache.org/jira/browse/TRAFODION-2088
> Project: Apache Trafodion
>  Issue Type: Improvement
>Reporter: liu ming
>Assignee: liu ming
>Priority: Minor
>
> handle the syntax ‘order by nulls last’



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Resolved] (TRAFODION-2228) add encryption functions for Trafodion

[liu ming (JIRA)]

 [ 
https://issues.apache.org/jira/browse/TRAFODION-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liu ming resolved TRAFODION-2228.
-
   Resolution: Fixed
Fix Version/s: 2.3

> add encryption functions for Trafodion
> --
>
> Key: TRAFODION-2228
> URL: https://issues.apache.org/jira/browse/TRAFODION-2228
> Project: Apache Trafodion
>  Issue Type: Sub-task
>Reporter: liu ming
>Assignee: Weiqing Xu
>Priority: Major
> Fix For: 2.3
>
>
> AES_DECRYPT() Decrypt using AES
> AES_ENCRYPT() Encrypt using AES
> ASYMMETRIC_DECRYPT()  Decrypt ciphertext using private or public key
> ASYMMETRIC_DERIVE()   Derive symmetric key from asymmetric keys
> ASYMMETRIC_ENCRYPT()  Encrypt cleartext using private or public key
> ASYMMETRIC_SIGN() Generate signature from digest
> ASYMMETRIC_VERIFY()   Verify that signature matches digest



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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

[liu ming (JIRA)]

 [ 
https://issues.apache.org/jira/browse/TRAFODION-2494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liu ming reassigned TRAFODION-2494:
---

Assignee: liu ming  (was: taian.wei)

> support listagg function
> 
>
> Key: TRAFODION-2494
> URL: https://issues.apache.org/jira/browse/TRAFODION-2494
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
>
> to simulate Oracle's listagg function.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2157) add built-in support of popular MySQL functions

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-2157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16365090#comment-16365090
 ] 

ASF GitHub Bot commented on TRAFODION-2157:
---

GitHub user traflm opened a pull request:

https://github.com/apache/trafodion/pull/1444

[TRAFODION-2157] add MySQL function unix_timestamp,uuid,sleep

This is to add three MySQL compatible functions into Trafodion. 
It is required for another JIRA to add unix_timestamp, uuid as default 
value of a column definition.
sleep is simple to add, so add with this change as well.
The document will be updated for a separate JIRA asap.

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/traflm/trafodion TRAFODION-2157

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/trafodion/pull/1444.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #1444


commit dbe4cac9c8e58c8dc9c6b86b5c473320df5c44c3
Author: Liu Ming 
Date:   2018-02-14T08:57:58Z

[TRAFODION-2157] add MySQL function unix_timestamp,uuid,sleep

commit 3555983cdeb03059277913babd646400f5f319ff
Author: Liu Ming 
Date:   2018-02-14T08:58:30Z

Merge branch 'master' of git://git.apache.org/trafodion into TRAFODION-2157

commit 3c6bce6e10e8f319bcdeffa272ffc4ac31a74f48
Author: Liu Ming 
Date:   2018-02-14T21:51:10Z

[TRAFODION-2157] fix various issues




> add built-in support of popular MySQL functions
> ---
>
> Key: TRAFODION-2157
> URL: https://issues.apache.org/jira/browse/TRAFODION-2157
> Project: Apache Trafodion
>  Issue Type: Umbrella
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
>
> To make migration easier, it will be great to add support for those very 
> popular MySQL functions.
> For example GROUP_CONCAT



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (TRAFODION-2958) Consolidate the master and backup files in dcs conf folder to a single file (masters)

[Anuradha Hegde (JIRA)]

Anuradha Hegde created TRAFODION-2958:
-

 Summary: Consolidate the master and backup files in dcs conf 
folder to a single file (masters)
 Key: TRAFODION-2958
 URL: https://issues.apache.org/jira/browse/TRAFODION-2958
 Project: Apache Trafodion
  Issue Type: Improvement
  Components: dcs
Affects Versions: any
Reporter: Anuradha Hegde
Assignee: Anuradha Hegde


Currently for DCS HA, dcs maintains 2 files in dcs conf folder (master and 
backup-masters). 

Instead of maintaining 2 different files for masters, we will maintain one 
masters in the conf folder which will contain the list of all assigned dcs 
master hosts. The first entry in the file will be primary DCS master



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)