· 6 years ago · Apr 27, 2019, 10:02 AM
1CREATE EXTERNAL TABLE IF NOT EXISTS dbace.ethernum (
2 `base` string
3)
4ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
5WITH SERDEPROPERTIES (
6 'serialization.format' = ',',
7 'field.delim' = ','
8) LOCATION 's3://bmedata/data/'
9TBLPROPERTIES ('has_encrypted_data'='false');