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

JSON files are generated from twitter API using python now i want to load these files in HIVE tables but need to automate this process. ... View more