"Primary Key required for Update option" for impala database

alvanhai

*I'm fairly new to Alteryx, so please bear with me and ask me to clarify anything I say that confuses you!* 

So I've been stuck on this error in my flow (shown below) that says "Primary Key required for Update option." The table in question is (to my limited understanding) an impala database which I access with the Hue editor. According to an article I read, Impala already assumes that the first attribute in a table is the primary key and I have enforced that in the table, so I do not understand why it is still giving me this error.

Figure 1: Flow with Input Configuration (and Table)

Figure 2: Flow with Output Configuration

Any ideas on how I can fix this issue?

Thableaus

Hi @alvanhai 

This is something required by Alteryx when you use the Update option in the Output tool, although I understand what you're saying.

It seems Impala doesn't support altering primary keys (https://stackoverflow.com/questions/56475209/alter-table-in-impala-make-a-column-a-primary-key) so it seems you need to pass the PK at the moment you're creating the table.

Cheers,