Alteryx to Hive write Data Error : Field contains NonAlphanumeric character

Question

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

Edu_XGomes · Answer

Have you been able to solve this? Because I am facing the same question.

Thanks.

Kumar_A · Answer

Yeah I have checked it. But my field name doesn't have any space or non-alphanumeric characters. No luck though

Qiu · Answer

@Kumar_A 
Check if you have any spaces in your field name?

According to the thread below, that was the cause.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Data-Stream-In-Tool-error-field-contains-non-alphanumeric/td-p/370826