Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

NOT_SUPPORTED: Modifying Hive table rows is only supported for transactional tables

max1111
7 - Meteor
‎04-19-2024 03:56 AM

Hello!

 

I have created the table by Alteryx and now I need to remove specific records from this table in Athena, but when I am trying to do it I get the following error: NOT_SUPPORTED: Modifying Hive table rows is only supported for transactional tables

 

I am using the following query to do it: DELETE FROM database_name.table_name where pk_id in ('specific record')

 

Could you please advise how can I do transactional table by Alteryx, so I could remove specific records from it. 

 

Thank you in advance!

 

Labels:
Reply
0 Likes
1 REPLY 1
max1111
7 - Meteor
‎04-19-2024 08:32 AM

seems that Alteryx doesn't support transactional tables, so if you are appending data you can create the table via ddl in db (Athena in my case) updating the properties in the table: 'transactional'='true', but I get another error, not sure how to update the ddl, so I can delete the records from the table.

That is the latest error I get: NOT_SUPPORTED: AWSHiveMetastore does not support ACID tables

Reply
0 Likes
read certification FAQs
Labels
Top Solution Authors
View All