Member since
03-22-2017
9
Posts
0
Kudos Received
0
Solutions
01-03-2018
05:39 PM
@Félicien Catherin The tutorial has typo... you need to create normal table first using following sytax: CREATE TABLE FIREWALL_LOGS( time STRING, ip STRING, country STRING, status INT )
CLUSTERED BY (time) into 25 buckets
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
LOCATION '/tmp/server-logs' TBLPROPERTIES("transactional"="true"); Once the above table is created you can convert it to ORC CREATE TABLE FIREWALL AS STORED AS ORC SELECT * FROM FIREWALL_LOGS;
... View more
03-23-2017
04:30 PM
7 Kudos
Below is one similar post which might help: https://community.hortonworks.com/questions/43502/hue-installation-hdp-24-and-rhel7.html
... View more