· 7 years ago · Mar 02, 2019, 08:28 AM
1CREATE EXTERNAL TABLE IF NOT EXISTS BME2019.Etherum2 (
2 block string ,
3 emisor string,
4 receptor string,
5 cantidad string
6
7)
8ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
9WITH SERDEPROPERTIES (
10 'serialization.format' = ',',
11 'field.delim' = ','
12) LOCATION 's3://bmedata/data/'
13TBLPROPERTIES ('has_encrypted_data'='false');