text datatype not supported and data having huge data in text filed how to bring it over
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2023 01:01 PM
Hello all,
I have medical field data file and one of the field is the text field with huge data not the big problem is databrick does not support text data type so how can i bring the data over. i tried conversion, cast in various way but so far not successful.
I tried importing data (about 2.5 million records) but once migration over to delta table it becomes 85 mil records because it breaks the text field in multiple rows...
what is the proper way!! please guide.
Labels: