Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Unable to upload data into hadoop

Highlighted
Asteroid

Hi,

 

I am getting errors when uploading data into Hadoop with column names starting with number. I have used backticks to get around the issue but it still shows the below error.

 

Error: Output Data (9): The field "`0ac_doc_typtxtmd`" contains nonalphanumeric characters and is not allowed for this datasource.

 

Any ideas? Thanks.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @sagarb 

 

Try to remove the ` character in the Field Name

 

`0ac_doc_typtxtmd` to:

0ac_doc_typtxtmd

 

Cheers,

Highlighted
Asteroid

 @Thableaus I inserted the backtick character because the columns had  number at the beginning of the column name

I created an Alteryx case for this. So, the solution is that, Alteryx connectors don't allow digits as the beginning of the column name while loading into Impala or Hive. I was told that the Alteryx Dev team will be changing that.

Labels