CREATE EXTERNAL TABLE IF NOT EXISTS default.invoice (
  `cust_id` string,
  `invoice_id` string,
  `dated` string,
  `from` string,
  `to` string,
  `amount` decimal,
  `sgst` decimal,
  `total_amount` decimal,
  `amt_words` string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = ',',
  'field.delim' = ','
) LOCATION 's3://snt-csv/'
TBLPROPERTIES ('has_encrypted_data'='false');