0 - 42 of 42 tags for export

Hi, 

 

I need to export few chinese and japanese characters stored in teradata to a file.

 

I have tried different options to export data through TPT but i am either not able to see the unicode characters in the generated file or i face the conflicting data length error.

 

Hi, 
 
I am using TPT to export data to a file and move into S3 buckets., am curious to know if there is a way to export data and write directly into AWS S3 buckets.
 
Thanks & Regards,
Srivignesh KN

Hello,
when running the ncluster_export for a database object containing uppercase letters, the object name gets translated to lowercase even if double quotes are used, resulting in a failure to find the object.
Example:
 

This package contains the Aster client tools for Windows.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for Solaris.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for MacOS.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for Linux.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for AIX.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

Hi,

Hello experts,

 

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

I'm running the latest  TeradataStudio__mac_x86.15.10.00.01 on OSX 10.10 and when pulling resusage from customer site I get the data back in the results window, but then if I want to export it to disk I click on this and get the black/white ball and studio goes off into a spin for about 5 muntes then eventually comes back with nothing.

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

Hi All,
Can we export multiple select statements into respective files using TPT. If yes, could you please provide sample code.
 
Thanks

Friends, I need to export a table between two servers, but I get the following error in trasnfer history:

Starting Load...

Starting Export...

Copy Table Data Task

Opening connection...

Writing data...

Data extracted successfully with Warning(s)

539133 Rows Exported

 

 

Hello good people
I have a table of ~77 million rows that I need to export to fixed width text files, however I need to impose a limit of 5 million rows per file.
I am currently achieving this with "SELECT * FROM MYTABLE QUALIFY ROW_NUMBER() OVER(ORDER BY COL1 ASC) BETWEEN 1 AND 5000000"

Hi all,
 
I need to export data from Teradata to text files (Windows).
The first one is a .BAT file that only call the BTEQ application:
1 - bteq < file.sql
 
The second one exports the data:
2 -
.logon myhost/myuser,myuser

 

.EXPORT FILE=out.txt

select col1, col2

I have a CSV file that I'm attempting to load via TPT.  I have created the CSV file in Excel.  When I try to load the file with the appropriate number of delimiters, I am getting a BUFFERMAXSIZE error.  When I add another delimiter to the end of each record, the file loads just fine.

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 All,

 

I have used TRIM ( BOTH FROM string_name) command to remove extra character / space coming in export file but it is not working. could you please help to resolve this issue ?

 

.set format on;

.set width 1000;

.set pagelength 100000;

.set heading '';

.set footing '';

Hi,
I am exporting a large amount of data into a file.The specification is like each column should be seperated by pipe.If there is no data,there should be space.(| |)
I need file in this format
if there is data it should be like this

I've recently begun working with Teradata Studio Express after about a year of working with SQL Assistant. My primary use of Teradata is for BI applications such as ad-hoc reporting.

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.

 

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

Can we export data in excel format using bteq ?

Hi,
I am trying to export data from oracle to Teradata.I use the following script to load data to flat file
 
 
 
CONNECT usr_id/pwd
SET SPACE 0
SET LINESIZE 300
SET PAGESIZE 500
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING ON
SET COLSEP '|'

Hi,

I am trying to export SQL output to excel file using .export DIF. I am getting SQL output but coulumn header is getting supressed. REPORT option outputs column header but output in excel is in a single row so not desirable. 

Anyone has idea on how to output column header using .export DIF?

Hi there,

Can TPT be used to export ASCII data as UTF-8... ? Meaning, the data stored in the TD DB table is ASCII, but we want a flat file export that is in UTF-8 Format. Is this possible?

As far as I have seen in the TPT User Guide, it appears that the character set of data and export file should be the same.

 

 

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

Here is the source data declaration:

Hi,  I'm new to Teradata and need to do the following:

I'm on a Unix system, using verision 13.0. 

We're inserting data into the "Stage" table from a delimited text file (bell is the delimeter \007)

1.  export the dataparcel field from the _ET table to a file  (delimited text if possible)

If you’re waiting for an easy way to load data from one or more Teradata table(s) into a Teradata table without writing a Teradata PT script, wait no further.  Teradata PT Easy Loader can do it easily.  In the 14.0 release, the tool can load data from a Teradata table or from SELECT statement(s).

Teradata FastLoad has a feature named Tenacity that allows user to specify the number of hours that FastLoad continues trying to log on when the maximum number of load operations is already running on the Teradata Database.

By default the Tenacity feature is not turned on. The feature is turned on by the script command:

Hi all,

        I would appreciate if some one can give the insight to this problem.

I was trying to export DDLs for the existing tables. I wrote a bteq script as follows. Although width is set to 20000, it exports partial row. I tried to increase width size to max 60000, still I have no luck. It exported same partial rows.

Can somebody point me what is wrong in this bteq?

-----------------------------

.logon
.set width 20000
.set titledashes off

.export report file=cm_crt_table.sql

select requesttext(title '') from DBC.TABLES where databasename='WRK_DB' and tablename like 'CM%';

.export reset

.logoff

.quit

Using these settings the results of my SQL ran using Bteq is written to a file with no column headers, the only thing I can't figure out is how to get rid of the 10 spaces that are written to the export file before the results of the SQL.

I can export some fairly large queries in SQL Assistant JAVA edition, but there appears to be a soft limit somewhere around 20 Meg where it just cuts off and creates an empty file. The results appear to be accurate, the export unwilling.

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;

Windows 7 64-bit
Teradata v12
SQLA Java 64-bit

I am trying to export a view that contains about 3500 rows, but I am having a hard exporting the entire result set outside of what is being displayed.

1.
Currently SQLA only displays 500 rows, which is OK. When I select export all to excel, I was expecting to see all 3500 entries, but instead I end up with the 500 displayed rows only. How can I export all rows?

2.
I have tried modifying the display result to 5000 instead of default of 500, but SQLA still displays 500 only. Is this a bug in the tool or am I doing something wrong?

Hi,
I am wondering if there is a way to export TUN data sets from "Teradata SQL Assistant" into the local database.
If this is possible, please instruct me how to.
Thank you,

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.