All Forums Extensibility
akuroda 7 posts Joined 05/09
27 Dec 2013
SHA-2 UDFs for Teradata

Hi all,
I just released SHA-2 UDFs (SHA-256/512) to GitHub.
https://github.com/akuroda/teradata-udf-sha2
 
Enjoy!
-- Akira Kuroda

Raja_KT 1246 posts Joined 07/09
29 Dec 2013

Very good. Keep sharing your ideas.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

vc311571 1 post Joined 04/10
25 Jan 2014

Does it can support unicdoe?
Victor

akuroda 7 posts Joined 05/09
02 Feb 2014

Hi Victor,

 

No Unicode support for now.  Do you have any ideas about those issues below?

 

- I'm not sure about the use case. Could you tell me how you are going to use?

 

- We need a separate function name as Teradata doesn't allow overloading Latin and Unicode UDFs. I'm not sure what the appropreiate name for that function... hash_sha256u()?

 

- In Teradata, the Unicode character is not stored as UTF-8 or UTF-16. That may cause some confusion if we compared the hash value generated by other programs.

 

Regards,

 

-- Akira Kuroda

asabitov 1 post Joined 09/10
03 Feb 2014

Using http://downloads.teradata.com/download/tools/unicode-tool-kit
session character set utf8
 
sel hash_sha1(udf_utf16to8('Москва'))
 
result is the same as in Oracle - just found for ourself issue :)
 
--
Regards, Alexander

akuroda 7 posts Joined 05/09
20 Apr 2014

Thanks Alexander,
I tried Unicode Took Kit and seems fine. I added FAQ to the GitHub's wiki. See https://github.com/akuroda/teradata-udf-sha2/wiki
Regards,
-- Akira

tonez01 6 posts Joined 08/10
15 Feb 2016

Hi All,
An old thread but was hoping to get some input as to whether it's safe to run these UDFs in unprotected mode?  I've tested them a fair bit in protected  mode and they run fine.  Has anyone experience any reboots/issues when running in Unprotected mode?
thanks in advance.

You must sign in to leave a comment.