按照Blog 部署起来无法创建athena 表
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 30/100
Research direction
Start by reviewing the blog deployment instructions and the Athena database/table setup referenced by the failing CREATE VIEW statement. Confirm which table name the query is expected to use, then verify that the required table exists and that the view can be created successfully.
Written by the indexing model from the issue text.
Description
错误信息:
建语句:
CREATE OR REPLACE VIEW "aws_health_view" AS SELECT DISTINCT
"year",
"month",
"day",
"eventarn",
"service",
"communicationid",
"eventregion",
"eventtypecode",
"eventtypecategory",
date_format(date_parse(regexp_replace("starttime", ' GMT$', ''),'%a, %e %b %Y %H:%i:%s'), '%Y-%m-%d-%H:%i') AS event_starttime,
date_format(date_parse(regexp_replace("endtime", ' GMT$', ''),'%a, %e %b %Y %H:%i:%s'), '%Y-%m-%d-%H:%i') AS event_endtime,
date_format(date_parse(regexp_replace("lastupdatedtime", ' GMT$', ''),'%a, %e %b %Y %H:%i:%s'), '%Y-%m-%d-%H:%i') AS event_lastupdatedtime,
"language",
"latestdescription",
"entityvalue" AS "affected_resource",
"deprecatedversion",
(CASE WHEN (endtime IS NOT NULL) THEN 'Closed' ELSE 'Open' END) AS event_status
FROM
"Table Name"
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17
错误信息:
line 20:3: Table '12311000012312312.aws-health-event-records.table name' does not exist
此查询在“aws-health-event-records”数据库上运行,除非查询进行了限定。
- Dominant language
- Python
- Stars
- 1
- Forks
- 2
- Avg merge
- 3m
- Merged PRs (30d)
- 1
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Similar issues
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
stephrobert/dsoxlab#238 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
sublimehq/package_control#1780 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
nwg-piotr/nwg-displays#145 ·