Site icon Rufa Fish Spa

AWS Athena Query Structure

I have a complex type and I want to query it using Athena

{id={s=c937b52e-fee8-4899-ae26-d4748e65fb5f}, __typename={s=Account}, role={s=COLLABORATOR}, updatedat={s=2021-04-23T04:38:29.385Z}, entityid={s=70f8a1a8-6f20-4dd3-a484-8385198ddf97}, status={s=ACTIVE}, createdat={s=2021-04-23T04:38:20.045Z}, email={s=dd@mail.com}, showonboarding={bool=true}, position={s=beta}, name={s=User2}, lastlogindate={s=2021-04-23T04:41:07.775Z}}

How to do it?

SELECT c.*
FROM "db"."table" c
LIMIT 10

returns all data in the table. However if I select like

SELECT c.id
FROM "db"."table" c
LIMIT 10

it shows the error.

Thanks in advance.

Exit mobile version