使用 Alteryx Designer 在 Athena 中创建/删除表
有没有办法从 Alteryx Designer 在 Athena 中删除和创建表？我认为使用 connect In DB 节点并写入会非常简单
drop table test
但是我收到以下错误
Connect In-DB (3) Error SQLPrepare: [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 130, HTTP Response Code: 400, Exception Name: InvalidRequestException, Error Message: line 1:30: mismatched input 'drop'. Expecting: '(', 'LATERAL', 'UNNEST', <identifier> [Execution ID: ]
有没有办法呢？谢谢
is there way to drop and create tables in Athena from Alteryx Designer? I thought it would be dead simple using the connect In DB node and writing
drop table test
But I'm getting the following error
Connect In-DB (3) Error SQLPrepare: [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 130, HTTP Response Code: 400, Exception Name: InvalidRequestException, Error Message: line 1:30: mismatched input 'drop'. Expecting: '(', 'LATERAL', 'UNNEST', <identifier> [Execution ID: ]
Is there a way to it? Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我会在输出数据工具中使用 Athena Bulk Loader。
这有您需要的功能。
数据连接>亚马逊雅典娜>批量
I would use the Athena Bulk Loader in Output Data tool.
This has functionality you need.
Data Connections > Amazon Athena > Bulk
不允许使用 connect In DB 节点并编写删除查询...仅允许选择类型查询。
（顺便说一下，数据库不支持 Athena，参见 支持 Athena 的想法
所以你必须使用批量加载的标准输出工具
在此处输入图片描述
谨致问候，
西蒙
Using the connect In DB node and writing a drop query is not allowed... only select type queries are allowed.
(and by the way,Athena is not supported for in database, cf Ideas to support Athena
So you must use standard output tool with a bulk load
enter image description here
Best regards,
Simon