Hi I have hive table in one of the database A and want to create table in database B in hive. sample field and data:- event_ts - 17/04/2016 2:40:07 am cust_id - 30122 ban - 001 Detail_str - {"type_cd":"A","head_id":"283680","out_id":"1111","org_type_des":"Koo"} I want to copy this table and create hive table in database B like this event_ts cust_id ban Detail_str type_cd head_id out_id org_type_des So what kinds of query I need to generate to create Hive table in Database B? Thanks ... View more