https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237246#M25739 <P>i understand we can change the datatype, does "LONG" with length 19 in talend causes data truncation while reading if the underlying RedShift table attribute has value of 38 digits ?</P> Fri, 22 May 2020 02:55:42 GMT Anonymous 2020-05-22T02:55:42Z https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237244#M25737 <P>My RedShift table column is defined as INT8 which is BigInt supposedly numeric(38,0). But when we import the table into Talend it is showing as LONG length of 19 ??</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ma04.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142500i4DC7AFF0CE92A66A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ma04.png" alt="0683p000009Ma04.png" /></span></SPAN></P> Sat, 16 Nov 2024 02:31:24 GMT https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237244#M25737 Anonymous 2024-11-16T02:31:24Z https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237245#M25738 You can change the data type in talend ,which is correct. Tue, 05 May 2020 01:45:52 GMT https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237245#M25738 manodwhb 2020-05-05T01:45:52Z https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237246#M25739 <P>i understand we can change the datatype, does "LONG" with length 19 in talend causes data truncation while reading if the underlying RedShift table attribute has value of 38 digits ?</P> Fri, 22 May 2020 02:55:42 GMT https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237246#M25739 Anonymous 2020-05-22T02:55:42Z https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237247#M25740 <P><A href="https://community.qlik.com/s/profile/0053p000007LQLeAAO">@Ariean</A>&nbsp;, what is the redshift data type?</P> Fri, 22 May 2020 05:04:24 GMT https://community.qlik.com/t5/Talend-Studio/Question-on-DataType/m-p/2237247#M25740 manodwhb 2020-05-22T05:04:24Z