Adding columns to Timestream table in the AWS web query editor

0

First...is it possible?

I am trying to add a column to a table called "MedFlaminator". I just created the table and it has the default layout. Two columns exist:

measure_name varchar MEASURE_NAME

time timestamp TIMESTAMP

My query looks like this:

alter table MedFlaminator add column feedback_score int

I have tried all kinds of combinations of this query. I am getting the following error:

10:58:16 AM Failed The query syntax is invalid at line 1:1 alter table MedFlaminator add column feedback_score int

What is wrong here?

flycast
질문됨 2년 전1715회 조회
1개 답변
0
수락된 답변

I found my answer. Although Timestream uses sql language the database tables are not managed the same way. Timestream tables get columns automatically added based on what data you send them. I highly recommend watching this deep dive (it really isn't that hard). This video is very, very worth while.

flycast
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠