0 - 26 of 26 tags for import

Using TDCH, What is the best way to import multiple tables into Hive from Teradata? Is there an option to move an entire database from Teradata to Hive?

I have a very simple working MLOAD and have a new requirement to block data from being INSERTED.  I see many examples where the WHERE of an APPLY statement is specified as equality (=) and am sure I've done that in the past successfully, but my new requirement is to skip based on 'not equal to'.
 
 
Layout of file:

Hi, i have a bteq which uses repeat function to load a file into a table. we have a parameter for the input file. if the parameter is not available, the script is failing with a Return code 0, inspite of using the label to exit if errorcode <>0.

I read about a super fast way to IMPORT using Dot Net.

 

http://bit.do/tera14

 

Q: Will this be incorporated into Teradata SQL Assistant?

 

 

Thanks for any leads. I really appreciate it!

Jim

Hello All,
I am trying to load a file with aroun 12 million records to an empty table and I tried using BTEQ.
I am included begin transaction & end transaction statements in my BTEQ import script.
However,  the script after sometime stating "Error 9128: Transaction exceeds max. number of Row Hash locks".

Dears,
I am trying to compare test query results with my BO Report data. So I have exported my BO report data into Excel/csv and the same needs to be imported to Teradata temp table; Finally I will excute minus query between my test query and imported BO data.

Hello experts,

 

I have a problem using import and export with bteq. I have the following simple table in DB1 and DB2:

Hello,
I've recently upgraded to SQL Assistant v14.0. In v13.10 I had no trouble running the following query (statement by statment). Now I'm having trouble because I get an error that says "Error executing query for record 1: 3706: Syntax error: expected something between ')' and the integer '1'.
Here is the sql:

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.

Hi,

 

I am trying to export the table to a data file, clear the table and use ".import data file" to import the data back in.  I always got the following error if the table has a "not null" column. 

 

*** Failure 2673 The source parcel length does not match data that was defi

 ned.

 

I have a file I am loading to a table in my database via TPT. Everything is working properly, however I am dropping records where the date format is m/d/yyyy (as opposed to mm/dd/yyyy). Is there a way, in the insert statement in APPLY to convert the field on the fly via CASE, CAST, or some string manipulation?  

Overview of Unity Source Link

Unity Source Link (USL) allows reads and joins from an external or foreign database to Teradata Database without requiring data replication in the Teradata data warehouse. USL can be used to:

TD Geo Import/Export tool lets you translate ESRI Shape and KML files to TD format.

Hi, I am trying to import data from a text file using a SQLAssitant. But it is giving me an error as the string contains ",".
I am using this below syntax for inserting:
 

CREATE VOLATILE TABLE kumar_test (a INTEGER, b VARCHAR(100))

PRIMARY INDEX  ( a );

 

INSERT INTO kumar_test(?,?)

 

I am trying to import some data and it keeps giving me a format error. Is this because I am not including the column headers? Thanks for the help!

Hi. I want to export data from one place and import it to other. 

Here is the source data declaration:

Hi

I been testing the FastExport and Fastload Teradata tools and I am finding that data import using fastload is very slow for a particular table.

The process is as follows:

When using BTEQ or SQL Assitant to upload data into tables, I'm only getting about 2 records per second speed. Unfortunately, I don't have access to Fastload. I know its not the network as my down speed is blazing and Oracle is uploading normally.

Hi all,
I want to ask, is there any way to import MYSQL Database or MYSQL dump file into Teradata using any scripts like FLoad or using OleLoad utility?

.LOGTABLE sample_log;
.LOGON hostname/user,password;
DROP TABLE WT_sampletable;
DROP TABLE ET_sampletable;
DROP TABLE UV_sampletable;
.BEGIN IMPORT MLOAD TABLES sampletable
CHECKPOINT 1000000 SESSIONS 4;
.LAYOUT TRANSACTION;
.FIELD filed1 * CHAR(11) NULLIF field1 = '';
.DML LABEL DELETE;

I am brand new to Teradata and SQL and have a rather basic question. I am reading the book "Teach yourself SQL in 10 minutes" and am trying to import some sample data into Teradata so I can follow along with the examples in the book. The book has a number of different downloads available, but none of them specifically say Teradata.

Hi,

I am using the bteq import export option,I have followed the following steps in order:

Step 1
------
export data from table to file

.set width 900
.export data file=myoutput.txt
Select item_id from
db.tab1
sample 10;

.export rest;

Step 2
------
creating a new table

create table db.tab2
(item_id integer)
;

Step 3
-------
import data from file to table

.import data file=myoutput.txt,skip=3
.quiet on
.repeat *
using item_id(integer)
insert into db.tab2
(item_id
)
values
(
:item_id
);
.quit;

This book provides reference information about BTEQ (Basic Teradata Query), a general-purpose, command-based report and load utility tool. BTEQ provides the ability to submit SQL queries to a Teradata Database in interactive and batch user modes, then produce formatted results.

This book provides information about Teradata MultiLoad, a product that provides an efficient way to deal with batch maintenance of large databases. Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in a Teradata Database.