Download JSON serde Jar file. move this file into your HDFS you can use below link for that. https://docs.aws.amazon.com/athena/latest/ug/json.html Move your .Json data into HDFS, create table in hive add required columns which you want to load. Use below command before creating table in hive to add jar file. add jar hdfs:///<path-to-serde>/<name-of-serde>.jar; CREATE EXTERNAL TABLE IF NOT EXISTS <your-table-name>(columns) ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' STORED AS TEXTFILE; ... View more