Athena通过aws cli从另一个数据库表创建视图

Question

从另一个数据库表创建视图。

aws athena start-query-execution --query-string "create or replace view view_table_name as select column1, column2 from "anotherDateBaseName".tableName" --work-group "workgroupName" --query-execution-context Database=databaseName,Catalog=awsCatalogName

尝试了上面的代码，并给出错误InvalidRequestException

Answer 1

使用下面的代码从cli从另一个表创建视图

aws athena start-query-execution --query-string "create or replace view view_table_name as select column1, column2 from "anotherDateBaseName".tableName" --work-group "workgroupName" --query-execution-context Database=databaseName,Catalog=awsCatalogName