Unable to fetch the last coloumn using Athena

Question

{"name":"Shuvodip","age":28,"subject":"AWS"}

{"name":"Nabarupa","age":23,"subject":"Azure"}

I created an external table using the following commands:

CREATE EXTERNAL TABLE IF NOT EXISTS sampledatabase.testdb (
  `name` string,
  `age` int,
  `subjects` string
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
) LOCATION 's3://jino/jino1/'
TBLPROPERTIES ('has_encrypted_data'='false');

I am not getting the last entry.

Answer 1

the error that i found was with the entry name:

in you json file you have subject but in external table you have subjects hence i cant find the entry related to it.

CREATE EXTERNAL TABLE IF NOT EXISTS sampledatabase.testdb (
  `name` string,
  `age` int,
  `subject` string
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
) LOCATION 's3://jino/jino1/'
TBLPROPERTIES ('has_encrypted_data'='false');

This worked absolutely fine.

Hope it helped you too!