Hi @Haijin Li The input file you are using is incorrect stock2.json {"myid":"0001","mytype":"donut"} command is correct CREATE EXTERNAL TABLE stock4_json (myjson struct<myid:string, mytype:string>)ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' LOCATION '/warehouse/tablespace/external/hive/haijintest.db/stock2'; myjson struct define it is having further list and map. You have to place correct input file stock3.json {"myjson":{"myid":"0001","mytype":"donut"}} and create table with same command and check. Let me know if still you are facing issue. Regards, Vinay K ... View more

Hi @PJ It depends on you, how you define policies for hive DB. You may restrict by multiple ranger policies. What is your exactly question can you explain it? ... View more