0 - 50 of 95 tags for java

Pages

The Teradata JDBC Driver enables Java applications to connect to the Teradata Database.

Hi Tom,

We are in process of creating a Java user defined Function and in order to achieve that  we have deployed the JAR File in the database and

 creating a function/procedure on the top of it  using the below two approaches :

 

Hallo all,
I have created a Java external procedure that returns a dynamic result set. I can successfully call it and it returns the correct data. Now how can I store this returned data to a new (temporary) table?

I wrote a Java stored procedure, packed it into a jar and installed it into the Teradata database. I want to use the default database connection as described here [1]. Most of the code was generated by the Teradata wizard for stored procedures.
 

my command line "java -version" returns a found java jre:
"java version "1.8.0_66"
java (tm) SE Runtime Environment (build 1.8.0_66-b18)
java hotspot(TM) client VM (build 25.66-b18, mixed mode)

And when I click through my windows explorer, I can find java.exe in here:
c:\program files (x86)\java\jdk1.8.0_66\bin

Teradata Studio is an administrative tool to help Teradata customers administer their Teradata and Aster Database systems.

Teradata Studio Express is an information discovery tool that retrieves data from Teradata, Aster, and Hadoop Database systems and allows the data to be manipulated and stored on the desktop.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section at Teradata Plug-in for Eclipse . The 15.10 release builds on the 15.00.02 offering by boasting increased functionality.

HI, we have a sqoop job that exports data to Teradata hourly. Sometimes job fails with untranslatable character error. We would like to know, if there is any Java Function to check if the string is translatable by teradata. This is of higher priority. Please let us know, if there are any questions.

Hi,
 
I have an external procedure that I have been working on that Mimics ORACLE's DBMS OUTPUT using FileOutputStream. It works fine in my TD 15.0.0.8 VM but does not work in our Production box. Do you guys know any restriction that we have on a production box that will prevent FileOutputStream from executing?

I've created a Java Function and imported it in TeraData
But after few thousand executions, the function becomes too slow.
You can find below output from TOP command.
USER       PR   NI VIRT    RES  SHR  S %CPU %MEM    TIME+     COMMAND
tdatuser  23   8  815m  33m 1976 S  200   1.4          1835:21  udfsectsk
 

Hello All,
 
I am currently in the process of developing a complete end-end solution that will migrate objects/data from Teradata to Hadoop and vise versa.
 
When researched, i got the articles on TERADATA CONNECTORS FOR HADOOP (COMMAND LINE INTERFACE) and their respective  tutorial document.
 
 

Beginning with Teradata Database 14.0 and Teradata JDBC Driver 13.10.00.21, the Client Attributes feature records a variety of information about the client system and client software in the system tables DBC.SessionTbl and DBC.EventLog.

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))

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section at Teradata Plug-in for Eclipse . The 15.00 release builds on the 14.10.01 offering by boasting increased functionality.

 

Teradata Studio Express 15.00 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.

I have a java udf that basically just does a bunch of shows on each and every procedure and macro and then inserts those into a table. The jar is installed and my definition for the procedure is below. The problem i'm getting is i keep getting the error:


Stored Procedures


SQL Stored Procedures were added to Teradata around 2003 with the release of Teradata V2R5.1. Since then the capabilities of SQL Stored Procedure s has been expanded. However, there are still some queries that cannot be run directly from within a Stored Procedure.

 

Hello all,
 
Thanks in advance for reading this.  
 
I am trying to pull data from Teradata and load it into MySQL without hitting the disk.  
 
I am currently doing it with a perl script and connecting BTEQ to LOAD DATA INFILE with a named pipe in linux.  
 

hi,
I have a table with same column title(not the column names), runing a SQL on it from Java is returing same values for both the columns, it is because of same column title, but same SQL in SQL Assitant returns correct values, where can i find and confirm if same title is reason. is there a driver documentation which states this behaviour.

We will try to parse Apache access log right now and see how badly structured data can be trasfromed into SQL-like table. I suppose you did already install  Aster Developer Express and ready to create your first Aster project.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section at Teradata Plug-in for Eclipse . The 14.10.01 release builds on the 14.10.00 offering by boasting increased functionality.

NOTE: Support for Hadoop and Smart Loader for Hadoop is now added back into Teradata Plug-in for Eclipse with support for Hortonworks HDP versions 1.1.0.17 and 1.3.2.

Teradata Studio Express 14.10.01 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.

We need to make UDP connections from Java UDF functions to run some external processing. This processing is multithreaded and we can serve up to 100 concurrent requests.
The problem we experience is that the Teradata server does not open more than 2 UDP/IP connections at any one time. 

I'm trying to build a table operator that writes to multiple tables.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section at Teradata Plug-in for Eclipse . The 14.10.00 release builds on the 14.02.00 offering by boasting increased functionality.

Teradata Studio Express 14.10 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.

Teradata Studio 14.10 is now available for download. Teradata Studio is an administration tool for creating and administering database objects. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

I got the package installed correctly but it will not open because it says I need version 1.6 or greater.  I tried going out online and finding this download and when I think I have it installed, I still get the error.  Has anyone run into this and if so what can be done to get this error fixed.
 
Thanks!

Has anyone successfully used the Teradata driver with LDAP authentication in the ETL tool Talend?

Teradata provides three Eclipse-based client tools, Teradata Studio, Teradata Studio Express, and Teradata Plug-in for Eclipse. All three products are built from the same code base and provide connectivity to your Teradata Database, but each has a different end user focus.

Teradata Studio Express 14.02 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata Studio 14.02 is now available for download. Teradata Studio is an administration tool for creating and administering database objects. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Plug-in for Eclipse) . The 14.01.00 release builds on the 14.00.00 offering by boasting increased functionality.

SQL provides a set of useful functions, but they might not satisfy all of the particular requirements you have to process your data.

User-defined functions (UDFs) allow you to extend SQL by writing your own functions in the Java programming languages, installing them on the database, and then using them like standard SQL functions.

SQL provides a set of useful functions, but they might not satisfy all of the particular requirements you have to process your data.

User-defined functions (UDFs) allow you to extend SQL by writing your own functions in the Java programming language, installing them on the database, and then using them like standard SQL functions.

SQL provides a set of useful functions, but they might not satisfy all of the particular requirements you have to process your data.

User-defined functions (UDFs) allow you to extend SQL by writing your own functions in the Java programming language, installing them on the database, and then using them like standard SQL functions.

Hi everyone,
We're trying to connect to our teradata database through Java using TMODE=ANSI, and it's throwing the following error:

Hi Teradata gurus,
 
I have developed a process in Java that read some files, add some fields, and load in some pipes to my TPT script.
In my tests I'm loading 6 pipes with 6 separeted Threads.
To load this I have these Producer Operators:

Hi Teradata Masters,

I'm trying to provide data to be consumed by a Load Operator in my TPT script throught a named pipe.
My DATACONNECTOR Producer: (all runs local on Windows)

    DEFINE OPERATOR PIPE_READER()
    DESCRIPTION 'Define opcoes de leitura de arquivos'
    TYPE DATACONNECTOR PRODUCER
    SCHEMA T701S020_SCHEMA
    ATTRIBUTES
    (

Teradata Studio 14.01 is now available for download. Teradata Studio is an administration tool for creating and administering database objects. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata Studio is a client based graphical interface used to perform database administration tasks on Teradata and Aster Databases, as well as copying data between Aster, Teradata, and Hadoop Database Systems. Teradata Studio is built on the Eclipse® Rich Client Platform (RCP), taking advantage of the RCP framework for building and deploying native GUI applications. It extends the Eclipse Data Tools Platform (DTP) to enhance Teradata Database access. Teradata Studio can be run on Windows, Linux, and Mac OSX operating systems. The Eclipse platform is designed as an open tools platform but architected so that its components (or a subset of its components) can be used to build RCP applications. This allows Teradata Studio to benefit from the many high quality Eclipse features available while focusing on value-add for Teradata.

With the Studio 15.11 release, a new user interface was introduced in the Administration Perspective. Refer to the article, New Studio Administration User Experience for more information.

In addition to this article, there is a Teradata Studio User Guide document now available on the Teradata Studio Download page.

Teradata Studio Express 14.01 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Plug-in for Eclipse) . The 14.01.00 release builds on the 14.00.00 offering by boasting increased functionality.

Data Mover is a Teradata Application that allows users to copy databases or tables between Teradata systems. It is a JEE based application that is composed of three major code components: the Client (Command-line interface or Viewpoint portlet), the Daemon, and the Agent.

So you are testing or developing in a Teradata Express 13 or a general Teradata environment and you are anxious to integrate your Java code into your Teradata DB using Java UDF extensibility...just to find yourself in an errors-headache with things like:

- 7583 The secure mode processes had a set up error

Dear All,

I am trying to create an external stored procedure using JAVA but keept getting NoSuchMethodException.

I am using windows 7 to compile and create the JAR file (client)

My teradata is running on SUSE Linux(server)

My java class is: