I am not able to use enclosedby and escapedby arguments in Teradata hadoop connector. I get the following error when I pass these arguments. here I am trying to set enclosedby with a double quote and escapedby with forward slash. The error goes away when I remove the enclosedby and escapedby arguments.

I have a Hive table that is too big for my Teradata database, but if I can exclude some of the columns, it should be OK.  Since I don't want to have a duplicate copy of the table with fewer columns on my hadoop server I have two choices for import:    1) use a view to filter out the columns or    2) use a query to filter out the columns.

Hi All,
 
I was looking to download Teradata Loom. But seems it is not available to download. Can someone confirm if this is available or discontinued?
http://www.teradata.com/download-teradata-loom/?LangType=1033&LangSelect=true
 
Please reply !
 
Thanks
Kavin

Hello,
I am using teradata vesion of Prestodb 141t to connect to different data sources and one of my datasource is teradata but there aren't any documenatation about the connector. Does prestodb have the ability to connect to Teradata? If yes, how could i set up my connector?
 
Thanks, Siva. 

Hi,
I am trying to read data from Teradata DB in a MapReduce job using the JDBC Driver. I get the following exception/stack trace:
 
Provided connection string: jdbc:teradata://teradata/database=dbname
 

java.lang.ExceptionInInitializerError: null

Hi,
I have TD Studio 15.10, TD DB 15.0, HDP 2.0 and Aster 6.0. They are all connected well in TD Studio and I can see the tables.
I'm doing some tests on Aster based on a HDP table but when I execute the query:
 
SELECT * FROM load_from_hcatalog
(USING server('192.168.100.131')
port('9083')
username('root')

Hi.,
Are you looking for Big Data/Hadoop with Data Analytics & Data Science Training ..?,
Here i am the one & only source stop solution for all of your technical requirements.
I am in expert to provide training on below Data Science/Data Analytics/Big Data/Hadoop components like .,
HDFS & Map/Reduce

This training course is designed to provide knowledge and skills to become a successful Hadoop Administrator. It starts with the fundamental concepts of Apache Hadoop and covers topics such as the internals of YARN, MapReduce and HDFS, best practices for  preparing and maintaining Apache Hadoop in production. 

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 all,
I am trying to export data hive table to teradata table, Below is the command

hadoop com.teradata.hadoop.tool.TeradataExportTool

-url jdbc:teradata://testsystem/database=testdb

-username testuser

-password testpassword

-jobtype hive

-fileformat textfile

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.
 
 

I am trying to connect Mapr Hadoop and Teradata using TDCH. I have successfully installed the TDCH on MapR Hadoop.
Now I want to create new Connection Profile, but I am unable to see the Hadoop System option in Teradata studio 15. Please tell me how to get it.

Hadoop Market to Grow $50.2 Billion in Next 6 Years. This is the best time to take advantage and get trained in Hadoop. Register Now http://j.mp/hadoop-bangalore-training

Course starts on: 

2015-01-13 

and ends on: 

2015-01-16

Venue: 

Ibis Hotel,

Bangalore 

Contact: 

Good Evening,
 

Does TD SQL-H support reading ORC File tables?

OSSCube provides Hadoop Training.

Hadoop Enthusiasts! Get ready for our upcoming Cloudera Apache Hadoop development training in Bangalore on 27 Oct 2014

Registration: http://j.mp/hadoop-bangalore-training

Regards,                         

OSSCube India Marketing Team 

Hi,
I have a couple of questions regarding the Hadoop connectors:

• What connector do I need to integrate the Hadoop and Teradata using an ETL tool like Talend or Informatica PowerCenter?
• Can I use all of the 3 connectors side-by-side and deploy it in a sandbox environment?

 Regards,
Joseph

4Trainings is provides Hadoop Online Training Class course by excellent experienced IT professional trainers  who has more then 10+ Years of real time experience Our trainers are more dedicated professionals so that best quality output will be delivered. Our professionals cover each and every topic in Hadoop Online Training.

Hello,
I downloaded Aster v5 and v6 VM Images available from the download section and have been able to replicate the error on both. I'm logged in as aster
I have a single node hadoop cluster 2.2.0 with hive 0.12 (webhcat running on 50111). I can ping both machines and connectivity is good.

Hi All,
I am using teradata-connector-1.2.1 with the following versions:
->Teradata 14.0
->HDP 2.0(Hadoop 2.1.0.2.0.5.0-67)
->Hive 0.11
I am trying to import data from teradata tables to Hive.
 
/*Created table and inserted a row in teradata*/

Exporting data from a Teradata table to an Hive table using the studio (v14.10.01.201310271220) fails silently. Nothing happens since there is a bad parameter called within the tdch command launched.

Hi Masters,

This is a Hadoop/Teradata scenario. I'm looking for advise for a data migration from Hadoop to Teradata. The source data is supposed to be coming in form of delimited flat files. What are my best options for migrating data with best performance.

Module:    Thinking at Scale: Introduction to Hadoop

You know your data is big – you found Hadoop. What implications must you consider when working at this scale? This lecture addresses common challenges and general best practices for scaling with your data.

Module: MapReduce and HDFS

MAGNIFIC trainings are pioners in offering real time industrail experts hands on training on HADOOP BIG DATA online TRAINING.

 HADOOP technologies like HADOOP, ADOBE, BIG DATA, analytics training, SAP through webex ,team viewer & skype to serve the 

requests coming from all over the world.

I am trying to load data from hadoop to Teradata using tpt.
The delimiter in these files is the default hadoop delimiter (Cntrl-A - hex value 01).
Does tpt support this delimiter and how do I specify it?

Hi,
I am trying to connect Aster and hcatalog of hortonworks using the command load_from_hcatalog.
But evrytime I try to fire this query, it throws an error saying the following:

I have a ~250 node hadoop cluster containing a large data set that I want to move to Teradata as quickly as possible.  The target Teradata system has ~100 (recent generation) nodes.