All Forums

Covers Teradata database extensibility, including UDFs, Geospatial and Hadoop / Map-Reduce. For articles, blogs and more, see the Extensibility section of the site.

You must login to post to the forums.
urgent : xml conversion Topic by Sayandeep 09 Sep 2014

have create the below proc to invoke as_shred_batch ,
REPLACE PROCEDURE MY_SHREDBATCH_SP
(IN sourceDataQuery varchar(6000),IN annotatedSchemaID varchar(32),OUT resultCode varchar(128))
SPMAIN:BEGIN
 DECLARE annotatedSchema XML;
 DECLARE inputCursor CURSOR FOR SELECT ANNOTATED_SCHEMA from
 
 SHREDMAPPING WHERE SCHEMA_ID = :annotatedSchemaID;

3071 views
3 replies, 3 years ago
Oracle functions in TD 14 Topic by wderwedu 16 Oct 2013

 
Before 14 the Oracle functions where implemented as UDF's in TD.  Now in TD 14 they are built in. Is it still using UDFs? Or how is it implemented.

2761 views
6 replies, 3 years ago
Teradata and Hadoop Hive Data Type mapping Topic by sourabhpotnis 10 Mar 2014 teradata, Hive, export, import, data type

Hi,
When I am trying to export data from Hadoop Hive to Teradata I am getting Datatype mismatch exception, especially for Date and Decimal format.
Just for testing, I tried to export the same Hive table to TD, that was imported from TD into Hive with same schema. But it didn't work.
So I changed everything to Varchar in Teradata, then the import was successful.
 

2401 views
2 replies, 3 years ago
Java interface to TPT OPERATORS Topic by gormleyl 07 Sep 2011 java, tpt, api

Reviewing the TPT manuals, I do not see a set of coding examples using Java.  This is a show-stopper for anyone using Java programs to use TPT.  I would like to see such an example in this forum and in the manuals because Java is arguably the most important enterprise languag

9624 views
6 replies, 3 years ago
Oracle TruncDate UDF - cannot compile truncdate2 Topic by cliff.nelson@nike.com 22 Mar 2016 truncdate2, oracle UDF

We have had the Oracle UDFs installed for a number of years.  But we had an issue with our 15.10 database upgrade and SYSLIB had to be dropped and recreated.  This meant we had to reinstall all of the Oracle UDFs.  The only problem we had is with the truncdate2 UDF (the TruncDate UDF installed truncdate1 and truncdate2 UDFs).  Compiling truncdate2 resulted in:

1102 views
9 replies, 3 years ago
SHA-2 UDFs for Teradata Topic by akuroda 27 Dec 2013 udf, hash, sha2

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

3570 views
6 replies, 3 years ago
Table operator UDF - VARCHAR length Topic by JA256162 05 Sep 2014 udf, varchar, TERADATA datatype

Hi experts
I am  developing a table operator UDF using C/C++ . Teradata release is 15.0.0.8 .

2442 views
1 reply, 3 years ago
MD5 Message Digest UDF Topic by Ian Russell 26 Nov 2015

I am trying to install this downable function for MD5 but get the error below.
https://downloads.teradata.com/download/extensibility/md5-message-digest-udf

1082 views
2 replies, 3 years ago
Calling Web Services Topic by andydoorey 17 Oct 2013 web services, xml

Does anyone know if there is a way of calling a web service from teradata?  
I'm looking at replacing a process that currently uses oracle.  We have stored procedures created which build some XML and then call a web service.  This uses the oracle package UTL_HTTP.

4057 views
7 replies, 3 years ago
SHOW FUNCTION TD_SYSFNLIB.INSTR Topic by Ian Russell 02 Oct 2015 #unity, #instr

I am trying to issue a SHOW FUNCTION on this UDF

1585 views
1 reply, 3 years ago
1531 views
1 reply, 3 years ago
XPATH query Topic by HP 18 Jun 2015

Hi,
I have installed xml services for teradata 14.00, however i am getting a function does not exists error for SYSXML.XPATH_SHREDV function and I believe its because there may be something wrong i might be giving in the syntax as it is an overloaded function.
does anyone have a working example of the same ?
below sql gives me error 5589 function does not exist.

2054 views
2 replies, 3 years ago
Deploy a Customized Python interpreter Topic by emerrf 13 May 2015 python, integration, script_command

I was able to run a python script using SCRIPT_COMMAND like the following example: http://www.info.teradata.com/htmlpubs/DB_TTU_15_00/index.html#page/SQL_Reference/B035_1145_015K/Table_Operators.087.31.html
My question is: can a python interpreter/distribution be deployed into the Teradata infrastructure?

2134 views
1 reply, 4 years ago
Issue with Stored Procedure Topic by wmmiteff 27 Apr 2015 stored procedure

I am working on a stored procedure for dropping all sessions for a specific user and I have written a SP to do this.  the SP creates but it fails when I run it with an id.  I can get the generated SQL out of DBQL and it runs but the SP fails.
 

2260 views
6 replies, 4 years ago
R and Python Analytics with the SCRIPT Table Operator: Teradata Connections group and info Topic by Alexander K 17 Apr 2015 r, python, script, Table Operator, analytics, in-database, programming

On the Teradata Connections website, a new group has been created to foster and encourage discussion, ideas exchange and help with issues on the topic of R and Python Analytics with the SCRIPT Table Operator. Visit:

3154 views
0 replies
UDF - Web Service Call?? Topic by epfatboy 08 Mar 2011

Our organization is looking to leverage an in-house encryption service. The encryption service would be a remote and is running as a web service call platform today. Is it possible to create a UDF which could leverage this remote encryption service? If so where can I get some information which would help explain this to me?

8263 views
1 reply, 4 years ago
1763 views
0 replies
error when compiling Java UDF Topic by erics01 24 Sep 2014 java, udf

Hi,
 
We have the next SQL file:
--------------------------------------------------------------------------------------------------------------------------
CALL SQLJ.REMOVE_JAR('UA_Jar',0);
CALL SQLJ.INSTALL_JAR('CJ!/home/tdatuser/java/Parser.zip','UA_Jar',0);
CREATE FUNCTION ua_family (agentString CHAR(30))
RETURNS CHAR(30)
LANGUAGE JAVA

2384 views
2 replies, 4 years ago
SQl UDF - beyond SCALAR UDF Topic by ajay2.m 07 Jan 2015 sql udf

Hi,

1994 views
3 replies, 4 years ago
1850 views
1 reply, 4 years ago
Passing result set from stored procedure to Cognos Topic by paisano 10 Feb 2015 cognos, stored procedure

Hi
I have a requirement in in which I would like to call a stored procedure from Cognos, passing an ID
to the SP. The SP would retrieve data from a table and then loop through the data, formatting it.
Here is the basic idea:
Cognos calls SP with ID "ABC100".
SP retrieves following data:
100  Julus Caesar
100  crossed
100  the Rubicon

1868 views
7 replies, 4 years ago
TDAT.c Topic by b2s 08 Feb 2015

Hi All,
I need the TDAT.c source code. Been looking for this from quite some time.
If anyone knows, can you please post it here?
I'm trying to transfer data between two teradata systems through Table function.
Thanks

2572 views
2 replies, 4 years ago
XML Services - XML Shredding Topic by jhessie.g 25 Apr 2013 XML Services; XML Shredding; XML

Hi Guys,
With regards to XML shredding, I tried to use SYSXML.XMLXPATH_SHRED1_U but there is an error executing it using my example query below:
select a.* from table(SYSXML.XMLXPATH_SHRED1_U(0,'<ROOT><RPI KEY="11000"><Sales>300</Sales></RPI></ROOT>', null, '/ROOT/RPI', './@KEY{1}, ./Sales/text(){2}')) a;

3348 views
1 reply, 4 years ago
JAVA UDF in TD 13.10 With SQL Query - not able to establish connection with TD Topic by ajay2.m 20 Jan 2015 java user defined functions, java user defined function

Hi,

2394 views
6 replies, 4 years ago
sequence generator UDF Topic by akuroda 12 Apr 2014 udf sequence

Hi all,

 

I just released sequence generator UDF to GitHub.

https://github.com/akuroda/teradata-udf-gen-sequence

 

 

Example:

select * from table(gen_sequence(2,4)) as t;
   sequence
-----------
          2
          4
          3

Enjoy!

 

-- Akira Kuroda

2805 views
2 replies, 4 years ago

Pages