In my prod environment "SELECT * FROM DB.TBL1" is getting failed with error "SELECT Failed 3610: Internal error. Please do not resubmit the last request. SubCode: 0, 3701". Same query is running in my DEV environment.
This table has 42 columns.
SEL col1,col2, col3, col4 ... FROM DB.TBL1;
col3: DECIMAL(12,0) COMPRESS
col4: YR SMALLINT TITLE 'YEAR'
When I comment either col3 or col4 select is giving ouput else getting failed with the above error.
Please suggest me on this.
There might be different patch levels in dev and prod. If dev has a higher patch this issue might been fixed already and you just need to upgrade prod, too.
Otherwise open an incident with Teradata support.
In both cases contact your DBA.