Alteryx to Hive write Data Error : Field contains NonAlphanumeric character
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Good Day,
I have to write my output data to DataLake using HIVE ODBC connector. This is working fine when I tried with sample data.
But when trying to write huge data with more columns I'm facing an error with few fields.
Error :
The field "Booking_Status" contains nonalphanumeric characters and is not allowed for this datasource. "
I tried renaming the field name without spaces & with underscore but it doesnt help.
Field values has some characters like / ; , ( but these are valid and should not replace or remove those values). Please guide .Thanks in advance
- Labels:
- Database Connection
- Developer
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kumar_A
Check if you have any spaces in your field name?
According to the thread below, that was the cause.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yeah I have checked it. But my field name doesn't have any space or non-alphanumeric characters. No luck though
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you been able to solve this? Because I am facing the same question.
Thanks.
