I am getting a 3577: row size or sort key size overflow when attempting to query dbqlsqltbl.sqltextinfo in sqla (yes it is a large query). Does anyone have any workarounds.
Which version of Teradata are you on?
I faced a smiliar kind of issue some time ago on I guess V2R6, as the size of column definition that was selected was expected to grow beyond 65K row limit and thus the TD was aborting the error.
I couldn't find any specific solution at that time other than breaking up the SQL in multiple sets!
how do you access that column? Only in the Select list?
It's defined as a UNICODE VARCHAR(32000), which is already close to the maximum eowsize of approx. 64K.
I am facing a similar issue. I have 2 tables A and B and they each have 60 columns each. When I run the below statement in Teradata Studio, I get the error 3577: row size or sort key size overflow, however when I run the same in SQL Assistant, it runs fine. Could you let me know, why Teradata Studio throws error?
Below is the query
FROM db_1.ABC a,
WHERE a.A1 = b.A1;
it's probably because Studio uses a UNICODE charset, too.
Check the definition of the tables if they include some large VarChars in LATIN.
In layman’s term, if you are using “Select *”, you are displaying every column in every table you are joining. This message is saying I have reached my limit of columns to display. What I did is start getting specific to which columns I want to display. As I am joining new tables and want to see every column in the new table I just joined I do the following:
ztype.name as ENC_TYPE,
cser.prov_name as AUTHORIZING_PROVIDER,
Hope this helps.
Hi. Can you please help me with the following query?
select oreplace(leapra.imp_impo/100 (format 'Z(7)9.99') (char(11)),'.',',') imp_impo,
oreplace(leapra.imp_fin/100 (format 'Z(7)9.99') (char(11)),'.',',') imp_fin,
you need to CAST the result of the oReplace to a shorter VarChar, in TD14 it's VARCHAR(8000) UNICODE.
Or you use TO_CHAR to switch comma and period:
TO_CHAR(x, '9999D99','NLS_NUMERIC_CHARACTERS = '',.''')