uQc8yaQp

1CREATE EXTERNAL TABLE IF NOT EXISTS testdb.worktable (
2field1 string,
3field2 string,
4field3 int,
5field4 string
6)
7ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
8WITH SERDEPROPERTIES (
9  'serialization.format' = '|',
10  'field.delim' = '|',  
11  'collection.delim' = 'undefined',
12  'mapkey.delim' = 'undefined',
13) LOCATION 's3://bucket_location'
14TBLPROPERTIES ('has_encrypted_data'='false');