|
View previous topic :: View next topic
|
| Author |
Message |
sindhu.jose
New User
Joined: 15 Jul 2009
Posts: 1
Location: kochi
|
|
|
|
Hello Team,
We are currently migrating data from AS400 to HIVE tables, using JAVA code. Can someone help me with the corresponding JAVA data types, for all the AS400 Datatypes as mentioned in www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/rzakb/ldata.htm .
Confusing ones are (UTF-8, UTF-16, UCS-2, Open (O), Only (J), Either (E), Graphic (G)).
Any help is appreciated !!!
Thanks,
Sindhu |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| Confusing ones are (UTF-8, UTF-16, UCS-2, Open (O), Only (J), Either (E), Graphic (G)). |
I'm not sure what is confusing you -- the site you referenced states
| Quote: |
| The data types J (only), E (either), O (open), and G (graphic) support DDS database files that use DBCS. The G (graphic) data type also supports DDS database files that use UCS-2 or UTF-16. The A (character) data type also supports database files that use UTF-8. |
and since UTF-8, UTF-16, UCS-2 are forms of Unicode (which Java uses natively), you shouldn't have much of a conversion issue with them. The conversion table in the site you referenced tells you how to convert each type you are confused about.
Your group may have to undergo significant and expensive conversion processing to get the data from AS400 formats to something HIVE will recognize and deal with. The costs and time for this conversion should have been considered in the initial project planning. |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
