forked from docs/doc-exports
chenxiaoxiong
f9e2808b7c
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: chenxiaoxiong <chenxiaoxiong@huawei.com> Co-committed-by: chenxiaoxiong <chenxiaoxiong@huawei.com>
29 lines
3.6 KiB
HTML
29 lines
3.6 KiB
HTML
<a name="dataartsstudio_01_0209"></a><a name="dataartsstudio_01_0209"></a>
|
|
|
|
<h1 class="topictitle1">Converting Unsupported Data Types</h1>
|
|
<div id="body8662426"><div class="section" id="dataartsstudio_01_0209__en-us_topic_0000001569858182_section172952520194"><h4 class="sectiontitle">Scenario</h4><p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p1785089151911">When field mapping is configured on CDM, a message is displayed indicating that the data type of the field is not supported and the field needs to be deleted. If you need to use this field, you can use SQL statements to convert the field type in the source job configuration to the type supported by CDM for data migration.</p>
|
|
<p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p1246611429254"><span><img id="dataartsstudio_01_0209__en-us_topic_0000001569858182_image123814191167" src="en-us_image_0000002269194845.png" title="Click to enlarge" class="imgResize"></span></p>
|
|
</div>
|
|
<div class="section" id="dataartsstudio_01_0209__en-us_topic_0000001569858182_section24182034192318"><h4 class="sectiontitle">Procedure</h4><ol id="dataartsstudio_01_0209__en-us_topic_0000001569858182_ol1691145282319"><li id="dataartsstudio_01_0209__en-us_topic_0000001569858182_li591105216231"><span>Modify the CDM migration job and enable <strong id="dataartsstudio_01_0209__en-us_topic_0000001569858182_b9979173718165">Use SQL Statement</strong>.</span><p><p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p152291534172013"><span><img id="dataartsstudio_01_0209__en-us_topic_0000001569858182_image1022915346208" src="en-us_image_0000002269114769.png" title="Click to enlarge" class="imgResize"></span></p>
|
|
<p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p851771618244"></p>
|
|
<div class="note" id="dataartsstudio_01_0209__en-us_topic_0000001569858182_note139031023164915"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p5281413256">The SQL statement format is as follows: <strong id="dataartsstudio_01_0209__en-us_topic_0000001569858182_b18492163911711">select id,cast</strong>(<em id="dataartsstudio_01_0209__en-us_topic_0000001569858182_i17592104511176">Original field name</em><strong id="dataartsstudio_01_0209__en-us_topic_0000001569858182_b1259725131712"> as INT) as</strong> <em id="dataartsstudio_01_0209__en-us_topic_0000001569858182_i3167134151816">New field name, which can be the same as the original field name</em> <strong id="dataartsstudio_01_0209__en-us_topic_0000001569858182_b11728122612187">from schemaName.tableName;</strong></p>
|
|
<p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p112811113457">Example: select `id`, `name`, cast(`gender` AS char(255) ) AS `gender` from `test_1117869`.`test_no_support_type`;</p>
|
|
</div></div>
|
|
</p></li><li id="dataartsstudio_01_0209__en-us_topic_0000001569858182_li1787311544235"><span>Wait for the fields to be converted to the data types supported by CDM.</span><p><p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p1683153717248"><span><img id="dataartsstudio_01_0209__en-us_topic_0000001569858182_image38353712417" src="en-us_image_0000002234235396.png" title="Click to enlarge" class="imgResize"></span></p>
|
|
<p id="dataartsstudio_01_0209__en-us_topic_0000001569858182_p169011347247"></p>
|
|
</p></li></ol>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dataartsstudio_01_0110.html">Key Operation Guide</a></div>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
<script language="JavaScript">
|
|
<!--
|
|
initImageViewer('.imgResize');
|
|
var msg_imageMax = "view original image";
|
|
var msg_imageClose = "close";
|
|
//--></script> |