I am trying to load AREA table using fastload (data file is exported using BTEQ and mode DATA).But I am getting warning message saying EOF on INPUT stream.
below are warning message and scripts:
*** 13:22:41 Number of recs/msg: 338
*** 13:22:41 Starting to send to RDBMS with record 1
*** 13:22:41 Sending row 5
*** 13:22:41 Finished sending rows to the RDBMS
*** 13:22:41 Warning: EOF on INPUT stream.
Fast load script:
set record formatted;
begin loading sample.area
insert into sample.area values(:N_NATIONKEY,:N_NAME,:N_REGIONKEY,:N_COMMEN
.export data file=bteq_outfile_data.txt
select * from sample.area1 ;
Can any one have any idea or some info related to it....please share with me....thanks
This was a warining - not an error.
So had all rows been loaded correctly into the table?
It would be good if you can share the whole log of the run and also the DDL of the table..
I could see a blank for N_NAME in the second row of the i/p file - Try removing this record and run it..
Also there are too many symbols in the i/p file that you had provided...If its a copy paste error,can you share the i/p file again..
Thanks for your replies but still I am not able to laod data.
Below is the complete log of my Fastload run
C:\Documents and Settings\kusuma\Desktop\Practice\Fastload>fastload < Fa
= FASTLOAD UTILITY VERSION 13.00.00.004 =
= PLATFORM WIN32 =
= Copyright 1984-2009, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
**** 15:37:42 Processing starting at: Mon Mar 12 15:37:42 2012
0001 logon 127.0.0.1/kusumanew,
**** 15:37:42 Teradata Database Release: 13.00.00.12
**** 15:37:42 Teradata Database Version: 13.00.00.12
**** 15:37:42 Current CLI or RDBMS allows maximum row size: 64K
**** 15:37:42 Character set for this job: ASCII
**** 15:37:43 Number of FastLoad sessions connected = 2
**** 15:37:43 FDL4808 LOGON successful
0002 set record formatted;
**** 15:37:43 Now set to read 'FORMATTED' records
**** 15:37:43 Command completed successfully
file=C:\Documents and Settings\kusuma\Desktop\Practice\BTEQ\bteq_o
**** 15:37:43 FDL4803 DEFINE statement processed
0004 begin loading kusumanew.area
**** 15:37:43 FastLoad is continuing a multifile job
**** 15:37:43 Number of AMPs available: 2
**** 15:37:43 BEGIN LOADING COMPLETE
= Insert Phase =
0005 insert into kusumanew.area values(:N_NATIONKEY,:N_NAME,:N_REGIONKEY,:N_COMM
**** 15:37:43 Number of recs/msg: 338
**** 15:37:43 Starting to send to RDBMS with record 1
**** 15:37:43 Sending row 5
**** 15:37:43 Finished sending rows to the RDBMS
**** 15:37:43 Warning: EOF on INPUT stream.
**** 15:37:43 Logging off all sessions
**** 15:37:44 Total processor time used = '0.328125 Seconds'
. Start : Mon Mar 12 15:37:42 2012
. End : Mon Mar 12 15:37:44 2012
. Highest return code encountered = '4'.
**** 15:37:44 FastLoad Paused
and DDL of AREA Table:
CREATE SET TABLE kusumanew.AREA ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
N_NATIONKEY INTEGER NOT NULL,
N_NAME CHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
N_REGIONKEY INTEGER NOT NULL,
N_COMMENT VARCHAR(152) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)
UNIQUE PRIMARY INDEX ( N_NAME );
I have removed that row which have null for one column but no use and BTEQ exported data file had some spaces ,I removed and tried to load I received the following o/p
insert into kusumanew.area values(:N_NATIONKEY,:N_NAME,:N_REGIONKEY,:N_COMM
15:48:59 Number of recs/msg: 338
15:48:59 Starting to send to RDBMS with record 1
15:48:59 I/O Error on File Read: 16, Text: Unexpected data format
15:48:59 Logging off all sessions
15:49:00 Total processor time used = '0.34375 Seconds'
. Start : Mon Mar 12 15:48:58 2012
. End : Mon Mar 12 15:49:00 2012
. Highest return code encountered = '12'.
15:49:00 FastLoad Paused
Did you anytime try to load data using fastload which is exported using BTEQ DATA mode?
Am I doing anything wrong here?
you missed two ; at the end of the script...
it should be