· 4 years ago · Dec 23, 2020, 02:36 PM
1CREATE SCHEMA IF NOT EXISTS practica2;
2
3CREATE EXTERNAL TABLE IF NOT EXISTS practica2.station_data
4(IDPROVINCIA STRING,
5SPROVINCIA STRING,
6IDESTACION STRING,
7SESTACION STRING,
8FECHA STRING,
9DIA STRING,
10TEMPMAX STRING,
11HORMINTEMPMAX STRING,
12TEMPMIN STRING,
13HORMINTEMPMIN STRING,
14TEMPMEDIA STRING,
15HUMEDADMAX STRING,
16HUMEDADMIN STRING,
17HUMEDADMEDIA STRING,
18VELVIENTO STRING,
19DIRVIENTO STRING,
20RADIACION STRING,
21PRECIPITACION STRING)
22ROW FORMAT DELIMITED
23FIELDS TERMINATED BY ';'
24STORED AS TEXTFILE
25LOCATION 'hdfs://0.0.0.0:9000/user/hive';