Sample create table sql for Athena

gistfile1.txt

CREATE EXTERNAL TABLE IF NOT EXISTS table_name (
  Item struct <
    id:struct <
      S:string
    >,
    address:struct <
      M:struct <
        zip:struct <
          S:string
        >,
        city:struct < 
          S:string
        >
      >
    >,
    products:struct <
      L:array <
        struct <
          M:struct <
            sku:struct < 
              N:int
            >,
            price:struct < 
              N:int
            >,
            name:struct <
              S:string
            >
          >
        >
      >
    >
  >
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION '$location'
TBLPROPERTIES ( 'has_encrypted_data'='true');